Re: SQLRPGLE create table

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Raul,

In fact, SQL always store DATE fields in the *ISO format. What you are doing
with SET DATFMT is telling it how to show and accept dates (in your case,
DMY) in that particular program. Me? I would say go ahead and change
everything to *ISO :-)

BTW, "tryed" should be written as "tried" (I don't know you, but I always
appreciate when people correct my English (I'm from Venezuela))

Best Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Fri, Oct 21, 2011 at 11:11 AM, Raul A. Jager W. <raul@xxxxxxxxxx> wrote:

> Actual version 7.1
> I want to re-create a table using SQL, and I want to be able to use the
> programs that where compiled  before the change. The old table was
> created in the 90's using dds.
>
> Mi problem is that a DATE field was defined in the *DMY format, and SQL
> insist in creating *ISO. I tryed "set option datfmt=*dmy" I tryed the
> parameter in the RUNSQLSTM, the SYSVAL is DMY, in an interactive SQL I
> used f13 to set DMY, but "create table" ignores all. I even tryed
> "create table like old..."
>
> The reason why I whant to re-create the table now is that when I tryed
> to set a constraint I got a message "The table is in use" even when I
> had it allocated *EXCL. Digging into messages I found "5 -Object is
> damaged" and in the actions it recomends to delete and restore or create.
>
> Is there a way to create a DMY format date using SQL?
> Shoul I make the change and re-compile everything?
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.