Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

This content has been archived and is no longer being updated.

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

Updated on October 19, 2020

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.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us