 |
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 5 matches |
| Author | Message |
|---|---|
 Topic: Is it possible to open a Cursor inside a Scalar UDF? |
|
| rublu Replies: 5 Views: 2020 |
 Forum: Database Posted: Wed Jun 29, 2005 2:54 am Subject: Is it possible to open a Cursor inside a Scalar UDF? |
| Jayi,
I misunderstood the context earlier. Scalar UDFs will not return any resultsets. Refer http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0009701.htm ... |
|
| Topic: Is it possible to open a Cursor inside a Scalar UDF? |
|
| rublu Replies: 5 Views: 2020 |
Forum: Database Posted: Tue Jun 28, 2005 10:00 pm Subject: Is it possible to open a Cursor inside a Scalar UDF? |
| Could you give the error messages you are getting. Actually it is possible to open the cursor inside an UDF (procedures). | |
| Topic: Query to control the rows for each key |
|
| rublu Replies: 1 Views: 1057 |
Forum: Database Posted: Tue Jun 14, 2005 5:29 pm Subject: Query to control the rows for each key |
| Hi all,
I have a table T1. In that I have 2 fields ID and VALUE. T1 --- ID VALUE *********** For each ID there are about 1000 values present. Now my question was, I want a query wh ... |
|
| Topic: Global Temporary Table - |
|
| rublu Replies: 4 Views: 2390 |
Forum: Database Posted: Tue Jun 14, 2005 4:31 pm Subject: Global Temporary Table - |
| Thanks Kolusu.
I am using Declared Global Temorary table only. More than that I am getting this sqlcode -601 when I tried to Declare this GTT before the transaction ends. So I have option other tha ... |
|
| Topic: Global Temporary Table - |
|
| rublu Replies: 4 Views: 2390 |
Forum: Database Posted: Tue Jun 14, 2005 3:58 pm Subject: Global Temporary Table - |
| Hi all,
In one of my application, an online tranaction will invoke our main program from where we are routed to many sub modules. In one of the sub modules we are declaring Global temporary tables ... |
|
All times are GMT - 5 Hours |