MVSFORUMS.com

krk123 · Beginner Joined: 03 Jun 2003 Posts: 58 Topics: 19

Hi,
I am trying copy records from a very big flat file to a VSAM file. I am using repro to copy. Is there anyway we can specify a condition while copying i.e I am looking for something like

SORT FIelds=copy
include cond=(10,5,ch,eq,c'xxxxx).

Is this possible to do with repro.

regards,
KRK123

Cogito-Ergo-Sum · Posted: Fri Nov 07, 2003 4:06 pm Post subject:

Krk,
Why would you not want to use SORT??

Anyway, REPRO does have conditional copying capability. But, it is limited to ranges. That is, you can copy records between FROMKEY and TOKEY or, between FROMADDRESS and TOADDRESS and, between FROMNUMBER to TONUMBER. Niether of these will help you.

So, the answer is NO.
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.

Frank Yaeger · Posted: Fri Nov 07, 2003 4:28 pm Post subject:

KRK123,

You can use DFSORT to copy the large flat file to a VSAM file. Just specify SORTIN as the flat file and SORTOUT as the VSAM file. That will allow you to use the DFSORT INCLUDE statement you want.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

kolusu · Posted: Fri Nov 07, 2003 4:39 pm Post subject:

Cogito,

you are partially correct. If the input file is KSDS or ISAM(no longer supported) then you can use repro with include cond.

The technique is to code the same key for both the FROMKEY & TOKEY

for ex:

Cogito-Ergo-Sum · Posted: Fri Nov 07, 2003 4:52 pm Post subject:

Kolusu,
I am aware of that technique. As his input is PS, I did not post it.

I should have posted it to maintain some "generality".
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.

krk123 · Beginner Joined: 03 Jun 2003 Posts: 58 Topics: 19

Cogito, Kolusu & Frank thanks a lot for your help and your time. I will use DFSORT.

Regards,
krk123