How does DB2 handle table variables in procedures?

[Maim]

I usually write my procedures in SQL Server 2000 but I need to start writing them for Oracle and DB2. One issue that concerns me is how table variables are handled by DB2.

For example;
DECLARE @myTable(
f1 integer,
f2 varchar(256),
f3 smallint)
INSERT INTO @myTable
SELECT ... a whole bunch of records ...

SELECT * FROM @myTable

Would the above be possible in DB2 on all platforms?

I don't have any documentation to verify this available to me yet.

Thanks in advance "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rich Cook