Finding a table name with constraint name

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
pukars4u
Participant
Posts: 24
Joined: Tue Dec 27, 2005 6:27 pm

Finding a table name with constraint name

Post by pukars4u »

Hai I am getting some problem

its giving Integrity constraint error

DOes any one know

how to find a particular table name with the constraint Name

Help will be appreciated

Thanks in advance
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Hello pukars4u,

the question really has nothing to do with DataStage - but if you might be kind enough to tell us which database you are using someone might be able to answer the question.

Since you are running a job you probably know which table you are working with. You most likely will also be getting the name of the contraint that you have violated in the error message as well. Isn't that most of what you need to know already?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Send the error message to your DBA.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply