JCL for PS(I/P) -> table(Select query) -> PS(O/P)

nkothako · Posted: Sat Jan 04, 2014 12:45 am

I/P
1 - 8 char
9 - 12 char
13-16 char

Select query
select col1,col2, col3, col4 ...etc., from table a
where col1(1-8 i/p file) and col2(9-12 i/p file) and col3(13-16 i/p file)

o/p
The result of select query output should be written in output file

note : My input file can be blank and at that time JCL should write all the rows of the table(col1, col2, col3,col4...etc..)

Is this possible using JCL without writing a cobol pgm...

Akatsukami · Posted: Sat Jan 04, 2014 1:05 am

Of course, you are jesting with us, as after more than five years you must know that JCL does nothing but establish environments and execute programs.

To fulfill your goal, I recommend SQL formatted by Rexx and executed by DSNTIAUL.

daveporcelan · Posted: Sat Jan 04, 2014 1:25 am

The TS failed to tell us how many possible input records there could be.
Or the amount of data on the table.

The SQL may be:
IF ((col1 = '12345678' and col2 = '1234' and col3 = '1234') or
(col1 = '12345678' and col2 = '1234' and col3 = '1234') or
(col1 = '12345678' and col2 = '1234' and col3 = '1234') ......

An alternate approach....

Akatsukami · Posted: Sat Jan 04, 2014 1:41 am