DSXchange

What is the data type of WFAC_PASSWORD? Is it encrypted? Does the encrypted version contain binary characers (in particular 0x0a or 0x0d)?

Does your version of Windows even deliver microseconds when a call is made to the system clock?

Perform a lookup against (a copy of) the parent table before trying to insert or update records in the child table. If the lookup succeeds, then you won't violate the foreign key constraint. If the lookup fails, direct that input row to your reject-handling link.

The pathname that you give must be the pathname of an existing directory (folder). You must have permission to write into this directory. In particular, you do not give the pathname of the hashed file on the Stage tab, only that of the parent directory in which the hashed file is to be created. The ...

If you have NLS enabled for DataStage, do the following in the Transformer stage. Use ExecUV as a before-stage subroutine to execute the command SET.LOCALE NUMERIC FR-FRENCH Use ExecUV as an after-stage subroutine to execute the command RESTORE.LOCALE Then DataStage will automatically recognize the ...

A function is not the same things as a stored procedure. The only way you have to use a Stored Procedure stage to invoke a function is to create a stored procedure which in turn calls the function. Unnecessary overhead. Your time would be better spent diagnosing why the function does not seem to wor...

Can you please edit your original post on this thread; enclose it in Code tags to preserve the indenting, disable smilies then click Submit? Then we can copy/paste the FD and make some tests.

What happens if the job needs 35 minutes to run?

You need to insert a check to determine whether the job is already running.

Then please mark as resolved.

There is no such thing as a hashfile. A hashed file is a database table in its own right. A Hashed File stage can connect to a hashed file. It can not connect to anything else. You connect an Oracle OCI stage or an ODBC stage to Oracle. If you need to populate a hashed file from Oracle, create a Dat...

Sounds like you successfully replaced all the record terminators with spaces. Return to the original file.
What is the value of the record terminator property in the Sequential File stage? If it is UNIX style, try setting the final delimiter property to \r

Go to the Inputs tab, to the Partitioning tab thereon. Have you specified a sort key there? For BOTH inputs? (Make sure, too, that you have specified identical key-based partitioning for both inputs.)

Start by setting APT_DISABLE_COMBINATION to True so you can determine exactly in which stage the problem is occurring, though I'd hazard the guess that it's in the stage that's writing to SQL Server. The mnemonic suggests that you are trying to load a Char(N) column with fewer than N characters. The...

The messages you've posted suggest that the Oracle client software is not installed or not properly configured on one or more of the DataStage processing nodes.