DSXchange

Then maybe the command that sets up your shared library search list in dsenv is incorrect. You have to do some detective work. Use the find command. Look for the named object (libvmdsapi.so), not for any "dll".

I find that, not having access to your environment, I am unable to answer your question cogently.

Is it even valid to call DSD.Init after DSR.SUB.JOB.RELEASE ?

Your shared library search list (LD_LIBRARY_PATH or similar) is inadequate. This is probably because the user invoking dsjob has not executed the dsenv script in the DataStage engine directory.

While you can, you don't need to. The first time you use any of the key management routines the SDKSequences hashed file will be created. Or you could even create it manually. I suggest that you probably don't want to reset the sequences to their values in the other project.

You've made it a DB2 question - surely you should be asking it in a DB2 forum somewhere. There is a perfectly good AddMonths routine available here but, no, you want to do it in SQL. Fine, go for it: it's no longer a DataStage question.

Whe you say your "old server" do you mean a version 8 server or an earlier version? As you might be aware, the underlying security mechanism has changed for version 8 - you need to set up IIS, or "suite", users then allocate credentials within Information Server. DataStage role-based security is bui...

If you mean migrating the changes wrought in one project to another project, then the answer is no. The vendor has never given any official reason for this though, off the record, the view was expressed that one would expect the environment variables to be different in different projects and therefo...

Our answer is unchanged. Each DataStage job is a separate instance of an Oracle client; there is no common session.

Install the SAP PACK in your new project. To do this use the Package Installer on the DataStage server machine.

Sorry about that, Chief!!

Read the part of the DataStage manual where it informs you that binary data type is not supported.

Welcome aboard. It's not so much the syntax as the fact that you must be attached to the DataStage engine directory to execute this command. cd $DSHOME pwd bin/uv -admin -stop bin/uvregen bin/uv -admin -start If you do not have the DSHOME environment variable set, prefer cd `cat /.dshome` for the fi...

Just to make life complicated, what the Merge stage does in server jobs is to join two flat files!

The uv command is in bin, as are all the other executables. In your case, I guess this is /ardent/bin/uv. It doesn't really matter where in dsenv you set your Oracle environment variables, though after any DataStage-specific ones seems to be somewhat of a convention. Also make sure that PATH and LD_...