Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Turning off Referential Integrity in Reload.sql

4 posts in ,  General Discussion Replication Last posting was on 2003-02-26 14:54:40.0Z
Surender Posted on 2003-02-26 14:34:13.0Z
From: "Surender" <sseshadri@gbahn.com>
Subject: Turning off Referential Integrity in Reload.sql
Date: Wed, 26 Feb 2003 09:34:13 -0500
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <zEOcnca3CHA.263@forums.sybase.com>
Newsgroups: ianywhere.public.general,powersoft.public.powerdesigner.general,sybase.public.sqlanywhere.replication
NNTP-Posting-Host: 66.152.247.82
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:776 powersoft.public.powerdesigner.general:130 sybase.public.sqlanywhere.replication:129
Article PK: 3267

Hi All,

I there any way that I can load the data by turning off Referential
Integrity and then re-enabling it after loading while executing the
reload.sql

I tried with SET TEMPORARY OPTION FIRE_TRIGGERS='OFF' option and found it is
only for Triggers and not for Referential Integrity (like primary and
foreign key )
You help in this is highly appreciated

Thanks in advance

Surender


Chris Keating Posted on 2003-02-26 14:51:29.0Z
From: "Chris Keating" <Fight_Spam_keating@iAnywhere.com>
References: <zEOcnca3CHA.263@forums.sybase.com>
Subject: Re: Turning off Referential Integrity in Reload.sql
Date: Wed, 26 Feb 2003 09:51:29 -0500
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <km3xSla3CHA.187@forums.sybase.com>
Newsgroups: ianywhere.public.general,powersoft.public.powerdesigner.general,sybase.public.sqlanywhere.replication
NNTP-Posting-Host: 172.31.140.19
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:779 powersoft.public.powerdesigner.general:133 sybase.public.sqlanywhere.replication:132
Article PK: 2732

Please allow at least 24 hours before reposting... And please do not
crosspost.

I have asked a followup question to your post in SQLAnywhere general.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

"Surender" <sseshadri@gbahn.com> wrote in message
news:zEOcnca3CHA.263@forums.sybase.com...
> Hi All,
>
> I there any way that I can load the data by turning off Referential
> Integrity and then re-enabling it after loading while executing the
> reload.sql
>
> I tried with SET TEMPORARY OPTION FIRE_TRIGGERS='OFF' option and found it
is
> only for Triggers and not for Referential Integrity (like primary and
> foreign key )
> You help in this is highly appreciated
>
> Thanks in advance
>
> Surender
>
>


Robert Waywell Posted on 2003-02-26 14:53:51.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <zEOcnca3CHA.263@forums.sybase.com>
Subject: Re: Turning off Referential Integrity in Reload.sql
Date: Wed, 26 Feb 2003 09:53:51 -0500
Lines: 55
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <Vi80nma3CHA.245@forums.sybase.com>
Newsgroups: ianywhere.public.general,powersoft.public.powerdesigner.general,sybase.public.sqlanywhere.replication
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:778 powersoft.public.powerdesigner.general:132 sybase.public.sqlanywhere.replication:131
Article PK: 2737

In the reload.sql you will see that the FK's are created after the data is
loaded, so if you are having problems during the loading of the data, it
shouldn't be FK issues. It could be check constraints, datatype
incompatibilities, or duplicate PK's.

To remove the RI from the reload.sql you can comment out the ALTER TABLE
... ADD FOREIGN KEY... statements.

FYI - SQL Anywhere or Adaptive Server Anywhere questions are best asked in
the forum sybase.public.sqlanywhere.helpdesk which is specifically focused
on SQL Anywhere and ASA.


--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Surender" <sseshadri@gbahn.com> wrote in message
news:zEOcnca3CHA.263@forums.sybase.com...
> Hi All,
>
> I there any way that I can load the data by turning off Referential
> Integrity and then re-enabling it after loading while executing the
> reload.sql
>
> I tried with SET TEMPORARY OPTION FIRE_TRIGGERS='OFF' option and found it
is
> only for Triggers and not for Referential Integrity (like primary and
> foreign key )
> You help in this is highly appreciated
>
> Thanks in advance
>
> Surender
>
>


Robert Waywell Posted on 2003-02-26 14:54:40.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <zEOcnca3CHA.263@forums.sybase.com> <Vi80nma3CHA.245@forums.sybase.com>
Subject: Re: Turning off Referential Integrity in Reload.sql
Date: Wed, 26 Feb 2003 09:54:40 -0500
Lines: 86
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <m1Z6Ena3CHA.245@forums.sybase.com>
Newsgroups: ianywhere.public.general,powersoft.public.powerdesigner.general,sybase.public.sqlanywhere.replication
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:777 powersoft.public.powerdesigner.general:131 sybase.public.sqlanywhere.replication:130
Article PK: 2733

correction to my newsgroup reference, it should have been
sybase.public.sqlanywhere.general

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Robert Waywell" <rwaywell@ianywhere.com> wrote in message
news:Vi80nma3CHA.245@forums.sybase.com...
> In the reload.sql you will see that the FK's are created after the data is
> loaded, so if you are having problems during the loading of the data, it
> shouldn't be FK issues. It could be check constraints, datatype
> incompatibilities, or duplicate PK's.
>
> To remove the RI from the reload.sql you can comment out the ALTER
TABLE
> ... ADD FOREIGN KEY... statements.
>
> FYI - SQL Anywhere or Adaptive Server Anywhere questions are best asked in
> the forum sybase.public.sqlanywhere.helpdesk which is specifically focused
> on SQL Anywhere and ASA.
>
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Surender" <sseshadri@gbahn.com> wrote in message
> news:zEOcnca3CHA.263@forums.sybase.com...
> > Hi All,
> >
> > I there any way that I can load the data by turning off Referential
> > Integrity and then re-enabling it after loading while executing the
> > reload.sql
> >
> > I tried with SET TEMPORARY OPTION FIRE_TRIGGERS='OFF' option and found
it
> is
> > only for Triggers and not for Referential Integrity (like primary and
> > foreign key )
> > You help in this is highly appreciated
> >
> > Thanks in advance
> >
> > Surender
> >
> >
>
>