RE: SQLRPGLE won't compile...

[rob@xxxxxxxxx]

This program compiles fine under V5R3.
     C/EXEC SQL
     C+ insert into rob/aaakey (LOC) VALUES('matt')
     C/END-EXEC
     C/EXEC SQL
     C+ Set Option
     C+     Naming    = *Sys,
     C+     Commit    = *None,
     C+     UsrPrf    = *User,
     C+     DynUsrPrf = *User,
     C+     Datfmt    = *iso,
     C+     CloSqlCsr = *EndMod
     C/END-EXEC
      /free
       *inlr=*on;
       return;
      /end-free

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Tyler, Matt" <mattt@xxxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
04/07/2005 09:18 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: SQLRPGLE won't compile...






That's quite humorous (to me any way).  It also says that in my V5.1 PDF
book (were actually at 5.2) and I never noticed that statement before 
this. 
I will definitely keep an eye on this.  Does 5.3 allow the SET OPTIONS to 
be
place anywhere also?


Thank you,
Matt Tyler
WinCo Foods, LLC
mattt@xxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Gina M Whitney
Sent: Wednesday, April 06, 2005 9:02 p
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: SQLRPGLE won't compile...

>> It must precede any other SQL statements.
>Not true.
The SQL Reference book states that "it is not executable and must precede
any other SQL statement."  Obviously, on your release the precompiler is
not enforcing it.   There is a high probability that in a future release
the precompiler will enforce this.  However, on a positive note, it comes
along with a few things that I know have been on your wish list. :-)


-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.