Using Optio's SQL call facility

[Eric]

Using Optio\'s SQL call facility

From: "Toone, Stewart" <[email protected]>
To: "'JDE Mailing List'" <[email protected]>
Subject: Using Optio's SQL call facility
Date: Tue, 6 Feb 2001 11:26:54 -0000

I have a requirement to use Optio's SQL call facility to
output fields that
are not on the Dream Writer Output.

I am trying to extract the field PHORBY (Order Placed
By) from the Purchase
Order Header File and print it based on the Purchase
Order Number.

Previously when using the OCSERVER process I was
obtaining an SQL Syntax
error.

I am no longer getting this error but I am not getting
anything displayed on
the output either.

Here is the syntax that I am using.

SQL "Sqltest"
VENDOR "ODBC"
DATABASE "DURRUK"
ACCESSKEY "DURRUK"
SELECT PHORBY INTO $test FROM F4301
WHERE F4301.PHDOCO = $OrderNumber ;
END SQL

The Datbase is set up as a System DSN using Rumba DRDA
and the AccessKey is
set up on the Optio server.
The fields "test" and "OrderNumber" are Optio fields on
the output, preceded
with a dollar as indicated in their documentation.

It is the two lines "SELECT" and "WHERE" that I am not
sure of the syntax
of.

Has anyone got any experience of this ?


Stewart Toone
Durr Limited


----- End forwarded message -----