DSXchange

CFF is the Complex-flat-file stage. The Sequential stage is one of the fastest possible means of reading a file. Is the file fixed length or variable length?

Sequential file stage for one. CFF as well.

Why can't you read a file of over 5Gb in DataStage?

If you are still getting the warning after having removed the statement then I would suggest you look elsewhere for the cause.

There are days, yesterday and today, where I'd love to go back and redact/bowlderize/modify or just plain delete my posts... Craig - righto, I should have caught that Windows reference at the beginning of the thread. Devesh - can you also confirm that you executed your SQL on the Server and not on y...

There are only a few files required for a complete move of a DataStage project from one machine to another. The contents of the DataStage jobs (or programs, to use another term) can be backed up into one (potentially rather large) file. This file can then be imported on another system, even another ...

We computer types actually think that there are 10 types of people in the world: Those who understand binary, and those who don't

And are the Oracle environment variables activated in the "dsenv" script in $DSHOME?

Are you certain that the message is at the DSAttachJob()? Try a DSLogWarn() before and after to make certain - I've never seen that message triggered from that call.

What format and data type is your incoming date?

No options, since the quote character is used to shift in and shift out of a column; only a double occurrence of the quote character tells the parser that it is part of the data and not a control character.

QualityStageParallel Job Developer Guide page 31 as marked at the bottom of the actual page, page 43/637 according to the PDF counter on the top. Alternately search the document for "%E".

Try outputting your data to a peek stage or file, make one column have "Input" as a value and the other "IsValid("Int32",Input)" and find an example of a value that is not as you expect.

I think your problem is illustrated by the field

"ghfhdd"gkjdgfd"

In order to be parsed correctly, it would need to be formatted as

"ghfhdd""gkjdgfd"

Variables and Column names are case sensitive. "Input" is not the same as "input".