Oninit cdi / Archive
Talk to an expert →

How can I disable a foreign key???

Posted in 2006

Topics: Storage & Space Management, Triggers, Constraints & Referential Integrity, Migration, Import/Export & Data Conversion

Diego Morales — — source: Usenet: comp.databases.informix

Hi to all. I have problems to unload/load a table to set extents correctly (I have table with more than 500,000 records and more than 100 extents). I need to disable foreign keys to unload and load the main table but I don't know how. Please help me. TIA. DJMoralesM

↪ replying to Diego Morales
Superboer — — source: Usenet: comp.databases.informix

have a look at set contraints..... disabled ; -->> object modes... in the guide to sql afaikr Superboer Diego Morales schreef: > Hi to all. I have problems to unload/load a table to set extents correctly > (I have table with more than 500,000 records and more than 100 extents). I > need to disable foreign keys to unload and load the main table but I don't > know how. Please help me. > > > > TIA. > > > > DJMoralesM > > > ------=_NextPart_000_00E4_01C70F00.A3BCBB20 > Content-Type: text/html > Content-Transfer-Encoding: quoted-printable > X-Google-AttachSize: 1975 > > <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = > xmlns:w=3D"urn:schemas-microsoft-com:office:word" = > xmlns=3D"http://www.w3.org/TR/REC-html40">; > > <head> > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > charset=3Dus-ascii"> > <meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)"> > <style> > <!-- > /* Style Definitions */ > p.MsoNormal, li.MsoNormal, div.MsoNormal > {margin:0cm; > margin-bottom:.0001pt; > font-size:12.0pt; > font-family:"Times New Roman";} > a:link, span.MsoHyperlink > {color:blue; > text-decoration:underline;} > a:visited, span.MsoHyperlinkFollowed > {color:navy; > text-decoration:underline;} > span.EstiloCorreo17 > {mso-style-type:personal-compose; > font-family:Arial; > color:windowtext;} > @page Section1 > {size:595.3pt 841.9pt; > margin:70.85pt 3.0cm 70.85pt 3.0cm;} > div.Section1 > {page:Section1;} > --> > </style> > > </head> > > <body lang=3DES link=3Dblue vlink=3Dnavy> > > <div class=3DSection1> > > <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB = > style=3D'font-size: > 10.0pt;font-family:Arial'>Hi to all. I have problems to unload/load a = > table to set > extents correctly (I have table with more than 500,000 records and more = > than > 100 extents). I need to disable foreign keys to unload and load the main = > table > but I don&#8217;t know how. Please help me.<o:p></o:p></span></font></p> > > <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB = > style=3D'font-size: > 10.0pt;font-family:Arial'><o:p>&nbsp;</o:p></span></font></p> > > <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB = > style=3D'font-size: > 10.0pt;font-family:Arial'>TIA.<o:p></o:p></span></font></p> > > <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB = > style=3D'font-size: > 10.0pt;font-family:Arial'><o:p>&nbsp;</o:p></span></font></p> > > <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB = > style=3D'font-size: > 10.0pt;font-family:Arial'>DJMoralesM<o:p></o:p></span></font></p> > > </div> > > </body> > > </html> > > ------=_NextPart_000_00E4_01C70F00.A3BCBB20--

↪ replying to Diego Morales
=?iso-8859-1?q?Rich_or_Krist=EDn?= — — source: Usenet: comp.databases.informix

Diego Morales wrote: <snip> > need to disable foreign keys <snip> *sighs* http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqls.doc/sqls725.htm