DSXchange

There's no equivalent character, a newline is a newline. You can use the Char(10) function to generate the same character.

Tip: calculate this function once, when initializing a stage variable; there is no need to re-calculate it for every row processed.

No, since clearly you don't have the requisite privileges.

Moderator: please move to Server forum

You could mount the Windows folder on the UNIX system using something like Samba, you could use FTP to get the file from the Windows machine to the Windows machine.

What ever happened to Bill Gates' famous dictum "you will never need more than 640 Kbytes of real memory"?

Do you want to invoke this as a Routine activity, an after-job routine, or something else? The shell script offered by Sainath will work because you have MKS Toolkit installed, and could be invoked through an Execute Command activity - but needs some extra work to read the file of pathnames. In Data...

What is the data type of the stage variable? Remember that parallel jobs are strongly typed. One result of this is that any constraint expression must evaluate to a true/false value; the old server way of thinking (0 is false, anything else is true) does not apply here.

If column definitions are not found in RT_CONFIGnnn this usually means that the compilation was not entirely successful. Try re-compiling.

Check permissions. Check library search path.
Restart.

(There is no dsenv for Windows.)

You need to restore the backed up hashed file that is the log for that job, but not over the top of the hashed file for the existing job. For example, you could rename the hashed file during the restore process. After that, you can create a VOC pointer to the restored hashed file, with field #3 refe...

Did you bother to Search? When you set up an ODBC data source to refer to an Excel workbook, that workbook is the "database", and each worksheet in it is a "table", indeed a "system table". Tables are independent, may have different metadata, and must therefore be treat...

Welcome aboard. Your lookup is retrieving more than one row, but the OCI stage does not support returning more than one row from a reference lookup. The only stage types that do are ODBC and UniVerse. Of these, only ODBC can be used to connect to Oracle tables. But for that to work you still must se...

Write an after-job subroutine that:

• determines the job number of DSJ.ME
  
  opens that job's log (hashed) file
  
  finds the current "job started" event using DSGetNewestLogId()
  
  reads and updates that log event (replacing password parameter values with asterisks) and writes it back to the log

The message is telling us that there is something about that particular timestamp that precludes its being converted to DataStage internal format. Are there any differences in this particular timestamp compared to the others - for example order of components, separator characters, fractional seconds?

What is the data type of the input field and of the output field? Search DSXchange for discussion of how/why floating point numbers can not be stored to full accuracy in computers.

You get patches through your official support provider. It is one of the things for which you pay them maintenance.