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

V5R4 is our current release....as to the PTF's I have no clue.....a
different group is responsible for that.....as I said, it will compile it
is just the editor.....




From:
Luis Rodriguez <luis.rodriguez2@xxxxxxxxx>
To:
rpg400-l@xxxxxxxxxxxx
Date:
05/23/2008 10:32 AM
Subject:
Re: Question on SQL Table (DDL) with date and time fields



Doug,

As Rob and Charles wrote, WDSCi works /free very nicely :-)

That said, I just checked your statement with SEU (V5R3)
and did not get any error message(s). What release is your
system running?

BTW, let me state that I'm an old programmer, nurtured with
green screens, fixed format programming (when working with
RPG), etc. Please believe me. WDSCi ROCKS!!. If you are
working in /free format you'll love it. At first, as
everything, it takes a little time to be comfortable with
it. Later on, you will find it very difficult to return to
SEU.

Just be sure that your PC has enough resources (RAM, HD,
etc)

Regards,

Luis Rodriguez


--- rpg400-l-request@xxxxxxxxxxxx wrote:

------------------------------

message: 6
date: Fri, 23 May 2008 09:37:41 -0500
from: Doug Palme <>
subject: 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:

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?

<snip/>

</snip>

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


Doug Palme
Sent by:
05/23/2008 09:42 AM
Subject
Re: Question on SQL Table (DDL) with date and time fields
One thing I noticed though with /FREE and embedded sql is
that the SEU
editor balks at the EXEC SQL line......

You would think that IBM would have ensured no
problems......

From:
Luis Rodriguez
To:
rpg400-l@xxxxxxxxxxxx
Date:
05/22/2008 08:58 PM
Subject:
Re: Question on SQL Table (DDL) with date and time fields

Bruce,

It is available to V5R3 users, too, thru PTFs.

Regards,

Luis Rodriguez

------------------------------

message: 3
date: Thu, 22 May 2008 17:33:27 -0400
from: R Bruce Hoffman <bruce>
subject: Re: Question on SQL Table (DDL) with date and
time fields

Free format is V5R4, there are no C's in column 6, no

"+"

signs in
column 7 and instead of end-exec, you use a semi-colon,
but you still
use EXEC SQL to begin the statement.


Doug Palme wrote:

I appreciate that Luis, and that very well may be the

way I

go....especially since I am so far unable to get the

embedded SQL to work

in free format, and I am not going to change that

LOL.......

I am liking free far too much to go back the other

direction.

Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions

Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions