 |
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 9 matches |
| Author | Message |
|---|---|
 Topic: Daily job to delete data older than 15 day w/o EX access |
|
| user5 Replies: 6 Views: 6450 |
 Forum: Database Posted: Thu Mar 29, 2007 4:55 am Subject: Daily job to delete data older than 15 day w/o EX access |
| Hi All,
I have a table that is being shared across 3 regions(US/EMEA/JAPA). Thus this table is being used to Insert or Update for all 24 hours. ie I cannot hold an exclusive lock on the table at a ... |
|
| Topic: Is there any LIMIT to the # of bytes we STRING |
|
| user5 Replies: 2 Views: 1738 |
Forum: Application Programming Posted: Mon Jan 22, 2007 4:47 am Subject: Is there any LIMIT to the # of bytes we STRING |
| Thanks you very much Kolusu.
It worked  |
|
| Topic: Is there any LIMIT to the # of bytes we STRING |
|
| user5 Replies: 2 Views: 1738 |
Forum: Application Programming Posted: Sat Jan 20, 2007 7:25 am Subject: Is there any LIMIT to the # of bytes we STRING |
| Hi All,
I am creating a Dynamic sequel in my SP One of the paramaters that the front end passes to the SP is the User Id string. The # of user ids can be as high as 2800. So the front end is pas ... |
|
| Topic: Static SQL |
|
| user5 Replies: 6 Views: 1753 |
Forum: Database Posted: Sat Jan 20, 2007 7:06 am Subject: Static SQL |
| hi,
I have converted it to a Dynamic sequel. I was passing dial11, which is 6 bytes. My SP is written in COBOL. Thanks & Regards, Meghna |
|
| Topic: Static SQL |
|
| user5 Replies: 6 Views: 1753 |
Forum: Database Posted: Fri Jan 19, 2007 4:35 am Subject: Static SQL |
| HI Dick Brenholtz
I tried removing the quotes & commas. My DIALER_FUNC column is 6 bytes long I passed the following in the FUNCSTR : dial11dial22 But the query is still not working. ... |
|
| Topic: Static SQL |
|
| user5 Replies: 6 Views: 1753 |
Forum: Database Posted: Thu Jan 18, 2007 4:36 am Subject: Static SQL |
| Hi,
I have an SP which has a Static SQL. I have passed the following parms to the SP: IND = R LOCSTR = '111','222','333' FROMTS ... |
|
| Topic: CLOB Data used in Linkage variables of a Stored Procedure. |
|
| user5 Replies: 6 Views: 4032 |
Forum: Database Posted: Fri Jan 05, 2007 1:42 am Subject: Inserting or selecting CLOB data from tables |
| But since I am trying to insert update or select a CLOB column of the table,
is it that I cannot use locators? Is it that I necessarily have to exchange the actual CLOB data? Regards, User5 |
|
| Topic: CLOB Data used in Linkage variables of a Stored Procedure. |
|
| user5 Replies: 6 Views: 4032 |
Forum: Database Posted: Thu Jan 04, 2007 6:04 am Subject: Reg: CLOB Data used in Linkage variables of Stored Procedure |
| Hello Kolusu,
While I was reading some articles on the link that you had sent, I came across : LOB materialisation. In this article it is mentioned that: DB2 must materialize LOBs when your appl ... |
|
| Topic: CLOB Data used in Linkage variables of a Stored Procedure. |
|
| user5 Replies: 6 Views: 4032 |
Forum: Database Posted: Wed Jan 03, 2007 8:55 am Subject: CLOB Data used in Linkage variables of a Stored Procedure. |
| Hi All,
I have to develop a Stored procedure that has to either: Retreive a record from a table Insert a record if it is not already existing Update a record if it is already exisitng The tab ... |
|
All times are GMT - 5 Hours |