 |
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 6 matches |
| Author | Message |
|---|---|
 Topic: Sort sum multiple rows & update a new column |
|
| anu.k Replies: 1 Views: 1218 |
 Forum: Utilities Posted: Tue Jul 13, 2010 3:12 pm Subject: Sort sum multiple rows & update a new column |
| Hi,
My requirement is to capture yearly amount based on monthly figures. Right now, the year-amt is 0. Need to sum-up and capture yearly amount as of that month. Key is 1-132 bytes. DATE ... |
|
| Topic: Query on DB2 cursor |
|
| anu.k Replies: 4 Views: 2930 |
Forum: Database Posted: Tue May 12, 2009 3:41 am Subject: Query on DB2 cursor |
| Hi,
In my application program, I have declared a cursor with some 'where' clause for table X. For each Fetch from the cursor, I am 'inserting' a new row into the table X which also satisfies the 'w ... |
|
| Topic: Help needed in handling data integrity issue.. |
|
| anu.k Replies: 1 Views: 1199 |
Forum: Database Posted: Wed Dec 17, 2008 11:58 am Subject: Help needed in handling data integrity issue.. |
| Hi,
Currently, there is a unique index defined on below columns on a table. DATE U-NO OFC ACCT REC-CRTE-DT REC-CRTE-TM In addition to the above unique constraint, ... |
|
| Topic: Insert binary value in a file |
|
| anu.k Replies: 3 Views: 1743 |
Forum: Utilities Posted: Tue Apr 22, 2008 7:52 am Subject: Insert binary value in a file |
| Thanks for your response Terry.
However my requirement was to achieve it in SORT and I managed to do so with the following sort card : SORT FIELDS=COPY OUTREC FIELDS=(X'0036',3:3, ... |
|
| Topic: Insert binary value in a file |
|
| anu.k Replies: 3 Views: 1743 |
Forum: Utilities Posted: Wed Apr 16, 2008 4:33 am Subject: Insert binary value in a file |
| Hi,
I have a file with the following structure. field 1 - PIC S9(4) COMP field 2 - X(40) Input data: Field 1 Field 2 1 AAAA.... 2 ... |
|
| Topic: How to know the job name or the utility pend my space? |
|
| anu.k Replies: 3 Views: 2210 |
Forum: Database Posted: Fri Feb 09, 2007 10:51 pm Subject: How to know the job name or the utility pend my space? |
| Hi Kolusu...
I tried this query in spufi..But it returns sqlcode -104 .. DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "DISPLAY". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: SELECT, INSER ... |
|
All times are GMT - 5 Hours |