Subject: Temporary Tables and UDB SQL Stored Procedures Hello List; I would appreciate some help on the following: For the project I am presently on we have a UDB version 7.1 database on a UNIX server. I want to write a SQL stored procedure that will return a result set. But this result set cannot be returned in one cursor.
USE TEMPORARY TABLE IN STORED PROCEDURE DB2 TUTORIAL >> READ ONLINE
I have just started working on DB2 which the syntax is a lot different. I am trying to create a SQL stored procedure for generating reports. I want to use temporary database which in this example it is trult not needed but due to past experience it is key to developing good reports for cliebt/server application. Here is my example which of course The tables and view identified in a select statement can be at the current server or any Db2® subsystem with which the current server can establish a connection.. For local queries on Db2 for z/OS® or remote queries in which the server and requester are Db2 for z/OS, if a table is encoded as ASCII or Unicode, the retrieved data is encoded in EBCDIC. I have a requirement where I have to populate a TEMPORARY TABLE and use the table in a CURSOR. In a stored procedure it is mandatory to declare the CURSOR before I declare the the TEMPORARY TABLE. But it gives me an error: "SESSION.TABLE_NAME" is an Undefined Name. Following is the code: CREATE PROCEDURE CORE.TEMP_TABLE_SP ( ) DYNAMIC RESULT SETS 1 Db2 Stored Procedure examples: How to Create DB2 Stored Procedures with Examples: I have been working on Oracle/Plsql, Sql Server for over a long period and got an opportunity to work on Db2.You get to see as many links a DB2 for z/OS Stored Procedures: Through the CALL and Beyond Paolo Bruni Bhaskar Achanti Suneel Konidala Glenn McGeoch Martin Packer Peggy Rader Suresh Sane Bonni Taylor Peter Wansch Develop and test COBOL, C, REXX, Java, and SQL language stored procedures Set up, control, and tune the operating environment Learn tools and DB2 supplied stored A temporary table instantiated by an SQLQuestion answer relationship comprehension strategy instruction Grullon pronunciation guide Fisher 1052 instruction manual Manual do roadstar 1600d Easy off grill instructions Ag 1260-01t manual 5355 henry hudson parkway 5e instructional model Miniature house making tutorial videos Ag 1260-01t manual 5355 henry hudson parkway 5e instructional model