DSXchange

I want to SELECT COLUMN that is NCLOB but only the first 255 bytes. How? New to DataStage, Oracle. 37 years MAINFRAME. Lets me in Oracle SELECT substr(COLUMN,1,255) but not DataStage...

My first DataStage...my first lookup. I don't know what all this means. And you CAN'T cut/paste...been doing it since invented...won't do it.

You can't cut/paste the error message. When checking operator: Schema field CODE in input data set 0 not present in design time information?

Trying to setup a lookup for code to get name. Another impossible task.

Gone...because I GAVE UP and removed the offending column...will have to add back later to be considered finished...but miserable day of trying.

It's gone.

Going to just remove that column from output.

Yes

New to Oracle/DataStage...trying to read Oracle table with column Message defined as NCLOB and join to another Oracle table to create new Oracle table with the Message column. Problems with NCLOB...can't insert too BIG.
This is just the first step of this project.