Search found 19 matches
- Wed Aug 14, 2013 12:19 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Unload table and create XML
- Replies: 0
- Views: 2219
Unload table and create XML
Hi All, Just wanted to know is there any utility in DB2 v10 which unloads tables with non-xml data and create XML file. We have a requirement to send unloaded data in XML format. We are using COBOL to create XML files after unloading the data from database. But it is having very high cost. So, pleas...
- Thu Apr 11, 2013 12:38 am
- Forum: JCL
- Topic: Need some idea on a job: JCL
- Replies: 3
- Views: 4199
- Wed Apr 10, 2013 7:02 pm
- Forum: JCL
- Topic: Need some idea on a job: JCL
- Replies: 3
- Views: 4199
Need some idea on a job: JCL
Hi, I need some idea, on one of my requirement. 1. There are 5 jobs runs at 5 different time. USD3L(runs at 00:30 MST), HKX12(runs at 3:30 MST), USD1E(runs at 9:30 MST), USX22(runs at 17:30 MST), USD4C(runs at 22:30 MST) 2. I need one sentinel job (MYJOB) to check whether above jobs are completed or...
- Wed Feb 13, 2013 8:12 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Dynamic output corresponding to input using DFSORT
- Replies: 6
- Views: 7303
If you don't get the right answers, check the starting positions of the messages. It works with the data I tested with, which I suspect is not your actual data. Since I can't see your actual data, I can't tell, but I suspect you need to change 1,6 to 2.6 at least. Check with your data. Hey collins,...
- Tue Feb 12, 2013 9:33 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Dynamic output corresponding to input using DFSORT
- Replies: 6
- Views: 7303
- Mon Feb 11, 2013 6:28 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Dynamic output corresponding to input using DFSORT
- Replies: 6
- Views: 7303
- Sun Feb 10, 2013 11:23 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Dynamic output corresponding to input using DFSORT
- Replies: 6
- Views: 7303
Dynamic output corresponding to input using DFSORT
Hi All, I'v been assigned a short project (7 days) in DFSORT. I tried for last 3 days, but not able to do anything. I need help. Here is my requirement: I have one input file but the content is different. It may like this: ERROR: NO JOBS/LINES WERE SELECTED FOR OUTPUT Or it may be like this: 1DB2PAR...
- Sat May 19, 2012 6:09 pm
- Forum: JCL
- Topic: GDG and DFSORT
- Replies: 5
- Views: 9516
- Sat May 19, 2012 6:06 pm
- Forum: JCL
- Topic: GDG and DFSORT
- Replies: 5
- Views: 9516
- Fri May 18, 2012 11:17 pm
- Forum: JCL
- Topic: GDG and DFSORT
- Replies: 5
- Views: 9516
GDG and DFSORT
I have some problem with DFSORT. I was trying to do it but I am not able to. I'm trying to explain my scenario. I have one GDG base with 3 generation named SSR.SUDIPGDG.MY1STGDG.G0000V00 SSR.SUDIPGDG.MY1STGDG.G0010V00 SSR.SUDIPGDG.MY1STGDG.G0020V00 IN ALL CASES (LRECL=133,RECFM=FB,BLKSIZE=27398) In ...
- Sun Apr 29, 2012 2:34 pm
- Forum: DB2 INTERVIEW QUESTIONS
- Topic: CURSOR
- Replies: 7
- Views: 10997
If you want answers in a forum you have to research first and only post if you have problems understanding the answers you find. The first place to go is co-workers, then the manuals (and the IBM ones are available online at no charge), then search the internet and forums. And you can buy books. Yo...
- Sun Apr 29, 2012 2:22 pm
- Forum: DB2 INTERVIEW QUESTIONS
- Topic: CURSOR
- Replies: 7
- Views: 10997
What did you find in the DBD SQL Reference? Specifically unde DECLARE CURSOR and even more specifically in the examples shown? I have not searched for the answer anywhere. I got these questions in one of my interview. I want to learn DB2, that's why I've joined these forum. I know little bit of SQL...
- Sun Apr 29, 2012 2:18 pm
- Forum: Suggestions & Feedback
- Topic: Unable to post in a topic
- Replies: 5
- Views: 10404
- Sun Apr 29, 2012 2:16 pm
- Forum: Suggestions & Feedback
- Topic: Unable to post in a topic
- Replies: 5
- Views: 10404
- Sat Apr 28, 2012 2:52 pm
- Forum: Suggestions & Feedback
- Topic: Unable to post in a topic
- Replies: 5
- Views: 10404
Unable to post in a topic
I have joined today in this forum. I have made 4 posts under DB2-SQL topic. But what I want is to download the DB2 quick start guide for which I have to make another 6 posts. But when I am going to post something in the topic named DB2 QUICK START - FREE for Members , I'm getting information like "S...