MVSFORUMS.com

'Find' is working now. Don't know why couldn't use it earlier.
Sorry for inconvenience.

Regards

Hello,
How can we do a search on particular word in TSQ ?

Regards

Hello,
I want to read a TSQ (line by line) and put the data in a flat file, by using the JCL. Please guide if we can do that. If yes, then please provide the sample.

Thanks

Right. Just now I noticed that it is NOSSRANGE in my compiler option instead of SSRANGE to have the subscript values checked at run time to see if they are in range. I should get S0C4 if it is more th ...

Yeah, I was expecting that but it did not happen and I got 110 accounts back. Just want to confirm if it is possible with this declaration.

Kolusu,

I have one more doubt.

10 SIBRU503-ACCT-ARRAY.
15 SIBRU503-ACCT-LIST OCCURS 0 TO 100
DEPENDING ON SIBRU503 ...

Thanks Kolusu. Its clear now.

Kolusu,
It might be the code bug but what I want to know is that if the table can really have 200 items even if the DEPENDING ON has a variable that can contain just 100 ?

Hello,

In the following Table declaration, I am using OCCURS for 200 TIMES while the value of WC-MAX-NO-OF-PROD is 100.

05 WT-BILL-ACCT-TABLE OCCURS 1 TO 200 TIMES
...

No, its simply like we need to run a particular program for day Numbers starting from 01 to 99. I tried to generate the control card dynamically and could write it into DHBK.BLQSAM.PARMS file using th ...

Kolusu,

If you see my very first post, there I have mentioned the L-RUN-DAYNO that needs to be passed as the symbolic parm because it will have values from 01 to 99 so really difficult to change it ...

Kolusu,
What exactly your last message convey? I need to pass symbolic parameter to the Cobol-DB2 program because I cant change the values everytime.
Please help.

Thanks for your help.
Couldnt really identify the reason but programs are working now.

Cheers
Nancy

Kolusu,

It worked for one of the program but now the same problem is coming to another two. Can you suggest something ? We have verified the SQL against Table and the column names look good.

Th ...

Yes, all the column names are correctly typed.
Actually I copied this SQL from a document and it is giving problem for the junk characters. But when I re-typed it manually on mainframe, it worked fi ...