DSXchange

You can't use sh as an after-job subroutine. Use ExecSH instead. For the job name, try a reference to the DataStage macro #DSJobName#

Download ETLstats from Kim Duke's web site for free. All the work's already been done for you.

Older versions support XP for client tier. I leave it to you to check the details.

I've been working with DataStage since 1995 and I'm still learning things about it.

main() always indicates a stand-alone (rather than callable) executable module. Use the name of your routine as the function name.

Make sure that all of the component names are correct. Database, schema, table.
Which tool are you using to effect the imports? Are you selecting the names from drop-down lists/twisties?

New in version 9.1 is a stage specifically for this task. Upgrade.

Otherwise you will need to track down a third party ODBC driver for Microsoft Excel that runs on UNIX platforms.

ODBC data sources are defined in $DSHOME/.odbc.ini and specified in $DSHOME/uvodbc.config.

Gotta be. Research it and let us know.

Hmm, I wonder if that was one of the issues with our upgrade from TD 13.x to 14.0...?

A DataStage parallel routine can not be named "main".

Line 2 is badly-formed. It has an odd number of quote characters. Demand well-formed data from your provider.

You're on UNIX yet you have DOS-style line terminators. All values in the final column are likely to have an unwanted \r at their end. Change the format to set Record Delimiter String to "DOS style".

Not so good with idioms. English Russian English +--------+ +--------+ -------------> |Language| ----------> |Language| ----> +--------+ +--------+ out of sight out of mind invisible idiot 원본 메시지는 4 월 1 일 게시 했습니다.

Why are you "seeking to implement this as a SINGLE lookup"?

To me it does not make sense to do so; the sense of the logic is not present in such a design.

Therefore consider two Lookup stages or, perhaps, a single Lookup stage with two separate reference inputs.

Final Delimiter is not the same as Record Delimiter. How have you set Record Delimiter? If you open the file using vi and position to the end of the file (0G) is the cursor at the end of the last line or on a new empty line? This will tell you whether or not there's a line terminator on the final li...