DSXchange

Hi Ray,

Can u plz guide me on determining the packet_size and row_size ?

Warm Regards,
Asit

Hi, I am trying to use Exception Handler along with Terminator stage. There two jobs which run parallely, to fecth data from two different tables. Now, the idea is to abort the master sequence immediately , after either of the jobs has aborted. When I am using Exception handler along with Terminator...

Hi Ray,

The DB is on a separate machine.
Please advice me how to determine packet_size and row_size ?

The deletes may scale upto 6 million a day !!!

in my last run, deleting 6 Million rows, took 45 minutes !!

Please advice,
Asit

Even I agree with Ray's post... Mod(@INROWNUM,3) I am implementing a similar logic for partitioning the input data for my process...where I have to load apporx 30Million data in daily basis.... Its a real good approach... you must desgin your own logic to split the data into different sets and proce...

Coz there is neither a retrun code nor any output of executing this command...
It is echoing your text , which has been piped to file, FILE1.TXT, which is correct...


Try executing the command on the command prompt !!

Hi,

Can u plz exzplain " jobs do not clean themselves up after running" ??

May be I can then help...

Hi,

Even I face the same problem, could you please tell what shoudl be done once I get this problem... ususally I restart the Datastage Services... is it the only way to unlock a job ???

Hi, I need to delete some rows from the tables, for which I have the keys in an input file. With the help of 1 key-set, the corresponding data needs to be deleted from 3 tables ( 1 parent and 2 children tables ). How should I determine the Array Size and Transaction size ?? The help guide does not m...

Sorry.. it now worked...
I used the following command...

Hi, I am running a job from CLI, using dsjob... I am not able to pass the parameter values.. as my job has more than one job parameter... eg.. INSTANCE $USERID $PWD My command is C:\Ascential\DataStage\Engine\bin\dsjob.exe -server 127.0.0.1 -user Guest -password Guest -run -mode NORMAL -param "...

Hi All,

I am using DSRunJob() to run a job from the routine.

How do I check the job's completion status in the same routine ??

If I am trying to use DSGetJobInfo(),, then I get status as 3 i.e Running..

But I want to capture the job's finish status ... How ??

Ya, I agree with this approach too.. but in my actual case, the volume of data to be fetched initially and then join with the hashed file in the transformer, is too much. for instance 1 million !!
so this can be a costly affair.

Ya, I agree with this approach too.. but in my actual case, the volume of data to be fetched initially and then join with the hashed file in the transformer, is too much. for instance 1 million !!
so this can be a costly affair.

Hi All, I have a case like this: Db2 Stage > Transformer > SequentiaFile From the DB2 database, I want to fetch the data from the below query: SELECT SETID, RECNAME,BUSINESS_UNIT, LEDGER FROM PS_MYTABLE WHERE SETID = ? AND RECNAME = ? Now, the list of keys I have is: SETID RECNAME ----- --------- SH...

Hey Good news...

I got it back..
After unistall..I also ensure to clear all the entries for Version Control, using regedit.. there were 3 - 4 entries..

Yippy.. I am safe now

Thx to all and I hope this helps the needy too.