 |
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 46 matches |
| Author | Message |
|---|---|
 Topic: Subtracting days from a date in Syncsort |
|
| mangsk Replies: 6 Views: 17749 |
 Forum: Utilities Posted: Wed Mar 14, 2012 8:43 am Subject: Subtracting days from a date in Syncsort |
|
Posted: Mon Nov 23, 2009 3:21 pm prog_mario: At this time, SyncSort does not have a special function to perform arithmetic on input date fields. _________________ Brian Wood SyncSort M ... |
|
| Topic: Taking SYSOUT into Fixed Block PS file from a SORT |
|
| mangsk Replies: 6 Views: 4870 |
Forum: Utilities Posted: Mon Nov 14, 2011 4:17 pm Subject: Taking SYSOUT into Fixed Block PS file from a SORT |
papadi,
 But this is specific client requirement 
When I use the VB 125 file and try INREC or INCLUDE COND statement on that, e.g. INCLUDE COND=(57,17,CH,EQ,C'TOTAL RECORDS OUT') I ... |
|
| Topic: Taking SYSOUT into Fixed Block PS file from a SORT |
|
| mangsk Replies: 6 Views: 4870 |
Forum: Utilities Posted: Mon Nov 14, 2011 3:28 pm Subject: Taking SYSOUT into Fixed Block PS file from a SORT |
| papadi,
Thanks for the quick response. Our shop has Syncsort 1.3.2.1R. With the SYSOUT dataset, I need to extract the counts (SORTOF*) and sum them to validate if they are equal to the number in f ... |
|
| Topic: Taking SYSOUT into Fixed Block PS file from a SORT |
|
| mangsk Replies: 6 Views: 4870 |
Forum: Utilities Posted: Mon Nov 14, 2011 3:02 pm Subject: Taking SYSOUT into Fixed Block PS file from a SORT |
| I am having a simple SORT step. I wish to create a FB file from SYSOUT.
//STEPXX EXEC PGM=SORT, //SYSOUT DD DSN=XXXX.SYSOUT, // SPACE ... |
|
| Topic: Joinkeys - Can it be conditional? |
|
| mangsk Replies: 5 Views: 14689 |
Forum: Utilities Posted: Mon Aug 15, 2011 1:09 pm Subject: Joinkeys - Can it be conditional? |
| Sqlcode,
My files are of different length. File2 is actually 5 bytes while the File1 is bigger than 18 bytes I have here in the example. So, with reference to your updated response, with SYNCSORT i ... |
|
| Topic: Joinkeys - Can it be conditional? |
|
| mangsk Replies: 5 Views: 14689 |
Forum: Utilities Posted: Mon Aug 15, 2011 12:21 pm Subject: Joinkeys - Can it be conditional? |
| kolusu, Sqlcode,
Thank you for your reply. Unfortunately, my shop has Syncsort 1.3.2.1 and it doesn't seem to support the JNF1CNTL statement. I get return code of 0; but I don't get the desired out ... |
|
| Topic: Joinkeys - Can it be conditional? |
|
| mangsk Replies: 5 Views: 14689 |
Forum: Utilities Posted: Mon Aug 15, 2011 10:28 am Subject: Joinkeys - Can it be conditional? |
| I have 2 files
File F1: 103ABCDEF103XXXXXX 104XYZABC104YYYYYY 104BNDRFD104HHFFHH 105RDFHHD105HHFHHF 109YYRYYR109NMJFNN File F2: 10301 10402 10503 10602 10703 2nd file contains the n ... |
|
| Topic: Is it possible to use an array as host variable ? |
|
| mangsk Replies: 23 Views: 15686 |
Forum: Application Programming Posted: Wed Apr 15, 2009 8:04 am Subject: Is it possible to use an array as host variable ? |
| dbzTHEdinosauer, jsharon1248,
Thanks for all your help. |
|
| Topic: Is it possible to use an array as host variable ? |
|
| mangsk Replies: 23 Views: 15686 |
Forum: Application Programming Posted: Tue Apr 14, 2009 3:12 pm Subject: Is it possible to use an array as host variable ? |
| dbzTHEdinosauer,
Thanks for the suggestion. |
|
| Topic: Is it possible to use an array as host variable ? |
|
| mangsk Replies: 23 Views: 15686 |
Forum: Application Programming Posted: Tue Apr 14, 2009 2:17 pm Subject: Is it possible to use an array as host variable ? |
| dbzTHEdinosauer, jsharon1248,
Thanks a lot jsharon1248. jsharon1248 has elaborated the same question I had in my earlier post. But unfortunately the listed 2 alternatives I am trying to avoid. De ... |
|
| Topic: Is it possible to use an array as host variable ? |
|
| mangsk Replies: 23 Views: 15686 |
Forum: Application Programming Posted: Tue Apr 14, 2009 8:45 am Subject: Is it possible to use an array as host variable ? |
| dbzTHEdinosauer,
Now I reverted back to kolusu's original solution of 26 bytes. While I carry out my test, I am using an Intertest(debugging tool similar to Xpeditor). There I can see the values ... |
|
| Topic: Is it possible to use an array as host variable ? |
|
| mangsk Replies: 23 Views: 15686 |
Forum: Application Programming Posted: Mon Apr 13, 2009 11:05 am Subject: Is it possible to use an array as host variable ? |
| dbzTHEdinosauer,
Thanks for the reply. The MATRIX_ID's mentioned in above mentioned posts are directly taken from SPUFI's against the table. The definition of MATRIX_ID is (actual copy and pasted ... |
|
| Topic: Is it possible to use an array as host variable ? |
|
| mangsk Replies: 23 Views: 15686 |
Forum: Application Programming Posted: Mon Apr 13, 2009 8:51 am Subject: Is it possible to use an array as host variable ? |
| Kolusu,
Thanks for your help. I tried this, but it does not work. Now when I comment out last 2 lines (as mentioned in earlier post), it still returns SQLCODE=100. |
|
| Topic: Is it possible to use an array as host variable ? |
|
| mangsk Replies: 23 Views: 15686 |
Forum: Application Programming Posted: Fri Apr 10, 2009 12:20 pm Subject: Is it possible to use an array as host variable ? |
| Kolusu,
Thank you for your quick turnaround on this. Here is my array and redefined array definitions. 01 MTRX-ARRAY. 05 MTRX-ID OCCURS 1 ... |
|
| Topic: Is it possible to use an array as host variable ? |
|
| mangsk Replies: 23 Views: 15686 |
Forum: Application Programming Posted: Thu Apr 09, 2009 5:29 pm Subject: Is it possible to use an array as host variable ? |
| Kolusu,
I was facing the same issue and I searched the forum and found this 3 year old post. I tried the solution you suggested, but unfortunately this does not work. I tried with 3 values and it ga ... |
|
All times are GMT - 5 Hours |