DSXchange

you need a DB2 'client' installed on the DataStage server That's what I guess too. But there are several DB2 client : - DB2 Connect Personnal Edition - DB2 Connect Enterprise Edition - DB2 Connect Application Server Edition ... I don't know which to choose. DB2 Connect documentation explains that y...

Hi On my Datastage server, I can find the file dsdb2.so into 2 folders : - InformationServer/Server/StagingArea/Installed/DSDB2/Server/linux - InformationServer/Server/DSComponents/bin I imagine that theses files have been installed with the DataStage installation. But I can't find the file libdb2.s...

Yes, in a perfect world, I would have a DB2 DBA but ... I don't.
I thought I could find here some people who have succeed in connecting DB2/400 from DataStage.
DataStage server is on Linux. I don't know if it is important.

Regards

Hi I have a DB2 database on iSeries. I want to read datas to load them in an Oracle database. I don't know how to connect to DB2/400. This morning, I tried to use DB2 UDB API stage but it didn't work. I got the message "ds_loadlibrary: error in dlopen of dsdb2.so - libdb2.so.1: cannot open shar...

Where can I set this constraint ?

I find it. Sorry, I was not awake.

Ok for the solution with /dev/null.
I'd like to understand the solution which consist in setting the constraint to @FALSE as proposed by DS_SUPPORT

Where can I set this constraint ?

I need to store a string between 100 and 200 characters.

Hi

I want to set the job status with a string.
I can't find the max size allowed for the string.
Any idea ?

DS_SUPPORT wrote:but you can set the constraint to @FALSE

I don't understand.
What does it means ? How can I do that ?

Thanks. I did a search as you adviced. I found 125 answers with the keyword DSSetUserStatus. It's a bit long to read but it's effective. Here is a summary of the solutions. Step 1 : I create a routine like that : FUNCTION SetUserStatus(Arg1) Call DSSetUserStatus(Arg1) Ans = Arg1 Step 2 : I create a ...

Hello I'm using a sequencer job containing 3 server jobs (SJ1, SJ2 and SJ3). SJ1 is linked to SJ2 and SJ3. I have a parameter table (Oracle Database). One parameter indicates the path to take in the sequencer. If parameter = 2 then SJ2 must run and SJ3 is ignored. If parameter = 3 then SJ3 must run ...