Re: Question on SQL Table (DDL) with date and time fields

I did not use fix format :)

Exec sql
insert into Pharmcrd (Phacctno, PhDiv, PhVndno, Phcrmno,
PhCrmdt, Phcrmamt, Phcrmddt, PhDocTyp,
PhVndtrm, Phclccrd, PhOvrAmt) Values(
:Wacctno, :Wacctdiv, :Wvndno, :Wcrdmno,
:Zcrdmdt, :Wcrdmamt, :Wduedt, :WDocTyp,
:Wvndtrms, :Wclccstcrd, :WOvrAmt);

SEU craps out on the Exec Sql line....as I said though, it compiles just
fine....so it has to be the editor.......

We are going to be moving to the gui interface....and what little I have
used it, its cumbersome and clunky.....




From:
rob@xxxxxxxxx
To:
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Date:
05/23/2008 09:26 AM
Subject:
Re: Question on SQL Table (DDL) with date and time fields



SEU? Gee, I hadn't used that in awhile. Let me fire it up. Oops Ctrl-F
didn't work to find SQL. Let's see... oh yeah, F16. Typed in this:
/free
exec sql select bubba into :bubba from myfile where mykey=:mykeyfld;

and SEU didn't blow me any grief. But on the last line of this it does
/free
exec sql select bubba into :bubba from myfile where mykey=:mykeyfld;
/end-free
/EXEC SQL

H'mm. Stop using fixed format?

V5R4
PTF Group Level Status
SF99540 8057 Installed
SF99539 69 Not installed
SF99504 15 Installed
SF99348 5 Installed
SF99347 18 Installed
SF99323 16 Installed
SF99321 1 Installed
SF99318 7 Installed
SF99317 7 Installed
SF99316 5 Installed
SF99315 8 Installed
SF99312 18 Installed
SF99311 10 Installed
...


Rob Berendt