DSXchange

Looks like you're going to need to find another place to do these deletes. The close command must wrap stuff up in an anonymous block and thus, when the delete finds nothing to delete, throws the 'no data found' error.

UNIX doesn't care, your issue lies elsewhere.

... because... what he said.

So, no misunderstanding at all. As noted, only one Oracle error will be reported at a time. You fix it and then the next will be raised. Lather, rinse, repeat. This is not a 'DataStage server' behaviour, it is a standard database behaviour.

i am inserting this values into oracle table using oracle(database) stage. oracle internal format is 'dd-mon-yyyy'. No, that is not the 'Oracle internal format'. That is an external format. you don't have to use 'to_date' function in your insert statement because already the input column is convert...

tatireddi wrote:If we have a "&" in the values clause the oracle will go for the Prompt "Enter Value for" considering the value after "&" as variable.

No.

siva7143 wrote:So what could be solution for this.

Why, more disk space of course.

I know the readme always said that, but I never needed to rebuild/relink anything from what I recall. [shrug]

Sure... a search on DSParams should turn up conversations where that is discussed. Just a simple exercise with a text editor.

I've only used them in routines. I'm not positive but have you tried just typing them in and compiling the job regardless of the fact that it stays red in the derivation? Sometimes that's just a matter of the function not being in the DSParams file so it's not recognized as valid but works fine when...

You'll need to purchase any drivers you get from DataDirect. Have you done all of the configuration steps needed for Oracle in DataStage? Edited the dsenv file to include $ORACLE_HOME and added the appropriate library to your 'shared library' path then restarted? If the OCI stages work then you've g...

Have you actually tried it and had a problem? There shouldn't be anything 'special' about that character that I recall.

There are two files that need to be edited if you want things to show up automagically, see if this helps: m Otherwise, from what I recall, after creating the .odbc.ini entry manual entry of the entry name will create the uvodbc.config entry in the Project for you. I prefer to do both myself. Your '...

I'm sensing a pattern emerging here... Please take the time to try to help yourself first. Open the OCI stage, switch to the tab you are curious about and then click the 'Help' button. For example, from the Input tab you'll get a help page with explanations for all of the questions you've posted her...

The Command stage is like a Sasquatch - I've worked on UNIX servers all of my DataStage life and yet I've never seen it. When I asked about it here many moons ago, I was told that was because it is only installed on Windows servers so that's what I passed along. More than that, I know not.