DSXchange

hi,

we had to reinstall Datastage on a server, and i'd like to know if i could attch the "old" projects to the new instance (this is the same version as the old instance)

tks

Hi,

You can overwrite your NLS settings in a import or export stage.
check the NLS box of your stage.


To change the charset, the strings must have Nchar,Nvarchar or char[unicode] types! Otherwise, data will be trated as bytes, and not translated!

There are actually two operators :

the funnel and the sort Merge (as you run the funnel in sequential mode).

Thaty is the reason of the "bug"

1- Yes, hash and partition is a good practice. modulus is also useful if the key is an entire.

2- Try the 2 solutions. If your database is powerful and your indexes well set , you can make your SQL query.

Well, the upsert is useful.but you have only one insert.

Other solution : load your rows in a staging table in DB2, with a code defining the query (ex: 1 for the update, 2 for insert 1).

Then launch a SQL script to make your different queries

what is the warning message in your log?

It is not useless, it was a useful chat!

See you!

Hi everybody, My team is developping generic jobs with RCP. A fist version is 7.0. Migration to 7.5 is coming soon. We have a problem with lookups in 7.5. Since there is a graphical tool to define the keys, parameters are not allowed, unlike in 7.0. Do you have a solution, or do i have to define the...

In France, IBM/Ascential consultants attack in their best practice,

but experience shows that it is not justified.

This function is poor, not the transformer! Well used, it is a very powerful stage!

i used it with 7.0, and it is poor!

my solution : difference between the daysfom the constant and the 2 columns

this founction exist in a modify stage. In the modify, the 2nd parameter must be a constant, not in the transformer.

In the transformer, if the 2nd paramter is not a constant, performance is very poor!

To my mind, this is not a network problem, but a ressource problem. Did you control that there is enough space in your swap?

hi,

There is no backward compatibility.

if you want to migrate, avoid 7.0

production manager can import in protected projects.

Operator can only see released jobs, useless if you are using protected projects.