DSXchange

I have a Datastage 8.5 Server that needs to communicate with an Oracle database. If I want to retrieve a decimal value in a query, Datastage set a dot or a comma behind it. the equivalent setting in the Database is NLS_NUMERIC_CHARACTERS=,. that i can set in the enviroment settings. The orchdbutil n...

Many thanks for your answer...

Does that mean that the client-software hasn't changed that much?
And is the client-software part of the InfoSphere Information-Server?

Rgds

Hello, since a couple years we are using DataStage 7.5.2 and 7.5.3. The components we are using are: - DataStage Administrator - DataStage Director - DataStage Designer, Manager - DataStage VersionControl Now it's planned to migrate to IBM InfoSphere 8.5. Currently I'm going through the IBM document...

Try to analyse your SQL statement carefully. We encountered this problem several times, yet. In our case, it always was related to the statement itself: 1st time: SELECT NULL, something, something_else FROM (...) --> You cannot select NULL in the select-clause of a sql-statement within DataStage, al...

Sainath.Srinivasan wrote:Have you ticked on/off the nullable property in source?

Yes, both on the source and the target. I will simply igore the warning. Thanks all of you

What if you provide an alias name in source. like SELECT value1, value2, value3, NVL(TRIM(CODE),'UNKNOW') CODE, value4 FROM mytable :D Oh tanks ist's working but why? I dont understand. Now i have the folowing warning: mytable: When checking operator: When binding output interface field "CODE&...

Is CODE not nullable both on the input and on the output of the Modify stage?
Yes
What is the data type of CODE ?
VARCAHR2

Hello, I implement a dataStage job to Extract from a Oracle Database. Source is mytable and goal goaltable The following SQL statement is not working can somebody tell me why: SELECT value1, value2, value3, NVL(TRIM(CODE),'UNKNOW'), value4 FROM mytable Error: goaltable: Not writing to column CODE, a...

Already resolved a while ago...
Error was due to a wrong version of a windows library (dll)

I know some people who wouldn't consider any release of Oracle particularly stable. :wink: Seems to me you are squarely in the hands of IBM and Oracle for this resolution. Let us know what you find out! I'm really curious what the culprit here is going to turn out to be. IBM solved that issue with ...

I know some people who wouldn't consider any release of Oracle particularly stable. :wink: Seems to me you are squarely in the hands of IBM and Oracle for this resolution. Let us know what you find out! I'm really curious what the culprit here is going to turn out to be. IBM solved that issue with ...

/etc/nsswitch.conf was missing/misconfigured.

I know some people who wouldn't consider any release of Oracle particularly stable. :wink: Seems to me you are squarely in the hands of IBM and Oracle for this resolution. Let us know what you find out! I'm really curious what the culprit here is going to turn out to be. OK, I will let you know whe...

We had to do the same thing, just shows an installer problem specific to Itanium servers. And you may want to consider upgrading to the latest Oracle release - it typically is pretty painless when it's a minor version like that and they've released it for a reason, typically to correct problems in ...

Don't be - there are all kinds of goofy problems you can lay square at the feet of particular Oracle versions that have nothing to do with DataStage. It may be as simple as using a different / more stable version of the client on your DataStage server. What exact 10g version of the client? Is there...