DSXchange

SQL0501N The cursor specified in a FETCH or CLOSE statement is not open. Explanation: The program attempted to either: (1) FETCH using a cursor, or (2) CLOSE a cursor at a time when the specified cursor was not open. The statement cannot be processed. User Response: Check for a previous message (SQ...

You install the MCM when you install the 7.5 clients, just make sure you choose the 'customise' option and tick the MCM box. If you try to install the new MCM on it's own it takes a bit of messing about.

I think the parallel DB2 stage has a delete rows option. The dataflow provided to the stage is used to determine which rows to delete. I think you would need to make this a seperate job though and not part of a before routine.

If you havent specified the location of the SAS client home directory during the DataStage install the required libraries won't be linked. Try running the DataStage/PXEngine/install/install.liborchsasop script to link the libraries.

From the readme (release notes)" Red Hat Linux Advanced Server 2.1/3.0 "

I also think it will run on some other versions but I can't remember which. I think the issue here is to do with which compiler versions are supported.

I had understood (although I could be wrong) that when the job goes wrong that DataStage re-directs these logs into it's own file system rather than the oracle install file system.

For problems with sqlldr, I expect the job cannot see $ORACLE_HOME/bin in the PATH variable. (Look in the Env in the Director Log)

(Also try looking for the ora* logs in /DataStage/Scratch)

Sounds like permissions. Are you using the same user account as before? also check the umask settings in the ds.rc script.

You can't just ftp datasets between machines. Use the dataset management tool to move them (manager -> tools etc ...)

This sounds like it is connected with the custom operator. Perhaps there is a row of data that is not formed correctly and the operator does not know how to handle it?

How Many 'nodes' are there in the DB2 database?
(check the db2nodes.cfg file)

RStone wrote: who has authority to realease lock?

I would guess the DB2 user you are using plus other users that have been given extra priviliges, you'll have to talk to you DB2 DBA to know who else can perform this function.

I think you need to check the documents again as Windows XP only supports DataStage clients.

You see a "?" normally due to a mapping/locale mismatch. I suggest you read the DataStage NLS guide and check the maps and locales that you are using against those you expect in your datafile.

Install DataStage with NLS enabled.

You can then set the MAP that you read your data (i.e. UTF)
and you can set the MAP to use to write the data. (i.e. EBCDIC)

The sequential file stage also has some special options for reading EBCDIC data.