1. Categories >> Software >> MainFrame >> IBM MainFrame >> JCL
  2. Suggest New Category

Hi,
My dataset have multiple records, say 100. I want to start
copy records only after a record contain a specific value
that may be in a specific position. Secondly I want to stop
copying rest records if certain record contains a specific
value. Can it be done using SORT/ICETOOL utilities?

Question Posted / subrat

Answers were Sorted based on User's Feedback



Hi, My dataset have multiple records, say 100. I want to start copy records only after a record ..

Answer / muttaiah

Hi Subrat,
can you cleary mention your query.
you want to start copying only after a particular record
contains a value & stop after you find a value in
particular record.
EX:
100 muttaiah hyd
200 kiran hyd
300 Guru hyd
400 ram hyd
500 narayana hyd
600 hari hyd
consider you input file has 5 records. You want to copy
only when you find 200 in the record & stop when you find
500 in the record

Output:
300 Guru hyd
400 ram hyd

Is this what your question exactly MR. Subrat,

@All:
All the previous answers are wrong
The one who posted i kindly request them to read the
question twice before they post. As number of people are
going to visit this site.

Thanks,

Is This Answer Correct ?    1 Yes 1 No

Hi, My dataset have multiple records, say 100. I want to start copy records only after a record ..

Answer / eswaran

hi,
your dataset have 100 records then u want copy starting
position=25 to ending position=50 then y have copy following way
//FSS129A JOB
//STEP1 EXEC PGM=SORT
//SORTIN DD DSN=NEW1.PS
//SORTOUT DD DSN=NEW2.PS
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY,SKIPREC=25,STOPAFT=50
/*
//

Is This Answer Correct ?    2 Yes 3 No

Hi, My dataset have multiple records, say 100. I want to start copy records only after a record ..

Answer / nnn

If you want to copy value of 'A' at 10 th position
SORT FIELDS=(COPY)
INCLUDE COND=(10,1,CH,EQ,C'A')

If you want to stop copy value of 'A' at 10 th position
SORT FIELDS=(COPY)
INCLUDE COND=(10,1,CH,NE,C'A')

Is This Answer Correct ?    3 Yes 7 No

Hi, My dataset have multiple records, say 100. I want to start copy records only after a record ..

Answer / pavan

can anyone provide full syntax wth an example..please

Is This Answer Correct ?    0 Yes 5 No

Hi, My dataset have multiple records, say 100. I want to start copy records only after a record ..

Answer / srini

STOPAFT(100)

Is This Answer Correct ?    0 Yes 9 No

Post New Answer

More JCL Interview Questions

What is the use of the utility DFSRRC00 in the JCL?

2 Answers   Convergys,

how to skip the steps in JCl

2 Answers   EDS,

How would you understand error(execution phase)?

0 Answers  

once we submitted the job to the operating system, how can we cancel the job before execution?

2 Answers  

JCL Example: // //RUNJCL JOB CLASS=5,MSGCLASS=6,NOTIFY=&SYSUID //STEP01 EXEC PGM=IEFBR14 // .. .. If this JCL will run or it'll throw the ERROR?

4 Answers   HCL,




What is the meaning of data definition name (ddname) and dataset name (dsname) in the DD statement?

2 Answers  

How much is memory space involved, when we code BLOCKSIZE,TRK & CYL ?

1 Answers  

how do you code a null statement?

0 Answers   IBM,

Please give me the coding for converting VB to FB and FB to VB

3 Answers   HP,

How many types of parameters are used in JCL and what are mandatory parameters of JOB statement.

13 Answers   IBM,

A job has 90 steps i want to execute only step7 and step15

3 Answers   Cognizant,

i want to restart frm step 2, previously i coded cond parameter on step2 wht happens at tht time ?

4 Answers   Infosys,

For more JCL Interview Questions Click Here
Categories