DSXchange

Thank you very much Ray!!

Regards,

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...

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...

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...

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...

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...

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...

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

Thanks Ray!

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.

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...

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...

Thats correct. It is always better to check the status of the instnace in the loop.

Thanks Ray.

For answer 2:
Can I use ps -ef | grep "jobname" to find out the presence of process in unix server?
If I dont find anything, I will pass the control back to job invoker. This wait and check will continue until I dont find any process with that string. Is this suggestible?

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.