Expanding your Meta-SQL for validation

PeopleCode META-SQL getting the expanded statement

I couldn't find a way to get PeopleCode to log or dump the expanded SQL. This is necessary to confirm the META-SQL has expanded into the query you expected. I finally found a way to get your expanded SQL.  Here is how you do it.

1. Create a new SQL Definition
2. Paste your SQL syntax form your Application Engine PeopleCode
3. Replace all your variables with a dummy values or in the case of a record holder put the record name
4. Right click on the query screen and select "Resolve Meta Data"
5. Look down at the output Meta SQL screen.  Voila expanded full SQL.