DSXchange

delete the temporary tables manually thru GUI. This is a bug in teradata i guess, wherein the temporary tables dont get deleted automatically.

After you delete them, release the mload.

As said above, this is teradata issue. Discussing with your DBA would have helped

Well, if the zSeries is running the IBM PRPQ that supports SSH, then you can connect from Unix to mainframe directly. Zseries is running fine, so i should be able to connect to mainframe from unix directly. I need some details about the ODBC parameters which i would need to put in there like the Dr...

thanx a lot. will enquire and try that out.

So it needs an adopter to connect to mainframes and unix cannot connect to the mainframes directly?

Hi,

I need to compile a list of parameters needed to connect to DB2 Z/O through datastage. Can anyone privde suggestions on the best way to do this?

Are there any Mainframe plugins necessary or creating an ODBC will do?

One more milestone created. Than a lot guys for your help.

kjaouhari already has the best solution in her hand like using a hash file to seperate out the inserts and updates.

Now kjaouhari wants other solutions. So i gave one

I posted that cause i knew this is what he was asking about. This is what the helps says "protect project" can do. Note: on UNIX systems, only root or the administrative user can currently protect and unprotect projects. Users can view objects in the project, and perform tasks that affect ...

what is role of the contains terminators in the sequential file By checking on the "contains terminator", you direct datastage to ignore any terminator which comes in a record. So you can ignore a termination character in a varchar 200 field. otherwise, datastage will read that terminator...

kjaouhari wrote: And I know that I can do a lookup with a huge hash file to select the new rows...
Do you have other solutions to do an insert new rows without update in an oracle table ?

Isn't there any option in that says "Update existing or insert new" while loading?

Hi All, How to create read only jobs in Datastage.As of my knowledge there is an option for releasing the jobs in manager Tools option. In my production box with exclamation mark 'JobName' is Read Only. Any changes that you make cannot be saved. . Kindly share your ideas for creating such read only...

Since you say that the next job didnt run but all other jobs ran successfully, i guess there is a problem in the job which didnt run and not the sequencer.

How are you ensuring that insert is after update as shown in your design?

Do you see any warnings in the director?

Post your job structure. You should better resolve the problem than look for Job time out which i doubt it exists.

Check for the presence of termination characters as i said earlier.