Thank you very much Ray!!
Regards,
Search found 500 matches
- Thu Dec 17, 2009 10:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Copy Stage as the end Stage
- Replies: 2
- Views: 3422
- Wed Dec 16, 2009 6:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Copy Stage as the end Stage
- Replies: 2
- Views: 3422
Copy Stage as the end Stage
Hello, I have a strange scenario, where we have a copy stage as the end stage. Could you please tell me, if there would be a problem like records being held in the memory. or any possible memory being held and not getting freed. Usually we flush the unwanted records to /dev/null directory of our uni...
- Fri Oct 09, 2009 7:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: put message to websphere MQ connector
- Replies: 1
- Views: 2436
put message to websphere MQ connector
hi, i have following scenario: database----extract---File File---Put---- MQ All the data put to queue as single message, by configuring sequential file. here the queue has limit of 4 mb, i can get a scenario where data is greater than 4mb. In that case i have to split it in say 1000 records / file u...
- Thu Sep 17, 2009 12:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update not working
- Replies: 5
- Views: 3795
Update not working
Hi All, I have a following job design sequential file -- transformer - Oracle enterprise stage. I need to update the table incase of matching key columns otherwise i need to insert a new row. but even if there are matching rows, it still inserts a new row resulting in duplicates. i have verified key...
- Wed Aug 12, 2009 6:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue in connecting to database through SQLplus
- Replies: 1
- Views: 5068
Issue in connecting to database through SQLplus
Hi All I have an issue connecting to oracle database through SQLPLUS. Datastage is installed in one server and Oracle database is in another server. I have updated TNSNAMES.ORA file with connectivity details to above mentioned oracle database. i am able to connect to oracle database through datastag...
- Wed Jul 15, 2009 1:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Commit Frequency of a Stored Procedure Stage
- Replies: 1
- Views: 2585
Commit Frequency of a Stored Procedure Stage
Hi , I am executing a stored procedure by passing parameters from a dataset file.No COMMIT statements are given in the stored procedure. Intention is to rollback all records processed by this job in case of any failure. I have set the transaction size to '0' . My question is whether COMMIT happens i...
- Wed May 27, 2009 7:47 am
- Forum: General
- Topic: Migration of code from 7.1 to 7.5.1
- Replies: 3
- Views: 3711
Re: Migration of code from 7.1 to 7.5.1
Will thr be any change in the data formats(date) if a code is mgrated from DS 7.1 to DS 7.5.1, as 7.1 doesn't support NLS The difference in the dsx(for same code) taken from 7.1 and 7.5.1 servers was in the Character Set. 7.1 used ENGLISH as the character set and 7.5.1 used CP1252 but the NLSLocale...
- Thu May 21, 2009 12:18 am
- Forum: General
- Topic: Migration of code from 7.1 to 7.5.1
- Replies: 3
- Views: 3711
Migration of code from 7.1 to 7.5.1
Will thr be any change in the data formats(date) if a code is mgrated from DS 7.1 to DS 7.5.1, as 7.1 doesn't support NLS
- Thu May 21, 2009 12:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Invoke JCL through Datastage
- Replies: 8
- Views: 9478
- Wed May 20, 2009 10:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Invoke JCL through Datastage
- Replies: 8
- Views: 9478
Invoke JCL through Datastage
Hi,
I am using Datastage EE v8.0.1 on AIX. Can you please let me know if we can invoke a JCL through datastage job, sequencer or UNIX script.
Thanks.
I am using Datastage EE v8.0.1 on AIX. Can you please let me know if we can invoke a JCL through datastage job, sequencer or UNIX script.
Thanks.
- Sun May 10, 2009 9:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Archive job design suggestion
- Replies: 1
- Views: 2793
Archive job design suggestion
hi, I have a series of server jobs DRS stage ------ Transformer---- Sequential file the number would be 33 similar jobs like above with different tables. These job are being called using set of sequencer jobs. The requirement is to archive old data Each tables holding approx a million of rows to arc...
- Sat May 09, 2009 5:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error 80040154 Unable to initialize datastage compiler
- Replies: 1
- Views: 3488
Error 80040154 Unable to initialize datastage compiler
Hi , I have created a batch file to compile a job in unix server. Below commands are used in the batch file for accessing dscc utility. cd D:\Program Files\Ascential\DataStage7.5.1 dscc /h <host> /u <userid> /p <passwrd> /j <jobname> <projectname> I kept the batch file in a D: drive location and exe...
- Tue Apr 28, 2009 7:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: kicking off multiple instances in one dsjob command
- Replies: 4
- Views: 4313
- Tue Apr 28, 2009 11:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: kicking off multiple instances in one dsjob command
- Replies: 4
- Views: 4313
- Mon Apr 27, 2009 8:59 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: kicking off multiple instances in one dsjob command
- Replies: 4
- Views: 4313
kicking off multiple instances in one dsjob command
I have 2 queries.
- Is it possible to kick off multiple instances of a job with different instance ID in a single dsjob command?
- How can I check all the instances of a job is finished? As and when all the instances finished, I need the return the control to job invoker.
Thanks.
- Is it possible to kick off multiple instances of a job with different instance ID in a single dsjob command?
- How can I check all the instances of a job is finished? As and when all the instances finished, I need the return the control to job invoker.
Thanks.