Does %Table(temptablename) Work for SQLEXEC in PeopleCode AE Step

PencilBoy99

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.

Davet-Oracle

I would think that it might work if the current process has a temporary table instance number assigned.

I would suggest trying it out and see what happens.

DaveT

Davet-Oracle

I would think that it might work if the current process has a temporary table instance number assigned.

I would suggest trying it out and see what happens.

DaveT

PencilBoy99

thanks!