Links may not function; however, this content may be relevant to outdated versions of the product.
How to match property names to database column names using the SQL SELECT "AS" clause
Summary
A developer asks:
I'm implementing stored procedures using Connect-SQL rules to a DB2 database.
If a stored procedure returns a resultset, am I limited such that the column names that are selected in the stored procedure must match the Process Commander property names in the class that executes the stored procedure?
Suggested Approach
If you are writing the stored procedure, you can specify in the stored procedure's SELECT clause the "AS name' syntax:
SELECT col1 as "ColumnOne", ...
However, if you don't have control over the stored procedure's SQL code, you need to enter a Process Commander class with properties to match the procedures selected column names.