DSXchange

Because our DS project has lot of OCI stage ,so Initialize the oracle session by using before query in OCI stage is not good for maintains purpose Unfortunately, since each stage establishes its own connection / session, that is your only option. You would need to use a Job Parameter for the 'alter...

Yup. :D

Actually, I said it does work irrespective of job status. Apart from running the shell script, i also tried using the -lparams command in a stand alone fashion and yet it seems to act the way it does. Meaning what, exactly? That just running it from the command line it works fine or it exhibits the ...

Yeesh. First off, when using the SQL File option, the User-Defined SQL area *is* where the actual sql file pathname goes. Technically, what normally goes in the Table Name area would be the table you are selecting from but since you are going down the user-defined path it doesn't matter what you put...

You missed a user routine that it calls named FileFound - import that one as well.

The only reason I asked about the version is that early implementations did not handle encrypted passwords properly from what I recall. However, on 7.5.1 you should be 'fine'.

I haven't tried using them myself, so can't reall comment on how it should (or should not) be done.

the transformer only has output rows which is nothing but the columns of the particular table i'm trying to delete. and i have set the value of all of it as 0. Your problem in a nutshell. You have to pass the actual key values for the records you want deleted, you've said to delete records where th...

What specific 7.x version of DataStage?

Yes. Convert both to internal format and subtract. Search the forums for examples of the IConv function to perform the conversion.

Still looking for details. Where does this database live? On the DataStage server? Are there other jobs that access this instance that work and this one job the only one that fails? Or is this 1 job literally the only job to access this instance? Both tnsping and sqlplus were successful when execute...

PL/SQL.

StringToDate() with the appropriate format mask. Forget about the 'to YYYYMMDD' part, a date is a date.

Does not your 'third party scheduler' return a status? The Execute Command stage can check that status in its triggers or a downstream stage can check it as well.

Or that.

Has this 'Testing server' been configured for Oracle? What is different about it from Production other than the server it lives on?