 |
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 38 matches |
| Author | Message |
|---|---|
 Topic: Syncsort solution required |
|
| mahesh_chv Replies: 12 Views: 6137 |
 Forum: Utilities Posted: Tue Aug 02, 2011 11:51 am Subject: Syncsort solution required |
| sorry...not end of file....end of each record.... | |
| Topic: Syncsort solution required |
|
| mahesh_chv Replies: 12 Views: 6137 |
Forum: Utilities Posted: Tue Aug 02, 2011 11:50 am Subject: Syncsort solution required |
Thanks sqlcode...... your solution worked for me....but the sequence number got added at the end of the file which i have to skip using BUILD  |
|
| Topic: Syncsort solution required |
|
| mahesh_chv Replies: 12 Views: 6137 |
Forum: Utilities Posted: Fri Jul 29, 2011 1:17 pm Subject: Syncsort solution required |
| Hi,
Below is my requirement. the first 3bytes is the product code and next 10 bytes is the account number. Input file 0012200113323 2802200123325 0013890054321 0104455789012 280604532 ... |
|
| Topic: FILE comparision using ICETOOL or SYNC Sort |
|
| mahesh_chv Replies: 3 Views: 2775 |
Forum: Utilities Posted: Thu May 05, 2011 9:56 pm Subject: FILE comparision using ICETOOL or SYNC Sort |
| Thanks for the solution Kolusu.
But we dont have DFSORT in our shop. We use SYNC SORT or ICETOOL Can you please give me a solution using ICETOOL? |
|
| Topic: FILE comparision using ICETOOL or SYNC Sort |
|
| mahesh_chv Replies: 3 Views: 2775 |
Forum: Utilities Posted: Wed May 04, 2011 11:58 am Subject: FILE comparision using ICETOOL or SYNC Sort |
| I have a requirement where in I need to compare file-1,file-2 and the output should contain all the records from
file-2 but the records which are not in file-1 or records which are modified in file- ... |
|
| Topic: Insert a new record based on condition - Sync sort |
|
| mahesh_chv Replies: 5 Views: 3023 |
Forum: Utilities Posted: Wed Mar 02, 2011 2:09 am Subject: Insert a new record based on condition - Sync sort |
| Papadi,
INput file contains around 3000 records with 200 LRECL my requirement is to build and insert a new record if its not found (key is not found) ...... I can take care of the Building ... |
|
| Topic: Insert a new record based on condition - Sync sort |
|
| mahesh_chv Replies: 5 Views: 3023 |
Forum: Utilities Posted: Tue Mar 01, 2011 10:44 pm Subject: Insert a new record based on condition - Sync sort |
| Papadi,
Here is the sample input data.... 123AAA 345BBB 567CCC 789EEE now i have to check my input file if 'DDD' is present.( where AAA,BBB,CCC,DDD are the keys) If its not present , ... |
|
| Topic: Insert a new record based on condition - Sync sort |
|
| mahesh_chv Replies: 5 Views: 3023 |
Forum: Utilities Posted: Tue Mar 01, 2011 5:12 am Subject: Insert a new record based on condition - Sync sort |
| Hi,
My requirement was similar to the below post http://www.mvsforums.com/helpboards/viewtopic.php?t=9818&highlight=insert+record But a slight change.... say I have a input file ( LRECL= ... |
|
| Topic: Add a Dummy record using Syncsort |
|
| mahesh_chv Replies: 9 Views: 5950 |
Forum: Utilities Posted: Sun Dec 12, 2010 5:53 am Subject: Add a Dummy record using Syncsort |
| Nic Clouston,
I tried and experimented but couldnt achieve this. Thanks, Mahesh |
|
| Topic: Add a Dummy record using Syncsort |
|
| mahesh_chv Replies: 9 Views: 5950 |
Forum: Utilities Posted: Fri Dec 10, 2010 2:03 am Subject: Add a Dummy record using Syncsort |
| Cant we achieve this using Trailer ???
Can some one throw light on this? |
|
| Topic: Add a Dummy record using Syncsort |
|
| mahesh_chv Replies: 9 Views: 5950 |
Forum: Utilities Posted: Thu Dec 09, 2010 9:25 pm Subject: Add a Dummy record using Syncsort |
| Thanks Computer,
But I need a solution using sync sort |
|
| Topic: Add a Dummy record using Syncsort |
|
| mahesh_chv Replies: 9 Views: 5950 |
Forum: Utilities Posted: Thu Dec 09, 2010 6:40 am Subject: Add a Dummy record using Syncsort |
| Hi,
I need to add a trailer to my output file which acts as a dummy record in case if my input file is empty. The trailer contains two fields 1. X(22) -- should contain all 9's 2. S9(11)V9(2) ... |
|
| Topic: how to code scroll logic using rexx |
|
| mahesh_chv Replies: 3 Views: 2805 |
Forum: TSO and ISPF Posted: Fri Oct 01, 2010 1:01 am Subject: how to code scroll logic using rexx |
| can someone please tell how to implement scroll logic | |
| Topic: how to find out all nullable columns in a DB2 table ? |
|
| mahesh_chv Replies: 2 Views: 2364 |
Forum: Database Posted: Tue Mar 31, 2009 1:45 am Subject: how to find out all nullable columns in a DB2 table ? |
| We are currently using DB2 V7 and want to migrate to Db2 V9. So we are coming with a tool which can find out all the nullable columns in Db2 tables and
Currently we don't have null indicators for ... |
|
| Topic: Splitting of the Mainframe file |
|
| mahesh_chv Replies: 3 Views: 2734 |
Forum: Utilities Posted: Tue Nov 11, 2008 10:32 pm Subject: Splitting of the Mainframe file |
| Thank you kolusu .....
But we use Sync Sort in our shop  |
|
All times are GMT - 5 Hours |