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
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 |
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 | 4 No |
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 |
Answer / pavan
can anyone provide full syntax wth an example..please
| Is This Answer Correct ? | 0 Yes | 5 No |
how to resolve soc-7 ? please tell me
what is a MODELDSCB?
I have 5 steps in my job. say s1, s2, s3, s4, s5 //s1 exec ............. //s2 exec ............ //s3 exec .......... //s4 exec ........ //s5 exec ............... my question is i want to exeute only s2 and s4 steps... please advice me how to do this:
How can a job send a status message to a tso user at the completion of a job?
Explain about RECORDING MODE Clause
I've one sequential file, That file contains millians of Junk & CHAR recoreds example File 1 ,,,,,...,,,.....,.,.INFOSYS.....,,,,,,,,,,,WIPRO..........., ,...,..,. My questions is : I want omit the 44th posstion to 4 CHAR (WIPRO) remaining things I want output file (including Junk CHAR also)... How can we slove this problem & give me a syntax. Please provide the result as soon as possible.
I have a COBOL program that Accepts some input data. How do you code the JCL statement for this? ( How do you code instream data in a JCL? )
What is order of searching of the libraries in a JCL?
In My job I have 15 procs.and in each proc i have 3 steps. i want to execute 3 step in proc 10.is it possible? if possible how?
wht is step lib n job lib ? where can we code joblib n steplib ?
what EXEC statement is and what is the syntax of EXEC statement used in JCL?
What is the function of dd name parameter with a 2 part structure; audit.report?