DSXchange

OK, now output FMT(DSLink8.PROCESS_DT, "L####/##/##") to establish whether the problem is in Fmt() or Iconv().

How many tables and files? How many rows in each? How large are the rows in each?

You are also missing a command. The bin folder contains the executables; it isn't one itself.

Hmm, and you're having problems with Oracle timestamps in the data browser as well. Could these be related, do you think? Have "they" changed anything (such as the default date picture) in Oracle?

Let me clarify. You simply changed the data type - you did not use any explicit data type conversion function. Is this correct?

Do you remember whether this behaviour occurred before you upgraded to version 8.0?

You can add a rejects output link to your Sequential File stage. This will capture any rows from the file that do not match the metadata specified in the record schema for the main output link. If they are "improper" in the business rules sense, you need to detect these with your job design, most li...

OK, then check whether it's there in the uvodbc.config file in your project, which is where the DSN list is really populated from.

olgc wrote:Hi there,

How is the job log stored in Datastage server? Is it stored in a hash file?

Thanks,

No. It's stored in a hashed file.

The suffix ".exe" suggests that it is a Windows executable and therefore will not be executable in a UNIX environment.

What is the value coming in from DSLink8.PROCESS_DT ?

Capture this using stage tracing or the Debugger or an extra output from the Transformer stage to a text file.

Control Panel, System applet, Environment command button PATH (maybe Path) is a System variable. Select it and edit it to include the pathname of the DataStage Engine bin directory (and of the PXEngine bin directory if you have Enterprise edition). Tip: copy the value of PATH out of the Variable val...

Investigate lookup_string_from_int16() function in Modify stage to generate the month names in Croatian. Or build a Lookup File Set that you can use with a Lookup stage to return the month name and/or abbreviation corresponding to each month number. Use Entire partitioning; it's easiest with only 12...

Use a routine activity executing KeyMgtGetNextValue.
Initialize the record in SDKSequences from the environment variable.