DSXchange

hi, we have offshore team back in india, i want to export these jobs.so went to manager, choose the project where i developed jobs, click on EXPORT. but shall i select datastage component or executable job, prob i should select executable job just want to make sure am i going in the right way. i wil...

hi,
sorry,now its running fine.
but i cant see the message displayed on my system.
it doesn't notify me that all jobs are successfully completed.
plz help me, how can i get a notification.

cheers;
saama

hi, jobactivity----->jobactivity----->executecommand activity. in the execute command tab. command- net send my computer name parameters- all jobs are successfully completed. iam getting the error message. SEQEXECUTECOMMAND..JobControl (@Job_Activity_2): Controller problem: Error calling DSAttachJob...

hi gurus,
Thanks very much its working fine.

cheers;
saama

hi gurus, when i used KeyMgtGetNextValue(drs14*)=id here id is the o/p column name drs14= jobname iam getting error =" variable drs14 is not defined" i tried various other ways. only when i use keyMgtGetNextValue(@INROWNUMBER) I could validate the expression. but can generate sequences fro...

hi, thanks gurus, i really appreciate. i have given incomplete information. in the transformer stage, i have given, keymanagementnextvalue(@INROWNUMBER)=id where id is the o/p column in my target stage which i defined manually constraint=@inrownumber<10 stage variable 'sv' and assigned to 1. when i ...

hi, thanks gurus, i really appreciate. keymanagementnextvalue(@INROWNUMBER)=id constraint=@inrownumber<10 stage variable 'sv' and assigned to 1. when i compile and run.its running fine, and iam able to generate surrogate key , the sequence is 3,4,5,6. why iam not getting from 1,2,3,4,5... .plz help ...

hi, iam using ODBC----->TRANSFORMER---->ODBC. in the o/p stage, i created extra column called id for surrogate key. i have defined a stage variable called SV and intialized to 1 i have called routine called keymanagement next value and it has parameter called sequencer name. what shall i enter in th...

Hi gurus,
Thanks very much.

cheers;
saama

hi, as pivot stage transforms vertical rows into horizontal and vise versa. i went through manual and found that these rows should have relationship. i want to help my team lead to exactly analyze the working of pivot stage. my source data has colums like CUSTOMER ID PAYEMENT LOCATION. i see that th...

Hi gurus,
thanks very much.

cheers;
saama

hi, iam using aggregator stage inorder to do sum . i want to calculate the sum of the salaries of the employers. in aggregator stage i/p stage i didn't do any changes. in the o/p stage, salary column- i derived as SUM(SALARY),i have GROUPED EVERY I/P COLUMN. it doesn't show the sum, infact it just d...

Hi gurus,
Thanks very much my DSN was not properly configured.
thanks again.


cheers;
saama

Hi, i dont have ascential drivers. is that the drivers problem, iam getting few other errors too. iam getting DS BROWSER: DYNAMIC_RDBMS:SQL BIND COL:FAILED TO BIND THE RESULT SET COLUMN. DSBROWSER: DYNAMIC_RDBMS:DS LINK1:DSP.OPEN GCI $DSP.OPEN ERROR. i would appreciate if anyone helps me out. cheers...

hi gurus, i wanted to show my team lead how DRS works, i used DRS stage as source and DRS stage as target. in the DRS STAGE iam extracting data from SQL SERVER. given DATABASE TYPE AS - mssql server. connection- defined new dsn by selecting the drivers for SQL SERVER. i have tested the connection wh...