Search found 68 matches
- Wed May 19, 2010 7:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML Output stage
- Replies: 5
- Views: 20344
- Wed May 19, 2010 7:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML Output stage
- Replies: 5
- Views: 20344
XML Output stage
Hello While I am able to create a valid xml file sourced from a database table - i am not able to get the xml in the exact format required. For ex: if the following are source records Name Age Ad 1 Ak 2 I would like the output xml source code as <student> <Name> Ad</Name> <Age>1</Age> <Name> Ak</Nam...
- Wed Mar 01, 2006 10:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Deleting Job Logs (in Director) of instances created
- Replies: 1
- Views: 1754
Deleting Job Logs (in Director) of instances created
Hi, Have looked up the forum regarding this issue and as far i believe the deletion of the logs of the instances created, as shown in director is a manual process. The problem is we have a common job which is being called at least twice in about 119 sequences being run daily/weekly/monthly. and dele...
- Tue Jan 17, 2006 3:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: STOREDPROCEDURE
- Replies: 6
- Views: 3480
I find it straight farwords SQFILE---->stored procedure------->file Keshav, stored procedure stage is available in Data Stage 7.5 so its ok for them but for prior versions we have call SP trough OCI or ODBC stage Thanks If you're not on a version lower than DS 7.5 you cud use the OCI stage for call...
- Tue Jan 17, 2006 2:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning msg when calling server routine in parallel jobs?
- Replies: 8
- Views: 6059
I have tried that but still it logs warning. I have simplified the job sequence to just calling a routine but still it logs warning. We used to set the trigger to un-condition for routine activities, no matter what it returns we just want the return value to be picked up by a followed job activity ...
- Tue Jan 17, 2006 2:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Assigning the output of DSExecute command to job Parameter
- Replies: 4
- Views: 3299
- Tue Jan 17, 2006 2:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CREATING AN XML FROM A TXT FILE
- Replies: 1
- Views: 1912
- Tue Dec 20, 2005 12:04 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Handling Errors while reading file in Job Control
- Replies: 2
- Views: 2255
- Tue Dec 20, 2005 10:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Handling Errors while reading file in Job Control
- Replies: 2
- Views: 2255
Handling Errors while reading file in Job Control
Hi Have been sweating it out wothout much success over checking for the presence of a file and if present reading a record through the Job control. If CurrentStatus ='R' Then OPENSEQ '/home/adarsh/':SequenceName:'.txt' TO FILE THEN READSEQ LoadIdTimeStamp FROM FILE THEN TimeStampVal=Field(LoadIdTime...
- Mon Dec 19, 2005 12:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: db2 Enterprise Stage delete using Open Command
- Replies: 10
- Views: 8313
Re: db2 Enterprise Stage delete using Open Command
Am sorry but dont u think that wud delete all the records!!!DataStageCnu wrote:Hi,
Try some other way..
Delete table <---> where 1=1
Is it help you..??
- Mon Dec 19, 2005 8:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: db2 Enterprise Stage delete using Open Command
- Replies: 10
- Views: 8313
So you could perform your delete if your job aborts, a sequence job trigger executes a delete/rollback job that gets passed the process id and table name as a parameter and removes the transactions from that table. Could be used for any table. Hi Could you tell me what the pid would help me doing -...
- Mon Dec 19, 2005 3:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compiler/License issues
- Replies: 3
- Views: 4627
- Sat Dec 17, 2005 7:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to run a job in multiple instances
- Replies: 17
- Views: 9244
Thanks guys I'm using the JobPID value returned, in addition to a timedate() value and it works pretty fine over the initial tests done - I'm not quite sure about usinfg the RND() function coz i agree that unless u seed it with a inherently unique value - the ouput will not be guaranteed unique - th...
- Fri Dec 16, 2005 1:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to run a job in multiple instances
- Replies: 17
- Views: 9244
How about using the system time as the invocation ID, or some other value. Hi We're calling a common job (multiple instance toggled on) from a routine which may be called parallely My doubt is even if do use the time returned by a timedate() function, it does not guarantee uniqueness of invocation ...
- Thu Dec 15, 2005 12:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Restartabilty issue due to invocations with diff parameters
- Replies: 3
- Views: 3784