I had never investigated the SET OPTION sql function.  This should certainly
take care of the compiler settings for DON.

One note to Don, when I tried this the first time, I placed the "SET OPTION"
statements directly after my "H" specification.  The precompiler did not
like this.  I moved them to be the first "C" specs and everything work fine.


-----Original Message-----
From: Pete Hall []
Sent: January 08, 2002 05:35 PM
Subject: RE: SQL Error -183

At 09:07 01/08/2002, Michael Smith wrote:
>Doesn't work.
>.. snip ..
>H Datfmt(*ISO)

You need to tell the SQL pre-compiler what date format to use too. You can
either do it in the compile command, or you can code a SET OPTION (SQL
command). I usually do that along with the H spec in RPG so I don't have to
worry about compiler settings.

Pete Hall

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email:
To subscribe, unsubscribe, or change list options,
or email:
Before posting, please take a moment to review the archives

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.