Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Introspect to Add global temp table from DB2


Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...