Search found 19 matches

by its.sudip
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...
by its.sudip
Thu Apr 11, 2013 12:38 am
Forum: JCL
Topic: Need some idea on a job: JCL
Replies: 3
Views: 4199

William Collins wrote:Why not have five JOBs, using the one PROC, scheduled at appropriate times?
Thanks collins, I also wanted to do so. But actually there are total 19 jobs I have to check, I gave 5 jobs as example. And i'll not be getting permission to push 19 jobs. Any other idea plz :roll:
by its.sudip
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...
by its.sudip
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,...
by its.sudip
Tue Feb 12, 2013 9:33 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Dynamic output corresponding to input using DFSORT
Replies: 6
Views: 7303

SORT FIELDS=COPY OUTFIL FNAMES=SORTF01,INCLUDE=(1,6,CH,EQ,C'ERROR:'), OVERLAY=(C'Q899D4C0 DID NOT RUN FOR THE DAY ',DATE=(MD4-)) OUTFIL FNAMES=SORTF02, INCLUDE=(37,13,CH,EQ,C'EXECUTED ON :'), NULLOFL=RC4, OVERLAY=(C'Q899D4C0 COMPLETED SUCCESSFULLY FOR ',DATE=(...
by its.sudip
Mon Feb 11, 2013 6:28 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Dynamic output corresponding to input using DFSORT
Replies: 6
Views: 7303

Fristly, the WER messages indicate that you are using SyncSort. Secondly, you may only have one INREC per execution. Thirdly, wherever you physically locate INREC, Sort will operate upon it where it feels like. SORT FIELDS=COPY OUTFIL FNAMES=SORTF01,INCLUDE=(1,6,CH,EQ,C'ERROR:'), OVERLAY=&#...
by its.sudip
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...
by its.sudip
Sat May 19, 2012 6:09 pm
Forum: JCL
Topic: GDG and DFSORT
Replies: 5
Views: 9516

Sudip, You can use a DFSORT job like the following to do what you asked for: //S1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN=... input file (FB/133) //SORTOUT DD DSN=... output file (FB/133) //SYSIN DD * OPTION COPY INCLUDE COND=(2,13,CH,EQ,C'CURRENT DATE:',OR, 2,13,CH,E...
by its.sudip
Sat May 19, 2012 6:06 pm
Forum: JCL
Topic: GDG and DFSORT
Replies: 5
Views: 9516

DikDude wrote:Is there some reason you did not post this in the DFSORT part of the forum?
No such reason was there. I thought it would be better if I post it in a new topic. Thanks DikDude for the info.
by its.sudip
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 ...
by its.sudip
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...
by its.sudip
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...
by its.sudip
Sun Apr 29, 2012 2:18 pm
Forum: Suggestions & Feedback
Topic: Unable to post in a topic
Replies: 5
Views: 10404

NicC wrote:and have you read the replies from the moderators in the DB2 forums? You have to make 10 MEANINGFUL posts and two of the moderators have deemded your posts not to be MEANINGFUL.
Why it is not MEANINGFUL? I didn't understand what you want to say. Please forgive me if I'm wrong.
by its.sudip
Sun Apr 29, 2012 2:16 pm
Forum: Suggestions & Feedback
Topic: Unable to post in a topic
Replies: 5
Views: 10404

Krishna wrote:Did you clicked on "Post" Button?
Yeah, I clicked on "Post" button. Shouldn't I? I'm new in this forum, please tell me what to do.
by its.sudip
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...