DSXchange

You might try a command such as source to execute the script. Or request that execute permission be granted. I take it that /opt/Ascential/Data/AIS_MIG_MAINT/MIGRATION/TEST is the script for which you lack execute permission?

Search?

Use an appropriate conversion function (if no implicit conversion will occur) and also add a specification to the Modify stage to suppress generation of the warning.

1. That's nice.
2. Stored procedure stage for stand-alone, ODBC Enterprise stage for per-row.

Search? Curiously, you are not the first to have reported this.

This is usually due to a configuration error, such as not having the Orchestrate install directory properly mounted on all nodes, rsh permissions not correctly set (via /etc/hosts.equiv or .rhosts), or running from a directory that is not mounted on all nodes. Look for error messages in the precedin...

Search?

Floating point is not fully supported, because it can't be. Study the IEEE standards on storage of floating point numbers in computers to find out why.

Tough. If it's fixed-width format, it's fixed-width format. Start entering your spaces. Without changing from fixed-width format there is no other solution. Every value, whether it's the representation of NULL or not, must have the correct number of characters for its field. That's what fixed-width ...

Server job (as marked) or parallel job (as posted)?

Column names in DS_AUDIT don't have spaces in them. The error message showed that DataStage/SQL was happy with everything up to "LAST". But not with "LAST DELETED DATE". The correct name for the column, from memory, is PREVDTD (but you should check this with LIST.DICT DS_AUDIT). Also, since these ar...

How is this connection established? Is it a client directly on the offshore machine, or using Citrix or some other tunnelling protocol?

Whenever the result of a BCI function is other than SQL.SUCCESS or SQL.NO.DATA.FOUND you must use SQLError() to remove the associated information (including code and error text) from the handle. If you do this you will discover the root cause of the problem.

Disable operator combination. You may then find that the error is not being generated where you think it is.

Scale is the second piece of a Decimal number, which is specified as Decimal(precision,scale). You will find Scale in the Columns grid of the table definition. If this needs to be 0, put 0 in there explicitly, because the error message is complaining that there's no value there.