DSXchange

You said you were running 8.01. Probably it's 8.0.1.
This is not the same as 8.1.

Trim(NULL) is probably not supported. Apply the IsNull() function without the Trim() function. If the string can be trimmed, it is not null.

ErrCode = SQLConnect(hDBC, DataSource, UserID, Pwd) If ErrCode <> SQL.SUCCESS Then Loop ErrCode = SQLError(hEnv,hDBC,hStmt,SQLState,DBMScode,LastErr) While ErrCode <> SQL.NO.DATA.FOUND and ErrCode <> SQL.ERROR Msg = "SQL state " : SQLState : ", DBMS code = " : DBMScode : @VM : L...

You don't add the JVM to your classpath, you add the lib directory that contains the classes. Usually this is done in the dsenv script so that every DataStage process automatically gets the settings.

Every object in the job design is more work. Each link is an object.

I don't think it's fair to say (at least in version 8.4) that Framework Manager creates any metadata. Metadata are stored in the unified metadata repository of Information Server, which any of the Cognos tools can access via metadata delivery and analysis services.

That's not how you call SQLError(). The third argument must be a valid statement handle.

Number of connections yes, number of stage variables no.

How many do you want to have to maintain?

Use an NLS map that matches the way that the data are encoded.

Master Data Management is a separate group of products from DataStage, so you have not posted in the correct forum.

The answer is almost certainly that the Job activity in the sequence specifies "reset if required, then run".

I don't have access to premium content. Please give details without premium content. Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are defrayed, and I do not intend to establish a precedent for anything that would prejudice that, and the continuing existenc...

It doesn't matter what you do when loading the hashed files. This is the write cache. When you're using the hashed file stage to source rows for a reference link, you can enable the read cache, which is independent of the write cache.

You need to determine where the error occurred, and that involves testing each and every one of your ErrCode variables. Particularly the one for SQLConnect(). For example you may have to use SQLSetConnectOptions() to set up the operating system login ID and password. Any time a BCI function returns ...

Read it with an XML Input stage (perhaps fed from a Folder stage). Beware that one XML file may contain repetition elements, which means that the data are not normalized. If your target requires normalized data then you may require multiple CSV files (Sequential File stage) or tables (database stage...

Your requirement is unclear.

Do you mean "pass two file names to the after-job subroutine" or do you mean something else?

Clear specifications are vital in producing good ETL, and just as vital in getting good answers to questions.