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.

Identity_insert attribute on?

2 posts in PB Infomaker Report Writer Last posting was on 1998-07-09 14:17:36.0Z
Linda McDonald Posted on 1998-07-09 13:34:11.0Z
Newsgroups: sybase.public.infomaker.general
Date: Thu, 09 Jul 1998 09:34:11 -0400
From: Linda McDonald <lmcdonald@bnisolutions.com>
Organization: Broadband Networks, Inc.
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Identity_insert attribute on?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 6
Message-ID: <348_35A4C6D3.7E11F8DD@bnisolutions.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7007
Article PK: 243037

I am trying to pipe data from several tables with pk's that are identity
data types. Can someone please give me the syntax to set identity
insert to 'on' in SQL Advantage? Thanks.
Linda McDonald


Linda McDonald Posted on 1998-07-09 14:17:36.0Z
Newsgroups: sybase.public.infomaker.general
Date: Thu, 09 Jul 1998 10:17:36 -0400
From: Linda McDonald <lmcdonald@bnisolutions.com>
Organization: Broadband Networks, Inc.
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Identity_insert attribute on? REPOST
Content-Type: multipart/mixed; boundary="------------542EF62A730F97EF7A59A548"
Lines: 36
Message-ID: <348_35A4D100.AEBC6461@bnisolutions.com>
References: <348_35A4C6D3.7E11F8DD@bnisolutions.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7006
Article PK: 243036

I found the syntax and ran it in SQL Advantage. However, I still get the
following error in IM:
SQLSTATE = S1000[INTERSOLV][ODBCSQL Server driver][SQL Server] Explicit
value specified for identity field in table when Identity_insert is set to
off.

Can someone point me in the right direction?

Linda

Linda McDonald wrote:

> I am trying to pipe data from several tables with pk's that are identity
> data types. Can someone please give me the syntax to set identity
> insert to 'on' in SQL Advantage? Thanks.
> Linda McDonald


Download VCard vcard.vcf