Re: SQLRPGLE create table

["Raul A. Jager W." <raul@xxxxxxxxxx>]

So, if I want to keep the same format I can only do it with DDS.
Will it be supported in the next release?
I think I will take your advise and change to *ISO.

Gracias por la correccion. English is my second language, and I also
appreciate any help to write with less mistakes.

Luis Rodriguez wrote:

> 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.