DSXchange

Looks like you've got a packed decimal.

Do a search for "packed decimal".

What does "performance" mean in this context?

And what does "lower" mean in the same context?

What empirical evidence do you have to support your assertion, and can you provide these numbers?

Date format for ODBC must be YYYY-MM-DD

You are using an ODBC driver, and therefore must conform to the standards specified for ODBC.

Step back for a moment. Do you have a UNIX-based ODBC driver for Excel? If you don't the rest of the conversation is moot.

Has anyone else noticed that Oracle is an anagram of "Orc Ale"? And is occasionally misspelled thus?

What is "VSP" and how are you calculating the totals? Have you conducted a data check - for example using the Debugger - to ensure that your derivations produce the correct pre-summing results? Are you converting to a numeric data type before summing?

chulett wrote:Ray? Is that you?

No. Still at work when that was posted, and in Japan not in Australia at the time.

Sequential File stage reads the file. It defines one column, let's call it Line, of type VarChar(255) - or longer if required. Transformer stage has three outputs. It has a stage variable defined to contain svRecordType = Left(InLink.Line,3). Output constraints are then: svRecordType="HDR" svRecordT...

Good, now verify the command that DSExecute is being asked to process. Immediately ahead of it, use something like Call DSLogInfo("Command is " : UNIXCmd, "Debugging") Verify, also, that /opt/home/xxx/script.sh actually exists at that location. The "not found" error messa...

CPU - at least one. RAM - at least one. Storage - some. Seriously this is not really an answerable question. You could say that the storage requirements are zero (for the DataStage server) because data pass through - are not stored in - DataStage server. But if you are planning to stage data between...

It's not a supported operating system.

That said, you won't know till you try it. I haven't, so can't comment.

Learn patience. That piece of advice is the first item of help. You have posted in the "wee small hours" in the USA. DSXchange is an all-volunteer site, whose participants post as and when they can, if they have something to say. If you want a more rapid response than that, you buy it by signing up...

Which part of "examples of rows" wasn't clear?

You have to configure the DSN on the UNIX machine, by editing a file called .odbc.ini (also referencable as $ODBCINI). The UNIX machine then becomes the client to Excel on the Windows machine.

So what is "the desired result"? Give a brief example of rows from inputs and expected output.