RE: Embedded sql, multirow fetch and date column

Then I will remove the call to SetSqlOpt, but as the Set Options command is the first statement in the SQL-module, well, something else must be the problem with the date column.

Best regards

stefan.tageson@xxxxxxxx
M +46 732 369934

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Birgitta Hauser
Sent: den 1 maj 2016 10:11
To: 'RPG programming on the IBM i (AS/400 and iSeries)' <rpg400-l@xxxxxxxxxxxx>
Subject: AW: Embedded sql, multirow fetch and date column

The SET OPTION statement is never executed but only used at compile time.
You can interpret the SET OPTION statement as the H-Specs for embedded SQL.

Like the H-Specs the SET OPTION statement must be the first SQL statement in your source code.
Just add it immediately before the first C-spec in a source with a main procedure (Program) or before the first P-Statement/DCL-PROC in a NOMAIN source.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok) "What is worse than training your staff and losing them? Not training them and keeping them!"