Search found 7 matches
- Wed Mar 11, 2020 10:46 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Query in INREC IFTHEN=(WHEN=GROUP)
- Replies: 0
- Views: 8526
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...
- Thu Feb 27, 2020 10:58 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Query in XMLtable used in DB2
- Replies: 0
- Views: 27797
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...
- Mon Aug 19, 2013 4:00 pm
- Forum: IMS DB
- Topic: IMS TO DB2 Migration
- Replies: 3
- Views: 5402
- 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.
Can someone provide me the step by step process to be carried out for the conversion.
- Sun Feb 10, 2013 6:24 pm
- Forum: COBOL
- Topic: Eliminate Junk data in string
- Replies: 4
- Views: 7042
- Sun Feb 10, 2013 1:26 pm
- Forum: COBOL
- Topic: Eliminate Junk data in string
- Replies: 4
- Views: 7042
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...
- 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...