DSXchange

Hi all I had two different kinds of environments. Env1 : DS version 8 running on Linux Env2: DS version 7.5x running on Windows server There are some jobs created in Env1 and i want to copy the same jobs to Env2 . I had exported the relevent jobs from Env1 and tried to import to Env2 . I am facing a...

Hi All I am trying to call a stored procedure from a datastage job through ODBC Enterprise Stage. The error is like this : ODB_ROLLBACK_STOREDPROCE: Write mode failure: exec CTRL.DBo.sp_rollback_cp, '821001', 'CTRL.DBo.LoadStatus','CPY.testcopy.WH_EMP' doesn't exist. The 4 parameters i am passing ar...

Hi ArndW

Thanks for your response

I am able to solve my problem , i just forgotten the string concatenation operator. (:).

like databasename:schemaname:tablename

Hello Friends I need a suggestion from you. I had a requirement like concatenating 3 parameters into 1 parameter and had to pass it to a sequence. Any thoughts please. example : i had 3 parameters like databasename,schemaname,tablename. I had to pass this values to one parameter like databasename+sc...

Hi
Thanks for your response

Regards
RK

Hi Thanks for your response there is a req for me like i need a value in some of the stages and that value i am getting it from a table. what is the best way to use that value which is coming from a table. I want to read it one time and want to use it in req stages and that is specific to a job leve...

Hi All
Can anyone share you idea that is there any chance to declare a global variable within a Parallel job , here i am not intersted to use environmental variable and parameter.

Thanks in advance
Regards
RK

Hi Can any one share your idea on my issue. I want to limit the number of rows to be loaded at runtime in director. But that was disabled in my director tool. I had checked in Administrator to tool to enable this but didn't find this option. Where do i had to set this option in administrator tool. C...

Hi
I am bit confused from where to start debugging this issue. Can some guide me to some extent to resolve this issue

Regards
RK

Hi I am trying to load data to a sqlserver table using odbc and i am getting this error. Can some one share your ideas. Message: 1: Failure during execution of operator logic. 2: Input 0 consumed 0 records. 3: Import complete; 189 records imported successfully, 0 rejected. 4: Failure during executio...

Hi chulett Thanks for your response. Thanks for your valable suggestions and guidence in the forum . I had implemented priyadarshikunal solution and it works fine. Hi priyadarshikunal Thanks for your response. I am able to solve my issue. Thanks for sharing your ideas. " I believe great minds w...

Hi Thanks for your response As per my requirement my routine will never give negative output. I had tried with 2 triggers as specified . I had enabled "Log warnings after activities that finish with status other than OK" and i am getting same warning message. I had unchecked "Log warn...

Hi
I am able to understand the method. as i am bit confused . Can you please let me know the step by step to implement this.

Thanks in advance

Regards
RK

Hi Thanks for your response. I had tried to implement your suggestions but again landed with warnings. I had explained in 2 scenario's Scenario 1 : The Sequence job is getting aborted Link Name Expression Type Expression ---------- -------------------------------- ----------- First Link ReturnValue ...

Hi I had tried in the forum in finding solution for my problem but i am still not able to resolve it. I tried this http://www.dsxchange.com/viewtopic.php?t=99466&highlight=did+not+finish+OK soultion as well as I tried this http://www.dsxchange.com/viewtopic.php?t=124647&start=0&sid=e927b...