 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 7 matches |
| Author | Message |
|---|---|
 Topic: Problem with Dynamic SQL |
|
| Joy Replies: 1 Views: 944 |
 Forum: Database Posted: Thu Jul 14, 2005 10:18 am Subject: Problem with Dynamic SQL |
| I am trying to run a dynamic SQL inside a loop and getting the following error:-SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTAT ... | |
| Topic: Is it possible to open a Cursor inside a Scalar UDF? |
|
| Joy Replies: 5 Views: 1989 |
Forum: Database Posted: Tue Jun 28, 2005 1:46 am Subject: Is it possible to open a Cursor inside a Scalar UDF? |
| Hi Jayi,
Even I'm trying to do the same thing but its not working.The IBM DB2 Red Book contains code that has a cursor declaration within a UDF.But its not working for me |
|
| Topic: Printing lines to console |
|
| Joy Replies: 1 Views: 1204 |
Forum: Database Posted: Mon Jun 13, 2005 2:43 am Subject: Printing lines to console |
| Is there something in DB2 UDB that is equivalent to DBMS_OUTPUT.PUT_LINE in Oracle?How can I print lines to the console? | |
| Topic: Problem with cursor |
|
| Joy Replies: 1 Views: 1091 |
Forum: Database Posted: Mon Jun 13, 2005 2:41 am Subject: Problem with cursor |
| Hi,
The code given below opens a cursor c1 for making a selection from the table t_cer_grp1.How can I close the cursor C1 at the end of the proc.The conventional close c1 is not working with this s ... |
|
| Topic: Problem with MODIFIES SQL DATA |
|
| Joy Replies: 1 Views: 1803 |
Forum: Database Posted: Thu May 12, 2005 8:02 am Subject: Problem with MODIFIES SQL DATA |
| Hi ,
Can u please tell me whats wrong with this UDF.Its encountering the following error message Multiple or conflicting keywords involving the "MODIFIES SQL DATA " clause are present.The SQLCODE ... |
|
| Topic: DB2 is not supporting nested UDF calls beyond second level |
|
| Joy Replies: 1 Views: 1270 |
Forum: Database Posted: Mon May 09, 2005 7:03 am Subject: DB2 is not supporting nested UDF calls beyond second level |
| DB2 UDB is not supporting nested function calls beyond the Second Level for User Defined Functions(UDF's)i.e its fine if one UDF calls another UDF however if the second UDF calls another UDF then DB2 ... | |
| Topic: How to create related DB2 Stored Procs in a Package |
|
| Joy Replies: 1 Views: 1032 |
Forum: Database Posted: Mon May 09, 2005 6:54 am Subject: How to create related DB2 Stored Procs in a Package |
| Hi,
How can I define my own package for a DB2 SQL stored procedure? Is there a DB2 command equivalent to Oracle's "CREATE PACKAGE" statement? |
|
All times are GMT - 5 Hours |