MVSFORUMS.com

I had asked the above question because I do not have access to Plan_Table and hence I wont be able to run "Explain". Any inputs are appreciated.

I have a similar qustion. All I wanted to know which will get executed first in the above query. "ON" or "WHERE".

Kolusu,
Thanks. This is what I wanted. The minor cosmetic bug..yes. I mean the extra space when concatenating the next line.

Thanks again.

Kolusu,
The last line will not have any Delimiter

It is a copy paste error. There will not be any line without a delimiter at all.

Thanks,
Arun.

Sorry for the overlook.

With the above code I feel that the output is not in exact order of input. Due to this the output is in a jumbled fashion. My original input file is

sue kumar||13|| 1|| ...

Thanks for help Kolusu. I am getting the following output when I ran the above code.

AAAA BBBB CCCC
DDDD EEEE FFFFF 00090011 GGG HHHHH
XXXXX 00100011 YYY ...

Kolusu,

Thanks for the response. There could be maximum of 2 delimiters(period) in each line. Most of the lines have one Delimiter only.

Thanks,
Arun.

Hello,

This is an extension of the below topic:
http://www.mvsforums.com/helpboards/viewtopic.php?t=4036&highlight=delimited

I have a file like the one below:
FB;REC LENGTH IS 80
1....... ...

If we learn to write proper Telon programs they will be wonderful. You can not even compare CICS with it. Many commonly used logics are handled by Telon. You will reduce atleast 50 % of your work in T ...

Kolusu/Frank Yaeger,

Thanks very much. Frank's solution is working for me.

-Arun.

Hello,

Below is the requirement

File 1

003145,0986,2006-01-18, ,007894
000784,4564,2006-02-10, ,032891

We have to get in File 2 by removing all leading zeroes and spaces ...

All,
Thanks for the reply. My requirement was, since I am developing new programs, I need to check whether the error handling is working correctly or not. So I want to know of any common method by wh ...

Many times for the purpose of Testing, I need to simulate DB2 abends,i.e SQLCODE should be other than 0 or 100. I used to do it through Xpeditor. Is there any simple way by which I can simulate some a ...

Thanks. That' s true. But I have to use 50 files to the maximum. It means I have to define 50 flags. Is there any other way?