IDMS: Culprit - Get the exact column names in an SQL Table

Products

• IDMS

Issue/Introduction

IDMS: Culprit - How do you get the exact column names in an SQL Table?

Resolution

Col. 2

 ? PRO  EX=NO                                        IN DB(Q) DICTIONARY=SYSDICT SCHEMA=DEMOEMPL       SQL SELECT * FROM EMPLOYEE                        0151*001 ' '                                     

The EX=NO tells CA Culprit to simply compile the report. No data extraction will be performed.

SQL SELECT * FROM EMPLOYEE tells CA Culprit to describe all of the columns and null indicators for the EMPLOYEE table.

The generated REC cards will appear on the INPUT PARAMETER LISTING with the column names.

For example:

Additional Information

IDMS 19.0 - Using - Getting the Exact Syntax for Updating a SQL Table