Primary key
This is a multi-part message in MIME format.
------=_NextPartTM-000-55b1c71e-c79f-4413-890f-3628a2242ce3
Content-Type: text/plain;
charset="iso-8859-1"
I need kwnow how can I disable a PK when a foreign key is attached to this PK.
I try this:
set constraints u241_435 disabled
But I obtain this error:
892: Cannot disable object (informix.u241_435) due to other active objects
Thanks
------=_NextPartTM-000-55b1c71e-c79f-4413-890f-3628a2242ce3
Content-Type: text/plain;
name="InterScan_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="InterScan_Disclaimer.txt"
======================================================================
WARNING
The information in this e-mail and in any attachment is confidential and
intended solely for the attention and use of the named addresse(s). It must
therefore not be disclosed to any person without our previous authorization.
If you are not the intended recipient or a person responsible for delivering
it to the intended recipient you are not authorized to and must not disclose,
copy, distribute or retain this message or any part of it and you are
requested to notify the sender immediately.
Electronic messages may be altered. Aguas Provinciales de Santa Fe S.A. shall
therefore accept no liability whatsoever and howsoever resulting from this
message if it has been changed, distorted or falsified.
======================================================================
ADVERTENCIA
La información contenida en este mensaje y cualquier archivo anexo al mismo es
confidencial y dirigida exclusivamente para su utilización y aplicación por
los destinatarios consignados. En consecuencia, no debe ser divulgada a
ninguna persona sin autorización previa. Si no es uno de los destinatarios
consignados o
la persona responsable de hacer llegar este mensaje a los destinatarios
consignados, Usted no está autorizado a divulgar, copiar, distribuir o retener
la información (o parte de ella) contenida en este mensaje, y se lo insta a
notificar al remitente inmediatamente.
Los mensajes electrónicos pueden ser alterados. En consecuencia, Aguas
Provinciales de Santa Fe S.A. no aceptará ninguna obligación cualquiera sea el
resultante de este mensaje en caso de haber sido modificado, distorsionado o
falsificado.
======================================================================
------=_NextPartTM-000-55b1c71e-c79f-4413-890f-3628a2242ce3--
U cannot since a FK relationship is enforced using the PK index ... so u
have to drop the FK constraint first and then disable the PK index...
Thanx much,
Rajib Sarkar
Advisory Support Engineer (Wells Fargo Bank)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
As long as you derive inner help and comfort from anything, keep it --
Mahatma Gandhi
"Baffigi,
Ch...." To: ids@iiug.org
<cbaffigi@apsf.c cc:
om.ar> Subject: Primary key [84]
Sent by:
forum.subscriber
@iiug.org
01/22/2003 10:14
AM
This is a multi-part message in MIME format.
------=_NextPartTM-000-55b1c71e-c79f-4413-890f-3628a2242ce3
Content-Type: text/plain;
charset="iso-8859-1"
I need kwnow how can I disable a PK when a foreign key is attached to this
PK. I try this:
set constraints u241_435 disabled
But I obtain this error:
892: Cannot disable object (informix.u241_435) due to other activeobjects
Thanks
------=_NextPartTM-000-55b1c71e-c79f-4413-890f-3628a2242ce3
Content-Type: text/plain;
name="InterScan_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="InterScan_Disclaimer.txt"
======================================================================
WARNING
The information in this e-mail and in any attachment is confidential and
intended solely for the attention and use of the named addresse(s). It must
therefore not be disclosed to any person without our previous
authorization.
If you are not the intended recipient or a person responsible for
delivering it to the intended recipient you are not authorized to and must
not disclose, copy, distribute or retain this message or any part of it and
you are requested to notify the sender immediately.
Electronic messages may be altered. Aguas Provinciales de Santa Fe S.A.
shall therefore accept no liability whatsoever and howsoever resulting from
this message if it has been changed, distorted or falsified.
======================================================================
ADVERTENCIA
La información contenida en este mensaje y cualquier archivo anexo al mismo
es confidencial y dirigida exclusivamente para su utilización y aplicación
por los destinatarios consignados. En consecuencia, no debe ser divulgada a
ninguna persona sin autorización previa. Si no es uno de los destinatarios
consignados o
la persona responsable de hacer llegar este mensaje a los destinatarios
consignados, Usted no está autorizado a divulgar, copiar, distribuir o
retener la información (o parte de ella) contenida en este mensaje, y se lo
insta a notificar al remitente inmediatamente.
Los mensajes electrónicos pueden ser alterados. En consecuencia, Aguas
Provinciales de Santa Fe S.A. no aceptará ninguna obligación cualquiera sea
el
resultante de este mensaje en caso de haber sido modificado, distorsionado
o falsificado.
======================================================================
------=_NextPartTM-000-55b1c71e-c79f-4413-890f-3628a2242ce3--
You need to disable the foreign key first, then disable the primary key.
To re-enable them, you would need to do the primary key first, then the
foreign key.
I need know how can I disable a PK when a foreign key is attached to this
PK. I try this:
set constraints u241_435 disabled
But I obtain this error:
892: Cannot disable object (informix.u241_435) due to other activeobjects
HTH...
Mike
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Mike Lowe
Certified Consulting Education Specialist
Data Management Solutions
IBM Software Group
Tel: 303-773-5216 Tie Line: 565-5216
e-Fax: 413-674-2415
mlowe0@us.ibm.com
WWW: ibm.com/software/data