DSXchange

DataStage is interpreting "" ("we didn't mention any precision") as 0.

You couldn't do it in DDL.
So why do you think it's legal within DataStage?

Welcome aboard! :D In the job that populates the hashed file, specify all three columns as key, and check the Create check box. (Optionally click on the Options... button to set sizing options, and "delete before create" choice.) Save the hashed file column definitions into the repository, using the...

In the uvconfig file, NLSMODE must be set to 1 for NLS to be enabled. Simply installing NLS is not enough; all that does is to emplace the database of NLS character maps and locale definitions. Once you've edited uvconfig you need to shut down DataStage, execute uvregen from the $DSHOME directory, a...

You may need to yell.
You may need to rant.

Even better, you may need to educate them.

And if they ever hard-code a password again...

A job sequencer is nothing more than a graphical user interface to writing job control code - you can view the job control code in the job properties window, and note there that it does use DSSetParam to set parameter values. However, in a job sequence, the code is read-only, so that alignment betwe...

DataStage scheduling on UNIX also uses at, rather than cron, if at is available. You could, in this case, schedule two runs of the job. One in reset mode (whether it needs it or not) five minutes or so before scheduled exection time of the normal run. This still offers no protection against future f...

If a parameter marker is to be used in the WHERE clause, it must be marked as a Key column in the DataStage column definitions. It is irrelevant whether it is actually a key in the database; the concept here (on a reference input link) is that of a "search key". You are permitted to lie about "keys"...

Check out the "masked character" conversions in on-line help or in the DataStage BASIC manual. "MCA" retain only alphabetic characters "MC/A" retain only non-alphabetic characters "MCDX" convert decimal to hexadecimal "MCL" convert upper case to lower case { = Downcase() } "MCM" extract multi-byte c...

Welcome aboard! :D If you look at the details in the error message, you will get a lot of information. You are using an ODBC stage to connect to Microsoft SQL Server. The database has refused to service your SQL request, returning the reported SQLState, DBMSCode and error text. The error message is ...

Do ensure that $ORACLE_HOME/lib32 appears before $ORACLE_HOME/lib in the library search path environment variable set in $DSHOME/dsenv.

DataStage is a 32-bit application.

The terminal type is - should be - picked up from the TERM environment variable. Execute the GET.TERM.TYPE command to find out what terminal type the engine believes you are using. Also check your telnet client to determine what terminal type it claims to be emulatiing. Use the SET.TERM.TYPE command...

This problem can occur if defunct processes continue to hold sockets open (even though they're in a state of waiting for timeout). In some cases, the held sockets prevent the RPC service from starting. This is why re-booting made the problem go away - removing the operating system also removes any s...

In a server routine I don't know how to return the rowcount as ans . Be careful with casing. The name of the return variable is Ans , it is not ans . Apart from assigning a value to Ans you do not need to do anything more; look at the bottom of the Routine editing page, and you will see that DataSt...

What happens if you remove "/Interfaces" from XPath?

DataStage has for some while shipped with ODBC drivers from Data Direct (formerly Merant). This suite includes a driver for Microsoft SQL Server. It's called VMmsss19.so and is to be found in $DSHOME/../branded_odbc/lib. The "msss" in the name stands for "MicroSoft Sql Server". (It has a .sl suffix ...