How can I find all the SQL field names or column names for a Datacom/AD or Datacom/DB table?
Component : CA DATACOM/DB
Component : CA DATACOM/AD
The quickest way to get a list of the column names is to use a SELECT * with a limit on the number of rows returned. For example, you could run a query like the one below to list the columns and data from three records to see which columns have the data you want.
//SYSIN DD *
SELECT * FROM SYSADM.ORDERS FETCH FIRST 3 ROWS ONLY;
As always, please contact Broadcom support for CA Datacom if you have further questions.