Eric
Active Member
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 -----
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 -----