Depending on your OS-Release of course ..
SELECT trim( TABLE_NAME ), trim(TABLE_SCHEMA), trim(COLUMN_NAME ) ,
DATA_TYPE, LENGTH, NUMERIC_SCALE FROM syscolumns WHERE TABLE_NAME =
'xxxxxxxxxxxxx'
Mit freundlichen Grüßen / Kind regards / Bien à vous,
Sean
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Don
Brown via MIDRANGE-L
Sent: Wednesday, 19 July 2023 10:39
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: Don Brown <DBrown@xxxxxxxxxx>
Subject: SQL Option for DSPFFD
Hi
I thought this would be an easy google search ...
I have a utility that uses a combination of DSPFD and DSPFFD to provide a
quick list of fields in a file.
It does not work on sql tables
DSPFFD does not work on SQL tables.
What are the options to display the field definitions in a SQL table.
Thanks
Don
--
This email has been scanned for computer viruses. Although MSD has taken
reasonable precautions to ensure no viruses are present in this email, MSD
cannot accept responsibility for any loss or damage arising from the use of
this email or attachments..
--
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.
midrange.com
