DSXchange

Now's our chance to catch up! (cough)

:D

You are getting that from what? You've never explained exactly how you are 'running' this command. A script? Bat file? Hand? Cron? Control-M? A solid gold Khama Sutra coffee pot or... a baby's arm holding an apple. (sorry) ps. You haven't managed to run anything, let alone attempted to execute the d...

Please start a new post so we know your O/S and DataStage version. Also include *all* related messages from your job's log and describe your job design for us. Have you ever used this stage before successfully or is this the first time you are attempting it? All that in the new post, not here.

There's also Index if you want to find a substring inside a string, but your first Matches would need '...MDN...' I believe. '3X3N' means any three characters followed by any three numbers.

ajay.prakash03 wrote:ithink in this way==
oracle stage----->trans---->oracle--------->trans----------------->oracle..last table DB2.

Yes, that's what the job would need to look like. Have you tried to create it yet? What part do you help with?

Off the top of my head - Send down a reject link set to Abort after 1 record or call DSLogFatal in a derivation based on a check of the lookup result.

In other words, create two entries.

id4dstech wrote:Can we define it for dropping more than one table in the same job?

chulett wrote:Two tables, two links.

One stage with two input links if both tables are in the same 'database' accessible by the same userid. If not, use two stages as well.

I'm curious why you 'need' to create 5 temp tables? I'm sure you could do all these in one SQL statement without necessarily creating scads of temp tables.

The RT_CONFIG651 directory is in ./CAT and ./VCOMM. What? Those are DSEngine directories and should have nothing to do with any job specific directories. Did you end up doing any kind of restore from your backup to the wrong place? Regardless, we can come back to that later... You need to check in ...

Create two entries with different names - TEST1 and TEST2, for example. Or name them something that makes more sense based on the difference between the two.

You need to check and see if there is an RT_CONFIG651 directory there. (note the correct spelling) This is actually a dynamic hashed file that has been corrupted in some fashion for this job. If the directory exists, I'd suggest you copy the contents (all three files, one is hidden) of any other RT_...

abc123 wrote:Error calling subroutine DSR_JOB(Action=5) Check DataStage is set up correctly.

So... to be clear... you get this error when you try to delete one particular job? Just a delete issue, meaning you can edit the job and perhaps even run it?

abc123 wrote:Tried some of the solutions which got me into the trouble of jobs being invisible.

Such as? If there's some bad advice out there, point it out and we'll see about getting it corrected.

Tell us exactly what you did. How did you 'try to fix the problem' in the Adminstrator? What, if anything, did you actually restore from backup? When your jobs 'go invisible' the first suggestion is to ensure no-one else is connected to DataStage and then use the DS.TOOLS option #2 to Rebuild Reposi...