Insert SQL to a temp table??

[rpenridge]

Hi All,

I was wondering if anyone knows if it is possible to use SQL insert to populate a temp table. I have tried but keep getting the error:

** Table ttLad1 does not exist or cannot be accessed. (962)

Sample Code:

/*******
define temp-table ttTemp field tt-a like source.a.

insert into ttTemp
select a from source.a.

*********/