RE: SQL loval date/timestamp

[Dave Boettcher <DBoettch@xxxxxxxxxxxxxxxx>]

I usually put it near the top, near D Specs and along with all Declares etc

Dave Boettcher

-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Tuesday, October 14, 2003 4:13 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: SQL loval date/timestamp


/copy's fine

I am not so sure on the position.  Is that a problem?

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




Joel Cochran <jrc@xxxxxxxxxx> 
Sent by: rpg400-l-bounces+rob=dekko.com@xxxxxxxxxxxx
10/14/2003 11:19 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: SQL loval date/timestamp






Excellent Rob!

Any chance I can put this in a /copy?  And can I assume it has to be
physically first in order of SQL statements?

Joel
http://www.rpgnext.com


On Tue, 2003-10-14 at 16:39, rob@xxxxxxxxx wrote:
> Then go with the flow.  Have you tried:
>      C/EXEC SQL
>      C+ Set Option
>      C+     DatFmt    = *Iso,
>      C+     Naming    = *Sys,
>      C+     Commit    = *None,
>      C+     UsrPrf    = *User,
>      C+     DynUsrPrf = *User,
>      C+     CloSqlCsr = *EndMod
>      C/END-EXEC
> 
> This is the precompiler's version of the H spec.
> 
> Rob Berendt

_______________________________________________
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.


_______________________________________________
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.