DSXchange

Hi kduke,

Thanks for your suggestion and Link.

Hi All,

I have a requirement, some body have deleted my job from repository, I don't have the same job in version control also. Is it any way to restore the same job like windows ?

where did this job go after deletion ? is it any repository to keep this ?

Regards,
Nagesh.

Hi Chin,

I am not sure about DB2 level changes. As per my knowledge, DBA have to remove the constraint on Database level.

Regards
Nagesh.

Hi Folks, When I was started with Datastage, I am little bit curious about using this toll by learning the things from PDF. Once I became member of this DSxchange, I learnt lot of things through this posts. This site is a "Bible" to data stage. You can find solution for every problem of yo...

Hi All,

Apologises for the above repeated post, I got some problems in my browser, It have submit my post 3 times.

Regards
Nagesh.

Hi All,

Apologises for the above repeated post, I got some problems in my browser, It have submit my post 3 times.

Regards
Nagesh.

Hi, I think, may be here problem is pertaining loading the data from one database to other database with out any stage between them. Just, try out this option, Use a Copy stage between these two stages and try out to load the data. Here Copy Stage work as an optimizer. It will provide buffer to hold...

Hi, I think, may be here problem is pertaining loading the data from one database to other database with out any stage between them. Just, try out this option, Use a Copy stage between these two stages and try out to load the data. Here Copy Stage work as an optimizer. It will provide buffer to hold...

Hi, I think, may be here problem is pertaining loading the data from one database to other database with out any stage between them. Just, try out this option, Use a Copy stage between these two stages and try out to load the data. Here Copy Stage work as an optimizer. It will provide buffer to hold...

I understand. But if you change the target to Char. It can handle decimal values. I am not too sure, but give it a shot. Target is already CHAR and it is Fixed Width file. Hi Kunal, You can acheive this by putting spaces in the Null field value option of the sequential file. Just, double click on t...

Hi Welcome to EE, Yes, some functions which are avialbale in the server is not present in Parallel. Parallel have its own set of fucntions. Go through the Parallel Job developers guide----- Functions at the end. You will get all functions. You can check Orchestrate Reference Manual also for you refe...

Kunal,

If you are performing lookup CHAR to VARCHAR, you will not get exact result. So, first convert u r source from Char to Varchar. We faced lot of issues, while performing lookup CHAR with VARCHAR. Solution is make the both fields to Varchar and perform lookup. I think u will get the result.

Hi Ajmore, As Kumar and samsuf2002 suggested first check the scratch space. One more thing I have identified is you are getting warning on Tsort operator. If your Database and Dataset are sorted before Join stage and If you are sure abot that, then use the environment variable APT_NO_SORT_INSERTION=...

Hi All, I don't know, what Miracle happened with my Datastage. The Convert function is Working for me. It's replaced the Multiple characters into one charcter. I tried by converting the 'ABC' with ' '. I got the result without Trim function and I have used trim to remove spaces from string which are...

Hey Vajranatah,

Try out this function in Transformer stage :

Trim(Convert('ABC',' ', DSLink3.Example)).

Hi All,

This function is working and its converting multiple charcters into one specified character.

Regards
Nagesh.