MVSFORUMS.com

After editing the dataset, my control stops at the edited dataset. doesn't close, come back adn open another one. here is the code:

main program:
/* REXX */ ...

I am trying to edit my PS datasets as below:
DS=HLQ1.HLQ2.Z||"*"||.HLQ4.HLQ5
"ISPEXEC LMDINIT LISTID(IDV) LEVEL("DS")"
DO FOREVER ...

I just got it. Thanks

i have lots of datasets with one of the middle qualified varying like below:

HLQ1.HLQ2.HLQ3.HLQ4.HLQ5

HLQ3 = Axxxxxxx where xxxxxxx is varying.

I would like to list out all the datasets in ...

Hi,
I have a requirement:

there are lots of datasets like this:
HLQ1.HLQ2.HLQ3.HLQ4.HLQ5 with varying HLQ3 for each dataset. HLQ3 is Axxxxxxx, where xxxxxxx is varying.

I would need to open al ...

Thanks Frank. It works.

here is my requirement:
input file is generally lesser LRECL than ourput file. I wanted to pad some special character till the end of it.

we generally use 100:X to pad with spaces till 100th position.

IS there a way to pad with some other special character instead of space?

for one of the numeric item, I defined my input copybook as unsigned data field; Eg.: PIC 9(4).

If input fiel contains negative value (because my source system sends negative value), what my progra ...

Vivek1938,
Unfortunately, I'll have to run these queries from within a JAVA application, hence I couldn't us the MVS utilities from JAVA.

Kolusu,
This gives all the rows in table3 that have matching rows in table2 adn 1. There are possibly duplicates. I dont want them and I dont want to do a distinct since there are more than million ...

And as I said earlier, I need to perform LEFT JOIN to the above resultant of table1, 2, and 3

Kolusu,
Let me give more specific details:

Table1 and table2 needs a JOIN, as there are some extrax columns in table2 than in table1 that I need to use in JOIN between table2 and table3.

e.g:
...

Kolusu,
What if am looking for more than one column. Instead of ID, it is 4 columns that I wanted to join on.

Also the join participants between table1 and 2 are different from the participants b ...

table1;
ID Name seq number
11 AAA 1
22 BBB 1
33 CCC 1
44 DDD 1
55 EEE 1

table2:
ID indicator
11 Y
22 N
33 N
44 N
55 Y

table3:
ID Amount
11 100
11 100
11 100
22 200
22 200
33 3 ...