Finding SQL column names for a Datacom table

Products

• Datacom/DB
• Datacom
• Datacom/AD

Issue/Introduction

How can I find all the SQL field names or column names for a Datacom/AD or Datacom/DB table?

Environment

Component : CA DATACOM/DB

Component : CA DATACOM/AD

Resolution

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;  
/*                                                     

Additional Information

As always, please contact Broadcom support for CA Datacom if you have further questions.