× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2024 by midrange.com 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.