DSXchange

Parallel Job Developer's Guide - search in it for "out of band null".

Convert()

Only changing the default date picture in Oracle and matching that. There's nothing more you can do in DataStage.

Resist stupid requirements!

Read the manual. Null is represented internally as a byte with only its most singificant bit set.

Compile it with your C++ compiler. There should be a Compile control in the Visual Studio suite.

My guess is that what is meant here is user-defined SQL with your own TO_DATE function and appropriate format picture.

The Num() function is still available, so you will get part way there by applying that to field #2. You could also apply a Len() function, check for existence of any character that is not 0-9 or decimal placeholder (or sign) by converting them to "" and checking for anything remaining.

Provided nothing has been hard coded as an IP address you should be OK. Make sure that any entries from /etc/hosts are created on the new machine.

I think that's IPC (inter-process communication, also called row buffering) rather than RPC.

Whoever wrote what you read got it wrong.

There is no such thing as runtime column propagation in server jobs.

What's the purpose of stage variable s1 ?

As far as I can tell, it does not do anything.

Since you are on version 7, you probably will get away with changing the READONLY attribute in the Repository table DS_JOBS. You may need to change a record in DS_JOBOBJECTS as well. But before you do, ask yourself why these jobs were made read-only, and is it really wise to change them? Might it be...

Within your project directory on the server there should be a directory called ParameterSets. Within that directory there is a subdirectory of the same name as each Parameter Set. Within the subdirectory is where the values files live. You can read these as regular operating system text files (notin...

What kind of stage variables ... ? Provided data are partitioned on ColumnA and sorted on ColumnA using a stable sort, then you can use standard stage variables to assemble your required output string. Follow the Transformer stage with a Remove Duplicates that allows only the last row of each group...

You should have been able to see all the pertinent part. Because there was so little else, I've removed the Premium status.

The list of functions is Appendix B in Parallel Job Developer's Guide

Index() finds an occurrence of a substring in a string and Len() gives the number of characters in a string. Those will get you started.