DSXchange

Depending on the customer, it might be as easy as hard-coding zero!

What a great site this is! (since we're in the Testimonials forum)

Put echo in the command field and #TextToEcho# in the parameter field.

... and if you type in dsjob -run by itself you will get the options for that subcommand. And so on.

Hash table aggregation method is recommended for 1000 or fewer distinct grouping values per MB. Looks like you've exceeded this limit.

Check your settings (in Adminstrator) for the four environment variables for the compiler and linker (APT_COMPILER, APT_COMPILER_OPTIONS, APT_LINKER and APT_LINKER_OPTIONS from memory).

More is better. Set up 24 scratch disks, each large. Give each of the eight nodes access to all 24. Use a round robin allocation scheme.

It may not be permissions, it may be other problems such as disk full in your project directory or a corrupted log table. However, you do need to resolve why the log could not be written to.

The message suggests that there's an unexpected newline in your SQL. All SQL statements have to be delivered to DataStage/UniVerse as single strings with no embedded newlines.

... unless your hard coded value does not match the default date picture for Oracle.

Job parameters are not resolved in the Command field. They are, however, resolved in the command parameters (arguments) field.

... but you still won't be able to use ":" in a Windows pathname except immediately following the drive letter. In short, you can not break the rules of the operating system.

I have a Transform called FinalDelimitedString as follows Field(%Arg1%,%delimiter%,Count(%Arg1%,%delimiter%)+1,1) which is pretty much what Craig posted. This does not solve the znf__fre__fr_q problem if you need fr_q as the result, since Field only uses single character delimiters. ...

Hard code it. Use user-defined SQL to incorporate a TO_DATE function in the INSERT statement.

Put a LOT more scratch disk space into the configuration file.

Nobody knows what you mean by the term SID - to us it's just another TLA.