Finding SQL column names for a Datacom table

book

Article ID: 221686

calendar_today

Updated On:

Products

CA Datacom/DB CA Datacom CA 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.