Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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?

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

How do you submit a job for execution?

0 Answers  


I need exexution process for JCL programs

0 Answers  


i have a jcl calling proc which has 10 steps, i want to execute from step5 to step10, where can i code RESTART and COND parameter?

6 Answers   IBM,


can we write a proc with in a proc

4 Answers   IBM,


What is the function of dd name parameter with a 2 part structure; audit.report?

0 Answers  






As PARM can supply information to a program ? Can PARM be used to supply information to a cataloged or Inline Procedure also ?

2 Answers   IBM, RS Software,


delete rules in db2

1 Answers   Keane India Ltd,


what if any ,is the syntax error in the following piece of code 01 B PIC A(7) 02 C PIC 9(4) ........ IF(B NUMERIC) ADD 10 TO C a.the condition in the if statement is wrong b.noting is wrong c.because C is initialised.ADD 10 TO C is wrong d.both B and C shoud have same size.

1 Answers  


how can a gdg base be created in a jcl. What is the difference between empty and scratch parameter while defining/altering gdg base?

0 Answers   IBM,


What is the difference between static call & Dynamic call ?

3 Answers  


Hi Please try to be to-the-point. 1) How to INCLUDE a JCL segment in a JOB ? (A Small example) 2) What is SPOOL and what is SPOOL FULL ? and how to direct the output of a Jobstep to SPOOL ?

3 Answers   IBM,


What are isolation levels? Where do we need to specify them in compiling JCL?

3 Answers  






Categories