Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Dynamic SQL in COBOL
Thanks, Greg, This is exactly what I was thinking of, but didn't know if it existed. Phase 2 will be finding out if our DBA allows temp tables (& getting "USE privilege on the USER TEMPORARY table space.") (You asked "why your DBA made you use the instance number in the key... -
Dynamic SQL in COBOL
OK, thanks. But now I have a new question: What do you mean by "a temporary table"? Assuming I have CREATE permission on the database, I can imagine how to do that. Does DB2 support a "temporary table" as something local to my currently executing process? The... -
Using Dynamic SQL in DB2
Thanks, MarcLodge, your example, and that on the link, will help. -dd/- Dunshee
- Post #6
- Forum: COBOL General discussion
-
Dynamic SQL in COBOL
I need to use dynamic SQL in my COBOL program. Environment is DB2 / COBOL 370. I need to build the actual select statement for the cursor, including a term "LOCATION IN ('xxx', 'xxx',...) where I'll be getting a random (but small) number of xxx's at run time. I now have a kludgey set up... -
Using Dynamic SQL in DB2
I need to use dynamic SQL in my COBOL program. Environment is DB2 / COBOL 370. I need to build the actual select statement for the cursor, including a term "LOCATION IN ('xxx', 'xxx',...) where I'll be getting a random (but small) number of xxx's at run time. I now have a kludgey set up...- Dunshee
- Thread
- Replies: 6
- Forum: COBOL General discussion
