Does %Table(temptablename) Work for SQLEXEC in PeopleCode AE Step
edited Jan 24, 2022 4:10PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered ✓
Does the %Table(temptablename) MetaSQL work if executed from a PeopleCode step in an Application Engine.
For example, if I have an Application Engine w/ a temp table, and then within it a peplecode step like
SQLEXEC("SELECT COUNT(*) FROM %TABLE(MYTEMP_TMP)");
Does that resolve to the current instance of MYTEMP_TMP, or does that metasql only work if called from an application engine metasql step. If not is there any other way to resolve the temp instance.
Tagged:
0