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

Uh huh.....I get it Charles....but I can only handle so much change in one
week. I refuse though to call it anything but an As/400 LOL




From:
"Wilt, Charles" <WiltC@xxxxxxxxxx>
To:
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Date:
05/23/2008 09:19 AM
Subject:
RE: Question on SQL Table (DDL) with date and time fields



WDSCi handles it fine... <grin>

Charles Wilt
--
Software Engineer
CINTAS Corporation - IT 92B
513.701.1307

wiltc@xxxxxxxxxx

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [

mailto:rpg400-l-bounces@xxxxxxxxxxxx]

On Behalf Of Doug Palme
Sent: Friday, May 23, 2008 9:40 AM
To: RPG programming on the AS400 / iSeries
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 <luis.rodriguez2@xxxxxxxxx>
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
--- rpg400-l-request@xxxxxxxxxxxx wrote:

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

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



--
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 transmission may contain information that is privileged,

confidential

and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure,

copying,

distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this
transmission in error, please immediately contact the sender and destroy
the material in its entirety, whether in electronic or hard copy format.
Thank you.
--
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 e-mail transmission contains information that is intended to be
confidential and privileged. If you receive this e-mail and you are not a
named addressee you are hereby notified that you are not authorized to
read, print, retain, copy or disseminate this communication without the
consent of the sender and that doing so is prohibited and may be unlawful.
Please reply to the message immediately by informing the sender that the
message was misdirected. After replying, please delete and otherwise
erase it and any attachments from your computer system. Your assistance
in correcting this error is appreciated.