DSXchange

directory is full or your user hasn't sufficient permission to create files in that directory are the two most common causes. Check at UNIX whether the file already exists in that path.

from the uv shell in that project or from the command line tool in the Administrator, type "COUNT RT_CONFIG6311" and see if you get a valid count or an error message.

Shin - could you post your exact error message?

If you have a VarChar and the TRIM() result looks like it still has spaces then odds are you don't have spaces. Try writing the result of "Convert(' ','?',In.Column) to a peek stage - do you see question marks or spaces?

Ok, then remove the error-causing default "null-field" attribute from the column defnition.

You need to add a valid date as the null value, i.e. "2008-12-31 23:59:59", assuming your system default is yyyy-mm-dd

Trim() will only work with VarChar() data, not with Char().

I think adding the patch will be your only route to closure.

I am not currently on 7.5x & Oracle & AIX but I have worked on that configuration. Importing Oracle metadata worked, my first thought is that your issue revolves around access rights. Can you get a friendly DBA to come over and use his/her godlike ID to see if the metadata is visible?

It sounds like the same issue. Does the error go away when you remove the @ variables? That would narrow down the possible cause.

If your first job with a transform and sequential files compiled & ran then your compiler installation is probably OK. Which Oracle stage and version are you using? Can you "view data" to Oracle in a designer window? Can you import column metadata from Oracle into DataStage?

I don't know. I had a case today with V8/Oracle where it errored because the SQL had a semicolon.

aschand - please take a step back and assume that we have no idea as to what any of the columns mean. What are you asking for help on? Syntax? Null Handling? Adding an extra row?

If the jobs don't have an active link between two passive stages, DataStage will insert one for you (look at your log and you will see "ident1")

Please give an example. I've worked with numerous Asian sites/languages and haven't seen different behaviour.