| Author |
Message |
Topic: Connectivity between mainframe and unix box |
hari haran
Replies: 1
Views: 1419
|
Forum: Database Posted: Mon Dec 10, 2007 8:27 pm Subject: Connectivity between mainframe and unix box |
Hi,
We have a job at mainframe end that queries a DB2 table maintained in a Solaris Box. Recently the ID was deleted from the Unix Box which caused our jobs to fail. We recreated the ID in the Unix ... |
Topic: Copying all records except second last record. |
hari haran
Replies: 5
Views: 3149
|
Forum: Utilities Posted: Thu Jul 28, 2005 12:45 pm Subject: Copying all records except second last record. |
Phantom,
Thanks a lot for the above solution..... it worked great !!! ...
Frank,
Thanks for the solution but we have Syncsort in our Shop ...
Hari Haran. S. |
Topic: Copying all records except second last record. |
hari haran
Replies: 5
Views: 3149
|
Forum: Utilities Posted: Tue Jul 26, 2005 11:13 am Subject: Copying all records except second last record. |
Hi All,
The requirement is to copy all the records from input to output except the second last record :
Input Data Considerations:
1. Input file can have any number of records,
2. There is ... |
Topic: E35 performance tuning |
hari haran
Replies: 20
Views: 13918
|
Forum: Utilities Posted: Tue May 03, 2005 7:55 am Subject: E35 performance tuning |
HBO,
Please try using OPTION VLSHRT in your Sort Card :
//SYSIN DD *
OPTION VLSHRT
SORT FIELDS=(22,14,CH,A,13,08,CH,D ... |
Topic: Purging the session |
hari haran
Replies: 19
Views: 16599
|
Forum: Utilities Posted: Sat Mar 26, 2005 7:23 pm Subject: Purging the session |
Hi,
We normally purge sessions using any one of the below methods:
1. TSO Command :
tso opscmd c u=userid
the above is site dependent......
2. Using the below batch JCL submitted f ... |
Topic: File-aid Batch help |
hari haran
Replies: 14
Views: 30477
|
Forum: Utilities Posted: Sat Mar 26, 2005 5:16 pm Subject: File-aid Batch help |
Hi,
The same Fileaid batch job when tried in Vertical Format mode, results in Data Truncation when the output length exceeds 133 bytes.
Control Card :
$$DD01 VPRINT MAP=QKUMONTH,OUT=0
T ... |
Topic: Extraction of data from 3.15 Search Listing |
hari haran
Replies: 1
Views: 4257
|
Forum: Utilities Posted: Tue Mar 22, 2005 3:26 pm Subject: Extraction of data from 3.15 Search Listing |
Hi,
We have a requirement in which all the programs that are used in a Proc have to be listed out.
We can search the string 'PGM=' in 3.15 to give us all the programs used in the particular PROCLI ... |
Topic: Reformat to PD using OUTREC |
hari haran
Replies: 5
Views: 5081
|
Forum: Utilities Posted: Tue Sep 07, 2004 7:39 am Subject: Reformat to PD using OUTREC |
Hi Frank,
Yes Frank I needed to sort on one particular digit of a PD field.
Thanks for both the answers. Both of them worked fine.
Great solutions...... |
Topic: Reformat to PD using OUTREC |
hari haran
Replies: 5
Views: 5081
|
Forum: Utilities Posted: Mon Sep 06, 2004 2:04 pm Subject: Reformat to PD using OUTREC |
Hi Kolusu,
Thanks for the reply.
The problem is that the sort should be done on a single digit of a COMP-3 record. Ex. to sort the 17th digit of a PD record having 9 Bytes storage space.
For ... |
Topic: Reformat to PD using OUTREC |
hari haran
Replies: 5
Views: 5081
|
Forum: Utilities Posted: Mon Sep 06, 2004 11:27 am Subject: Reformat to PD using OUTREC |
Hi All,
There is an input file with the following format :
1,9 - PD
10,29 - CHAR
Now I want to sort the file based on the following criteria :
1) Expand 1-9 Packed decimal fields into ZD ... |
| |