DSXchange

Sigh. Another newbie post that smells like interview questions. Arnd, I think you've got number two a little wrong. The question is perhaps poorly stated, I'm wondering if they specifically mean if both a routine and a transform have the same name - which one is executed 'first'? First is the wrong ...

sathyanveshi wrote:Fine. In that case, what if my Oracle supports only 50 sessions? How will the parallel jobs execute?

Poorly.

As Ray notes, how many are you planning on running at the same time?

RESET mode from the command line does the same thing that resetting the job from the Director does. It is only needed after a job has Aborted or has otherwise gotten itself into a state where the job cannot be run. Typically, any dsjob shell script would check the job and RESET it before running it,...

It's a procedure, so you'd need to call it directly in the Before (or After) SQL tab. Search the forum for examples of using Stored Procedures with the OCI stages.

And did you restart the DataStage Server again? No, you shouldn't need root access to edit the dsenv file... which should be obvious by your ability (or inability) to save the modified file.

Select the OLETYPE as well as the count, so you can see what objects the counts are associated with. After that, if should be fairly obvious.

I would certainly think so.

Don't think so Mr Kim, unless you bump into some kind of ulimit. Or it might get slower and slower to append data to the log...

You just add the Invocation ID to the end of the job name, putting a dot/period between the two. So, instead of running jobname you would run jobname.invocationid instead.

Is that what you were looking for?

There's a menu option to do that... don't recall the exact command to get into it - DEADLOCK.MENU or some such? Stupid brain.

But in general, the answer is 'yes'.

You haven't said how you are receiving this data - in flat files? I'm a little bit at a loss as to why you feel a need to pad your fields to a constant length - why is this required? Perhaps more information about your source and target and why you feel the need to pad everything will help shed some...

Ok, looks good. All you really need, environment variable wise, is to set ORACLE_HOME. And perhaps TNS_ADMIN if your tns files are off somewhere non-standard. The others - ORAHOME, ORACLE_SID and ORASID - aren't needed but don't hurt as far as I know. I'm assuming your SHLIB_PATH is being set somewh...

1. Is is required to install Oracle client in DS server in order to connect to Oralce DB. Yes. 2. Is there any other entry other than dsenv required. You haven't told us which entries you did add. What's required is spelled out in the Plugin Installation and Configuration Guide. Besides, what entri...

No, it's the DB2 stage that requires a date in internal format. The OCI stage is driven by the data type associated with the DATE field in the job. There is even a special section in the pdf documentation for the OCI stages on Date Handling. Typically, you declare the DATE field to be a Timestamp in...

Are you asking when you should use the Oracle Bulk Loader stage in DataStage and when you should use Oracle's sqlldr? Many people would tell you to never use the DS Bulk Loader to actually do the work. We only let it create the control file for us by setting it to 'manual mode' and putting an @FALSE...