DSXchange

The version we are using is 8.5 on unix. thanks

hehe , sorry guys I didn't see you already replied ! Here is an example : Input Col --> Output Col Input Col --> Stage Variable --> Output Col2 (no transformation in stage variable)) Input Col Output Col Output Col2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL NU...

I have 100 columns and 200 stage variables , If I just keep half of them then the problem disapear. Is there any limitation on the number of stage variables we can use in one job ?

Hello guys, In one of our jobs , I have different output for the same column. I am using a transformer stage for other reasons. If I propagate the column directly to the output I get the right result. But If I propagate the input to a stage variable (witout any operation) and then pass the stage var...

Thanks all for your responses,
I am playing with the same subset of datas so the update is working fine when doing the update then insert.

My issue is we want to use insert then update and as chulett said I would expect if insert fail then do an update but with no warnings.

Hello, I'm trying to understand why when inserting duplicates using insert then update I have warnings : DB2_Connector,0: [Input link 3] SQLParamData reported: SQLSTATE = 23505: Native Error Code = -803: Msg = [IBM][CLI Driver][DB2/AIX64] SQL0803N One or more values in the INSERT statement, UPDATE s...

Hello Folks,

Wondering why I get error message when oracle table is empty :
Converting a nullable source to a non-nullable result

When table is filled we don't have these error message.

Any hint on this behaviour ?

Hello Folks,

I was wondering why in some projects I see more grid parameters than others projects. Like APT_GRID_HOME.

I'm trying to use the grid dynamicaly but when I check the dsparam It looks that I'm missing some parameters.

Any clue will be kind.

Cheers !

Thanks guys .

Hello all,

I've heard that there is an existing framework for IBM Maximo.

Does anyone know where I could find it ?

Thanks

Hello All,

Just want check something about the dataset.
First job would create a dataset.
And then several jobs will read this dataset.
Is it possible ?
Could we use the same dataset in several jobs at the same time ?

Thanks

Hello All, I've already been through all the previous post but still can not understand something. I'm trying to use the scd stage but don't understand on what the input is built. input link : ??? The reference link : is the dimension table First output : update dimension table Second output : fact ...

Hello Folks,

I need some tips on how to remove datastage phantom process from the unix box.

Cause when I use ps -ef I can see many phantom process from last week .

Moreover if you know how to stop a job using something than the director it would be helpful.

Thanks !

Hi,

I get the solution, problem is ODBC stage, using now MSOLEDB fixed the issue.
Everything is fine now, thanks for your contributions.

I can just agree to this.
I'm going to read the readme of 8.1 if it's possible to get it from IBM.