CA Culprit in the CA IDMS/DB Environment › PATH Parameter › Accessing non-SQL Defined Tables

Accessing non-SQL Defined Tables

CA Culprit automatically generates a PATH parameter for runs that access one or more tables in a non-SQL defined database. The PATH parameter names the primary input table. CA Culprit retrieves information from the table or tables one row at a time. Users can select rows to be processed by specifying:

• A WHERE clause on the INPUT parameter defined for the primary table
• SELECT/BYPASS parameters
• Type 7 logic for individual reports