Re: Use of Field Reference Files Was: DDL question

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

You could use ACS to pull the SQL for the table.  I will provide all of the column headings, and such.    


Jim Oberholtzer
Agile Technology Architects



> On Sep 24, 2025, at 11:25 AM, DEnglander--- via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
>
> Rob,
>
> I read your post and it makes sense. I could be wrong, but when I use a
> Field Reference file to help create a DDL table, it will also pull in the
> column headings and field text automatically, which does help in Query/400
> objects, which are still in use here. When I use the Create statement with
> SYSCOLUMNS, I am not sure that'll bring in the headings and text, but I
> also have not tried that. But even if you use SYSCOLUMNS, don't you still
> need to have a table or some definition with the main [i.e. master]
> definitions that you always pull from?
>
> Thank you,
>
> Doug
>
>
>
> "CONFIDENTIALITY NOTICE:  This e-mail transmission (and/or the attachments accompanying it) contain confidential information belonging to the sender.  The information is intended only for the use of the intended recipient.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of the information is strictly prohibited.  Any unauthorized interception of this transmission is illegal under the law.  If you have received this transmission in error, please promptly notify the sender by reply e-mail, and then destroy all copies of the transmission."
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.