Search found 7 matches

by gyt3
Wed Mar 11, 2020 10:46 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Query in INREC IFTHEN=(WHEN=GROUP)
Replies: 0
Views: 8543

Query in INREC IFTHEN=(WHEN=GROUP)

Hi All, I have an input like this <Request RequestID="5803727242796658404053" <BillTo> <CustomerID/> </BillTo> <Events> <Event> <Event>Stop Payment</Event> <EventDate>2020-01-31T16:00:00Z</EventDate> </Event> </Events> </Request> <Request RequestID="5809478787336002204087" <BillTo> <CustomerID/> </B...
by gyt3
Thu Feb 27, 2020 10:58 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Query in XMLtable used in DB2
Replies: 0
Views: 27815

Query in XMLtable used in DB2

Hi All, My requirement is to read the xml file and fetch the values stored in XML tag. For which I had used XMLTABLE. I am getting SQL code - 100 during fetch, I tried several things, but, everything returns only SQL - 100 during Fetch. Can someone please look at this and correct the code and help m...
by gyt3
Mon Aug 19, 2013 4:00 pm
Forum: IMS DB
Topic: IMS TO DB2 Migration
Replies: 3
Views: 5402

No .. Could you please give me some links for the Manual..I searched for it .. But could nt locate it.
by gyt3
Mon Aug 19, 2013 2:50 pm
Forum: IMS DB
Topic: IMS TO DB2 Migration
Replies: 3
Views: 5402

IMS TO DB2 Migration

We are planning to migrate our IMS database to DB2 .
Can someone provide me the step by step process to be carried out for the conversion.
by gyt3
Sun Feb 10, 2013 6:24 pm
Forum: COBOL
Topic: Eliminate Junk data in string
Replies: 4
Views: 7043

Hi Nic,

Thanks a lot for educating me that I should not multi-post.I was in need of an urgent solution so I posted in two different forums which I know.

Though you dint clear my technical doubt, you helped me out in knowing that I should not multi post.

THANKS.
by gyt3
Sun Feb 10, 2013 1:26 pm
Forum: COBOL
Topic: Eliminate Junk data in string
Replies: 4
Views: 7043

Eliminate Junk data in string

My input file is a comma delimited file and it looks like this, a1234,123,345,1200, b1234,123,345,19000, c1234,123,345,1, Sometimes, I may junk data in the input file like this a1234,123,345,1200, b1234,12fgdhg#$#%#$^$%&& c1234,123,345,1, If i get a junk data, I need to move the junk values to a sep...
by gyt3
Sun Dec 30, 2012 10:03 am
Forum: JCL
Topic: Concatenate Multiple GDG base only if the versions exists
Replies: 1
Views: 2847

Concatenate Multiple GDG base only if the versions exists

I have 15 input GDG base, and i want to concatenate them into a single output dataset. Out of 15, some GDG base might have versions , whereas some might not have. Will the job abend if there are no versions for atleast one of the 15 GDG base ?? If so , how can it be handled. Can anyone help me out i...