DSXchange

I ran a job. The job has once source ORACLE 9i stage, one transformer and one target ORACLE 9i stage. 41,000 records were selected from source ORACLE 9i stage . but after 27,000 records were inserted into target, i can see the job remaining standstill i.e there is no increase in no. of records writt...

ArnDW , can u pls elaborate on how to execute this dos statement in DataStage.

I have a source DRS stage A , it is connected to a transformer Tr, and TR is connected to two target DRS stages B,C. When i run the job, in director i observed the following: trace mode =0 for transformer. then sql in A got executed. then sql in B got executed. then sql in c got executed. then a war...

When i delete a job named A I get an Error as follows: Error while deleting job A File RT_CONFIG14 has apparently not been deleted from the directory File RT_STATUS14 has apparently not been deleted from the directory File RT_LOG14 has apparently not been deleted from the directory File DS_TEMP14 ha...

Thanks WoMaWil ,


How can i know the path of the Hash file which i created in a DS job.
And also i don't have access to the server.

How to find the path of a hash file.


And also pls explain the usage of Open statement.

Sorry, the OS is Windows , but not Unix.

How to use the routine KeyMgtGetNextValue, for getting the surrogate key from a Hash file created by the user.


i.e if i want to get the number of rows in a hash file, can i use this routine.


And also how this routine works.
Thanks in advance for your suggestion.

I have given a constarint fro a link and when the job ran , 2 rows went through that link out of 4 rows. Then , when i removed the link, saved the job and ran the job again. Then also only 2 rows went through it, though i removed constraint. What is the reason for this . How to rectify this. Thanks ...

I have written a code as follows in a routine CMD= "SELECT * FROM abcd" Call DSExecute("UV", CMD, result, sysreturncode) Ans= result When i tested the routine i am getting answer as 'SQL'. Why is it. What should i do if i need to get the output of SQL as the output of routine. Wh...

Hai ray.wurlod , thanks for your reply , how can we know deadlock deamon is running on server, how can an administrator release the lock for a routine.Can u explain this pls Hai lynnliu thanks for your reply, Only for jobs, we can get process id in Director . But can we get process id for routines i...

I executed a job and the job got stuck while executing a routine. When i tried to stop the xecution of the job, it did'nt happen. So, i used "clean up resources" option and released all processes for that job. Now, i can compile the job again. But , when i tried to open the routine , it sa...

Thanks for your replies, but i should say sorry because ,i tried to copy a routine activity of a sequencer job into a server job. This is the mistake i did. So, i did'nt get copied. Immediately without checking the jobs , i posted this :? Otherwise, we can copy between two DS sessions also, if the j...

Is Copying of stages from one job to other job not possible in DS 7.0.

When i tried this, it was not possible. But i tried to copy in the same job it happened.


In DS 7.1, this was possible , but in DS 7.0, it was not possible.


Is it possible in DS 7.0