DSXchange

Kill the phantom process in UNIX

"Pin%%V21S10P8" is this the link name.

Looks like you are trying to use as column derivation. and Pin%%V21S10P8 may not be the name of the link. check the link and update the derivation with proper name

It is resolved now. Though the bin/uv command was giving "segmentation fault", we managed to run uv - admin -stop and brought down the service.. and restarted it. The segmentation fault no longer appears.... Though the situation is resolved, I would like to know the root cause. Any ideas o...

Hi Gurus We have hit the Internal Error 39202, while attempting to connect to Datastage. After getting rid of all the phantoms and dsapi_slaves, I tried to execute the command $ cd $DSHOME $ bin/uv Segmentation Fault I get the error Segmentation Fault. I checked /var/core and found number of core du...

Hi , I am trying to implement the scd type 2 using this new scd stage in DS ver8. In the scd stage we have one input ,one output ,one refernec link and one Dim Update link. I looked and tried one sample scenrio.My question is : 1. Is we need to have a colum having flage value 'Y' and 'N' to be used ...

Hi, I am trying to read the xml data by using folder stage. I am impleming the ereplace function on CONTENT column from folder stage by using transformer stage(Tfm8). I am getting Fatal error: StgCTSSIIStudyInfoFinal_Xml.Read_Tfm8: ds_intput() - row too big for inter stage rowbuffer The xml file siz...

You get this error when the Job Process was killed.

It might be that some one issued a kill -9 command on your phantom process
or it could be that the process was terminated abruptly due to server errors
or it could be that you have done your node configuration correctly

Thanks Chulett,

If I want to migrate server jobs .Can i just import the jobs in Datastage 8 ? will that work?

because datastage consultant has told that a server jobs are not supported in Datastage 8

I think you are on Unix.

I would use unix scripting to do this for me.

You can write a shell script to check the number of lines in the file (wc -l )
and for every 100 (or what ever may be the number of rows), write to a new file (using head & cut commands for example)

I think you are on Unix.

I would use unix scripting to do this for me.

You can write a shell script to check the number of lines in the file (wc -l )
and for every 100 (or what ever may be the number of rows), write to a new file (using head & cut commands for example)

you can call multiple sql statements in "After" part of the Target

or you can write a stored procedure for the same and use the stored procedure in datastage jobs.

Does it add 1 hour to every source date ?? or are you having problems only with 23:00:00 time value ??

what is the derivation of the error code column in transformation.

I think you have given too little information for us to tell you where the problem lies, or what the solution is

I dont know if this is the right way or not, but this is how we do it

open word document
press space bar, keep track of "Col" in the status bar, press space till Col shows 350 (for field of 350 characters)

Then use the windows' gift ctrl C ctrl V

Create a Job parameter NLS_LANG and set the value as AMERICAN_AMERICA.UTF8