DSXchange

ArndW wrote:If you get incorrect values with multiple nodes then you have partitioned incorrectly. You need to partition on DEPTNO.

... using a key-based partitioning algorithm, for example Modulus or Hash.

I suspect one is using the local project repository and the other is using the unified, or common, metadata repository. How are ORLogging and RTLogging set in the project's DSParams file?

Try using a server job Sequential File stage - in a server job or in a server shared container loaded into a parallel job - these are much better at handling delimiters within quoted fields.

Welcome aboard. My initial thought is that you don't need to do anything - the source is already in the correct format for Oracle.

If you are going to use Oconv() and Iconv() you need first to segregate the date and time portions, perhaps using Field() functions or substrings.

I suspect you had an unsigned TinyInt, then, and have changed it to a (not unsigned) Integer.

Why not get a premium membership? Then you would be able to read the entirety of Arnd's and other premium posters' contributions.

Premium membership is not expensive, at less than 30c (Rs12) per day, and 100% of that revenue goes towards paying the hosting and bandwidth costs of DSXchange.

How/where are you calling this function? That is, where are you setting its arguments' values?

You have to find out how the particular database expresses current date. For example, in Oracle it's SYSDATE (if I recall correctly!). Consult a Sybase SQL manual.

Use the -bloadmap or -bnoquiet option to obtain more information.

Once the patch has been successfully installed, it is safe to delete its .ispkg file. Better would be to move it to secondary or tertiary storage (e.g. a DVD) in case you need to rebuild your system.

You have marked this thread as Resolved. What was the resolution?

The status will be DSJS.RUNFAILED (3).

(Signed) TinyInt has a domain of -128..+127. (Unsigned) TinyInt has a domain of 0..255. Check that your TinyInt is not unsigned. Disable operator combination to learn which stage is throwing the error, and change array size to 1 to learn which row is throwing the error. At that time you may even be ...

The "internal" DataStage data type corresponding to Char(n) is string[n].

You can not pass a function as, or as part of, an argument. Replace all references to Char(254) with the system variable @FM.