DSXchange

What version of 8.x? Are you current on your patches / fixpacks?

This is one, this is another, both are Redbooks. The 'Guide' he also mentions is one of the standard pdf documents that you already have.

Only of the 'sketchy' variety.

viewtopic.php?t=136247

Moment this error(ORA-01036: illegal variable name/numbe) occured, first thing i have done is executed SQL query in the toad. Query is absolutely working fine. All that means is the SQL's syntax is correct. It doesn't mean it will work in DataStage where a number of other factors come into play. I ...

... much like I posted.

IBM Certification page for 8.0 and 8.5

Do an exact search here for that ORA-01036 error code, you're not the first person on the planet to cause it.

Answer Ray's question, please.

Your solution implies that a character field is involved somewhere. Which would also go towards explaining the reason why it didn't work before that.

... create, not read.

Ah... that's good to know about 8.1.

Conversions in Server are automatic and thus implicit, so just moving it from the flatfile to a numeric column before the lookup should work fine.

Let's make sure we're talking about the same "that table"... I meant can you run the query in the error message, not can you select from your target table.

As you noted, fixed-width files can be read by multiple reader nodes while delimited ones cannot. Nature of the beast rather than a specific DataStage 'thing'. In your shoes, I would ask them (your other teams) what they would prefer. Again, it will depend on the tool used to do the actual loading b...

What happens when you execute the same query under the same userid outside of DataStage? Does it return any rows?