DSXchange

Hi Breidy,

viewtopic.php?t=94943&highlight=change+capture

Look for the last post

HTH,

Mat

Thanks for your answers. I found the reason why it didn't work. The lookup will put a null in your nullabe output field if the corresponding input field is also nullable. Otherwise, the field gets a default value which does not respond to the tests: IsNull() or = ""

Thanks,

Mat

Hi Senthil, You would need a LOT of RAM to use a lookup stage there! I'd recommend a join stage since the amount of memory used will be much lower. Anybody else working on the same server will appreciate you for this. Also, sort the DB2 ouput by your join keys, this will help. HTH, Mat PS: Think abo...

Hi Rajanalla,

Sorry but I have never tried that. You went further than me. Perhaps you could recontact IBM.

Regards,

Mat

Hi, If you try to configure the way the manual tells you to, you will need to install DataStage on the remote server too. This why it does a rsh connection, it is treating both your servers as part of a cluster and it wants to start DataStage on the remote server. There is a way to trick DataStage i...

Hi All, I have a problem with the values returned by a lookup. My field is defined as Char (1) and some of the values are not matched. I have set the lookup to continue in this case. My understanding is that the value returned by the lookup will be set to null when no match was made. However, the lo...

Thank you for your answers.

I have about 20 jobs in my VC project and I waited about 5 minutes before killing the process.

I am using version 7.5

Thanks,

Mat

Hi All, I have a problem with Version Control. Every time I select components the progress bar appears but the client freezes there and needs to be stopped from the task manager. I select components using right-click in left pane-->select-->User (Or Batch, Release, etc.) Has anybody experienced simi...

DB2 UDB stage usefulness relies on its ability to execute DB2 treatment in parallel. Hence, the speed of execution will be greatly reduced if you switch to a API stage on a multiprocessor server. There are ways to connect to another server with the DB2 UDB: The first and IBM recommended method is to...

Hi,

Try this one: timestamp_from_string[timestamp_format](string)

Converts the string to a timestamp
representation
using the specified timestamp_format.

By default, the string format
is %yyyy-%mm-%dd
hh:nn:ss.

HTH

Mat

Under UNIX, you should put a preceding $ char to call a variable.
HTH

Mat

Hi Vbeeram,

You should have a file named .dshome at the root of your machine. This file contains one line only which is the path to your DSEngine directory.

ie:
as0006s@sodium01(/) $ cat .dshome
/usr/local/datastage/Ascential/DataStage/DSEngine

HTH

Mat

Thank you for your reply,

I'm not sure I follow you...How do you the use of the column import? I'd like to see an example if you can.

Thanks

Mat

Hi All, I am trying to use the XML stages to read and transform XML data. I was able to read my file in Server (Thanks Kim for your ETLstats examples) but I haven't found a way to do this in PX. The main problem seems to be that I cannot read an entire file as one single field in PX. Hence, The XML ...

One solution is to modify your sequence to add one step to get the value and one to assign it to a job. What I have is a sequence like the following: 1. Job to get DB Key and write to a file --> 2. Routine to get the value from UNIX (cat) --> 3. Job for your surrogate key job (Surrogate key stage us...