SQL Query Components

Studio allows you to create components that encapsulate predefined SQL queries. These SQL queries can also receive arguments and are reusable across the project.

Think of cataloged SQL queries as SQL views defined on the client-side.

Studio generates a component containing one attribute for each column returned by the query. Only SELECT-type queries are allowed and the generated component provides read-only access to the results.

• Cataloging a SQL Query
  The following procedures show you how to catalog a table using a SQL Query.
• Parametric Queries
  When you catalog a SQL query, you have the option of making it parametric. Parametric SQL Queries accept arguments at runtime.
• Using SQL Query Components
  Use the for each statement to execute and iterate over the result set of a cataloged SQL query.
• Mapping SQL types to PBL
  This sections explains how JDBC/SQL types map to PBL types when cataloging SQL queries.