MVSFORUMS.com

@Dibakar, Thats sounds fine but I am looking forward to run the same with no manual intervention. In this case I would need to change the SYSIN everytime with the required value.

Thank You

@Christian, I have 1 SELECT SQL. The output of which needs to be stored in a DS. I need to run these SQL's with various parameters, say If we have a SELECT SQL like, SELECT * from TABLE where COLUMN1= ...

I am looking to run a SPUFI with a defined number of times using an input file which has the required parameters for the SPUFI from a JCL. Is this really posssibe using a JCL? Or Can REXX be used to ...

This is CLOSED, operator FIRST worked as expected Very Happy

Thank You Frank Yaeger and superk

FYI, for those interested, according to previous topics, sakreg is using SYNCSORT.

superk,

I am using ICETOOL

//TOOLIN DD *
SELECT FROM(IN01) TO(FS ...

Missed to add this,

In the input file, I should exclude the First and Last rows from the SORT, they are the header and trailer.

There is a feature with ICETOOL to include or exclude DUPLICATES l ...

Input File:
----+----1----+----2----+----3----+----4-
********************************* Top of
0015007510300000621012000-09-262000-10-18
0015007510300000621012000-10-189999-12-31
001500751030000 ...

Thank You for your time vivek1983.

I am all set now Very Happy

vivek1983,

I got what I want. I would be happy if you can explain the usage of overlay. I thought I should use 49, Why are we using 69 to get the actual output at 49?

Thank You
SAK.

vivek1983

I have some difficulty when trying to use with files instead of instream data. Maybethe postion is what matters.

Input File #1 is FB, LRECL = 20
Input File #2 is FB, LRECL = 50

Ou ...

vkphani,

Thank you for your EZT solution. I know this works in our shop. But I have NOT worked with EZT before. But the solution is more understandable. I will give a try with EZT as well.

Your output doesn't seem to match your input or rules. For example, I see the following match on an account number in input file1 and file2:

and I would expect an output record for that account wi ...

vivek1983,

That works like a charm. Thank you very much.

Input File #1

Position 01 thru 18 => Account Number (Length : 18 )
Position 19 thru 20 => Pay Day (Length : 02)

----+----1----+----2----+----3----+----4----+----5----+----6
*********** ...

Has anyone worked with a Project that deals with FTP'ing from Mainframe to Windows using OpenSSH SCP command? If any, can you please share some thoughts,code and what is required at both ends.