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?
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
