• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Using Optio's SQL call facility

Eric

Active Member
Using Optio\'s SQL call facility

From: "Toone, Stewart" <SDToone@durr.co.uk>
To: "'JDE Mailing List'" <jdeworldml@jdelist.com>
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 -----
 
Top