Introspect to Add global temp table from DB2

[vasim chaudhari]

we have a requirement as follows and we want to do both step in same session of TDV

1 ) to insert data into global temp table present in db2

INSERT INTO schema.tableabc (c1,c2) VALUES ('abc', 'efg');

INSERT INTO schema.tableabc (c1,c2) VALUES ('123', '456');

 

2 ) Once data is inserted call the stored proc which uses above table for join criteria.

CALL schema.sp1 (NULL,'2019-01-01','2019-01-23','A',,);

thhe stored proc sp1 has join query withschema.tableabc temp table

 

Problem :

1) I am unable to introspect theschema.tableabc temp table through tibco data virtualization studio

2) unable to use same session for insert and strored proc call

[Deepak Kuletha]

Hi ,

 

 

 

Please paste the error you are getting.