DSXchange

You might also consult the Message Reference Guide to see whether IIS-DSTAGE-ABAP-E-00746 is there. I'm not currently at a location where version 11.3 manuals are available.

Again, read your errors carefully.

This time the main problem seems to be ABAP background job time-out occurred as defined using BG_JOB_TIMEOUT property.

Work with your SAP administrators to verify and probably suggest a better value for this property.

Verify that the date format produced by the server job is identical to that expected by the parallel job. If it isn't, change the format string for the date data type columns in the parallel stage that reads the file.

Welcome aboard.

Tip #1 is to read the error messages in detail.

In this case the really important piece of information is ERROR connection to partner '192.168.168.158:3310' broken

You need to work out, possibly involving your network team, why the connection got broken.

Have you read the Connectivity Guide for Teradata manual? It explains the alternatives and gotchas.

Also ditch the RETURN function. RETURN(Ans) is automatically created.

Send me an email I'll send you a DSX. Website is under redevelopment in my copious free time (yeah.).

It is the very nature of sequential files that you must read every column. You must, indeed, read past every single byte to get to the next. Using a schema file does not get around this requirement, though you may be able to leverage the "Drop on Import" property - something I've not seen ...

Given that you're running on Windows you should be able to use the Microsoft ODBC driver for Excel to write to an existing (even if empty) worksheet. Alternatively write to a CSV file that can be opened using Excel. With a common key it should be a simple join. Start with a full outer join so that y...

Never assume.

The stated requirement is to merge two CSV files into one CSV file. That can be done easily with DataStage once the rules for merging are comprehended.

But why was "worksheet" mentioned in this case?

Not enough information, though the answer is probably yes. Are the metadata of the two CSV files identical? What does the resultant CSV file have to look like in terms of its columns? What has "worksheet" got to do with anything?

Where did you hear this? Pump THEM for more information.

Tres formidable!

Hey, DSXchange can do it too! :D

Tres formidable!

For each row processed all stage variables are evaluated before the loop is executed.