DSXchange

What Mike said.

There's no great issue using two Transformers. Chances are that they'll be combined into the one process anyway (operator combination).

Array size = 1.
Record count = 1.
Buffer size - which buffers are you asking about, virtual data set buffers or transport buffers or some other? Any buffer needs to be large enough to hold at least one record.

Datastage default CurrentDate() format is %yyyy-%mm-%dd This is not necessarily true. For starters, the return value is of type Date, which is a binary number. Secondly, the default format when converting to a string depends on the locale, and the default set using the Project Properties in the Adm...

The easiest is to use the Director client. From the Project menu choose Print then, in the common print dialog, check the Print to File check box. This writes to a file on your client machine. To write to a file on your engine machine, prefer a routine that uses the DataStage API DSGetLog,.. functio...

Supplied rule sets are static (though may be improved in higher versions of QualityStage). They can be modified only through the override mechanism. Alternately you can take a copy of the supplied rule set and modify the copy to your heart's content.

You could try:

• putting the CLOB column last in the SELECT clause
  
  casting the CLOB column as LONG VARCHAR2
  
  consulting with your Oracle DBA

Total memory seems to be being exhausted. Monitor real and virtual memory using Windows Performance Monitor while this is running. Ultimately you may need to schedule fewer jobs to run at the same time, so that total demand for memory is reduced. Or increase physical memory or pagefile size or both.

SOAP header (as you seem to have worked out) is empty

Draw them on a number line (remember those from school?). All will become clear. floor moves left, ceil moves right.

Though I cannot envisage any scenario in which "+19982.2876 will be ceiled to +19982.289".

In the controlling sequence read the WORDS file and construct the SQL statement. Pass this to the job as a job parameter.

You could use an awk script or a DataStage server routine to construct the SQL - whichever you are comfortable with.

... except that the syntax given by naveenkumar.ssn (even in the last one) will not create the required result.

That's not the same as creating separate log files at run time.

I agree about the server OS, and the list needs expansion too. Perhaps:

• Windows Server
  
  Linux
  
  zLinux
  
  UNIX (AIX, HP-UX, Solaris)
  
  Hadoop

Most of your ELSE expressions won't be evaluated because they include the same IF test as was processed in the THEN clause.

All you need is:

No.