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
Answer / muttaiah
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
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
300 Guru hyd
400 ram hyd
Is this what your question exactly MR. Subrat,
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.
|Is This Answer Correct ?||1 Yes||1 No|
Answer / eswaran
your dataset have 100 records then u want copy starting
position=25 to ending position=50 then y have copy following way
//STEP1 EXEC PGM=SORT
//SORTIN DD DSN=NEW1.PS
//SORTOUT DD DSN=NEW2.PS
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
|Is This Answer Correct ?||2 Yes||3 No|
Answer / nnn
If you want to copy value of 'A' at 10 th position
If you want to stop copy value of 'A' at 10 th position
|Is This Answer Correct ?||3 Yes||7 No|
Answer / pavan
can anyone provide full syntax wth an example..please
|Is This Answer Correct ?||0 Yes||5 No|
Answer / srini
|Is This Answer Correct ?||0 Yes||9 No|
How do you submit a job for execution?
I need exexution process for JCL programs
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?
can we write a proc with in a proc
What is the function of dd name parameter with a 2 part structure; audit.report?
As PARM can supply information to a program ? Can PARM be used to supply information to a cataloged or Inline Procedure also ?
delete rules in db2
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.
how can a gdg base be created in a jcl. What is the difference between empty and scratch parameter while defining/altering gdg base?
What is the difference between static call & Dynamic call ?
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 ?
What are isolation levels? Where do we need to specify them in compiling JCL?