DSXchange

If you have a routine already, what's the problem?

DataStage does not have log files. Job logs are database tables.

What kind of log file are you wishing to attach?

Being on version 7.0 you will need to write your own routine to invoke sendmail() with attachments. The ability to do this from DataStage was introduced in version 7.5.

You don't have to copy .Type30 - it's empty. But it does need to be there. It signals to DataStage that this directory is a hashed file. Without it DataStage treats it as an ordinary directory, and DATA.30 and OVER.30 as ordinary files, with the results you obtained. Hopefully you have not attempted...

Yes, provided that the hardware is compatible (primarily byte order). For example, copying from a non-Intel chip to an Intel chip would cause difficulties, because every pair of bytes in the hashed file would be in the wrong order. This can be remedied with the format.conv utility (also known as fnu...

Current system date can be obtained using the Date() function.

This is in DataStage internal format, so that Date() + 6 is the (internal) date six days from now.

Convert the internal date into any desired format using Oconv() function.

You are grouping data (in the Aggregator) so the rows can only come out of that group by group.

Probably not, since this is a stage property not a link property. The schema is a link property.

There's only one reason for rejecting when exporting, and that is that the data do not match the metadata. Add a Reject output link from HDR_TARGET to capture the rejected rows, write them to a text file (as a single string) to see what is happening. Actually, all rows can also be rejected if you do...

If the data type of the output is string, then DecimalToString() may or may not be needed. It may be able to occur as an implicit conversion.

In that case, you could get rid of leading and trailing zero characters with a Trim() function.

Inputs (input ports) are numbered from 0. So if you have a stage with three inputs, they are #0, #1 and #2. Outputs are also numbered from 0. The alert is generated whenever the downstream operator can not use the same partitioning as the upstream operator. This may be, for example, because the down...

You don't use dfloat between the parentheses; you use the name of an input column. And it must be of type string (look at the name of the function again).

Is your job monitor (a separate Java application) actually running?

actually there is another input to funnel stage which comes from an 'external command' stage :D Then your question is not the one originally posed. But my answer is unaffected. And there's another possible cause of rows being out of order - what mode of operation is being used in the Funnel stage?

ppavani_km wrote:First you need to change the Excel file as .CSV file.

This is not true if you have an ODBC driver for Excel.

When's the interview?

IBM has lots of information it wants to share with you about accessing unstructured data.