| Author |
Message |
Topic: Change values in both Header and Detail Records on Criteria |
Dinesh Kumar
Replies: 1
Views: 1837
|
Forum: Utilities Posted: Tue Apr 21, 2015 4:50 am Subject: Change values in both Header and Detail Records on Criteria |
The Input File has Header and Detailed Record structure as stated below.The LRECL of the File is of 200 bytes
1-6 Order Group
7-8 Record Type ('10'--> Header Record ,'20' ---> Intermediat ... |
Topic: Compare Two Files and Merge the Column Values |
Dinesh Kumar
Replies: 1
Views: 1842
|
Forum: Utilities Posted: Mon Mar 07, 2011 9:44 am Subject: Compare Two Files and Merge the Column Values |
The first 10 bytes represents the Key field. If there is an entry in file1 and also present in File2 on the basis of the
key field that should be captured in the output file.
The "City" ... |
Topic: Search the Corresponding Field and get the Matching entries |
Dinesh Kumar
Replies: 10
Views: 4237
|
Forum: Utilities Posted: Mon Mar 07, 2011 3:41 am Subject: Search the Corresponding Field and get the Matching entries |
My shop has DFSORT V1R10 , it throwed out an error "OPERAND DEFINER ERROR" for
IFTHEN=(WHEN=GROUP,KEYBEGIN=(1,35),PUSH=(122:SEQ=3)),
... |
Topic: Search the Corresponding Field and get the Matching entries |
Dinesh Kumar
Replies: 10
Views: 4237
|
Forum: Utilities Posted: Sun Mar 06, 2011 10:56 pm Subject: Search the Corresponding Field and get the Matching entries |
Thanks a lot query. Will the above solution work if the DSN has the following set of records. The scenario is mentioned below
----+----1----+----2----+----3----+----4----+----5----+----6----+----7- ... |
Topic: Search the Corresponding Field and get the Matching entries |
Dinesh Kumar
Replies: 10
Views: 4237
|
Forum: Utilities Posted: Fri Mar 04, 2011 7:21 am Subject: Search the Corresponding Field and get the Matching entries |
TTUUD340TTIL184 016O1IL484 TTUU.P.IL.TRN18401(+1) (NEW,CATLG,DELE ------ File created is not used anywhere
TTVVD380TTIL567 016O1IL484 TTVV.P.IL.TRN77701(+0) SHR ... |
Topic: Search the Corresponding Field and get the Matching entries |
Dinesh Kumar
Replies: 10
Views: 4237
|
Forum: Utilities Posted: Fri Mar 04, 2011 4:00 am Subject: Search the Corresponding Field and get the Matching entries |
The maximum no of systems for a dataset would be 15 systems . The Dataset field is of 44 bytes but the DSN has a max of 35 bytes.
Please let me know If you need any more information on the same |
Topic: Search the Corresponding Field and get the Matching entries |
Dinesh Kumar
Replies: 10
Views: 4237
|
Forum: Utilities Posted: Fri Mar 04, 2011 12:30 am Subject: Search the Corresponding Field and get the Matching entries |
Thanks Kolusu. Sorry forgot to mention even the Disp (,CATLG,CATLG) also come in match criteria. Is there a way to club the matching records into a single line. Can I have the output as
Proc Na ... |
Topic: Search the Corresponding Field and get the Matching entries |
Dinesh Kumar
Replies: 10
Views: 4237
|
Forum: Utilities Posted: Thu Mar 03, 2011 11:20 am Subject: Search the Corresponding Field and get the Matching entries |
FILE-LAYOUT:
Field Name : Position
PROCEDURE NAME : 01 - 08 (Position 1-4 Represents the system name)
STEP-NAME : 09 - 16
STEP-SEQUEN ... |
Topic: Need a Sort Card to populate and Align |
Dinesh Kumar
Replies: 2
Views: 2125
|
Forum: Utilities Posted: Sun Sep 30, 2007 9:30 pm Subject: Need a Sort Card to populate and Align |
Hi,
I have a input file which is a VB file of 80 bytes. The contents of the input report file are as stated below,
Input file:
-------------------------------------------------------------
Repor ... |
Topic: Remove Duplicate Headers and Trailers |
Dinesh Kumar
Replies: 4
Views: 4145
|
Forum: Utilities Posted: Mon Sep 17, 2007 8:16 am Subject: Remove Duplicate Headers and Trailers |
The data content is as stated below
INPUT
HDR ----- 1st Header
DET2001
DET2006
DET2002
TRL
HDR
DET2003
DET2000
TRL
HDR
DET2000
DET2009
TRL ----- Last Trailer
OUTPUT
HD ... |
Topic: Remove Duplicate Headers and Trailers |
Dinesh Kumar
Replies: 4
Views: 4145
|
Forum: Utilities Posted: Mon Sep 17, 2007 8:13 am Subject: Remove Duplicate Headers and Trailers |
I have an Input File of LRECL=80 with multiple header,detailed and trailer record
The First three Bytes=
HDR represents header Record
DET represents Detailed Records
TRL Represents the Trail ... |
Topic: DISP=(NEW,PASS,CATLG) Retains the Existing value |
Dinesh Kumar
Replies: 1
Views: 2258
|
Forum: Job Control Language(JCL) Posted: Wed Aug 30, 2006 10:15 am Subject: DISP=(NEW,PASS,CATLG) Retains the Existing value |
Hi,
We are using a JCL wherein we create a temporary dataset and use it as follows.
1. In STEP1, copied a file NEWFILE1 to a temporary dataset (&&TEMP) with DISP = (NEW,PASS).
2. ... |
Topic: Count Records on Trailer |
Dinesh Kumar
Replies: 3
Views: 3956
|
Forum: Utilities Posted: Tue Oct 12, 2004 1:32 am Subject: Count Records on Trailer |
Hi ALL,
The following Sort Card can be used to have a single output file (header, detail with duplicate record removed, trailer with count from detail output file)
Code:
//STEP0100 E ... |
| |