DSXchange

Most likely the database connectivity values are parameters, and they are not being passed correctly from the sequence.

In the web console, under Administration -> Domain Management -> DataStage Credentials -> [your server] open configuration are you using share registry? if not, perhaps the userid and password combination given on the right-hand side of the screen is incorrect.

How are you looking at the data (hint: don't use "view data"). What is your source file NLS setting, your project default NLS setting and what is your Oracle NLS setting.

If 1 row goes down the link, it will return a "1"; if no rows are transferred you get a "0".

Yes, "dsjob -logdetail MyProject MyJob" would list the detailed log for job 'MyJob' in project 'MyProject'

Stay with longvarchar; DataStage server strings can be as long as you wish (limitation is how much virtual address space your process can allocate, not an actual number-of-bytes one).

StringToDecimal('2008-01-01') does not result in that which you are looking for. Try JulianDayFromDate to get an integer.

The &SAVEDLISTS& file in DataStage or UV is used to save select lists. This feature is not used in DataStage but extensively used in UV applications.

What character datatypes are you using - "unicode" or not?

Oh well, that approach works for some calls that are passed through the UNIX shell, so I though it might be worth a try.

I don't use "force" unless there is some error in processing caused by DataStage removing the copy stage.

Probably "XMETA" - check which name you used during the installation.

In this case it works because the number string is implicitly converted to number format. Will the quoting work if you use "\'" instead of "'"?

Add the environment parameter $APT_DISABLE_COMBINATION and set the value to "true" for your run.

Sequential files cannot be updated like tables. In order to change a sequential file in DataStage you will need to read it and write it to another, making whatever changes you require as the data is passed through.