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.

how to extract DBA Tables as insert into SQL statments to write this data in other database ?

4 posts in General Discussion Last posting was on 2004-03-09 18:54:06.0Z
Matani Posted on 2004-03-09 11:57:27.0Z
Reply-To: "Matani" <S.Matani@ads-tec.de>
From: "Matani" <S.Matani@ads-tec.de>
Newsgroups: ianywhere.public.general
Subject: how to extract DBA Tables as insert into SQL statments to write this data in other database ?
Lines: 13
Organization: *
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
NNTP-Posting-Host: gabriel.le1.ads-tec.de
X-Original-NNTP-Posting-Host: gabriel.le1.ads-tec.de
Message-ID: <404db127@forums-1-dub>
Date: 9 Mar 2004 03:57:27 -0800
X-Trace: forums-1-dub 1078833447 62.153.239.43 (9 Mar 2004 03:57:27 -0800)
X-Original-Trace: 9 Mar 2004 03:57:27 -0800, gabriel.le1.ads-tec.de
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2744
Article PK: 6214

i am using Sybase SQL Anywhere 7.0.1 and need to export a data from database
into an SQL insert into String to import this data to other Database with
the same Structure (empty)

it will be realy helpfull when the export dose not incleude the PK because i
use to import the result into a Database witch has GLOBAL autoincrement with
10000000 partition!

Thanx

Matani


David Fishburn Posted on 2004-03-09 14:24:03.0Z
Newsgroups: ianywhere.public.general
Subject: Re: how to extract DBA Tables as insert into SQL statments to write this data in other database ?
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <404db127@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns94A75F4CCF6B8fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/06.08.25
X-Original-NNTP-Posting-Host: fishburn-t30.sybase.com
X-Original-Trace: 9 Mar 2004 06:25:04 -0800, fishburn-t30.sybase.com
Lines: 37
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Mar 2004 06:22:09 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Mar 2004 06:24:03 -0800
X-Trace: forums-1-dub 1078842243 10.22.108.75 (9 Mar 2004 06:24:03 -0800)
X-Original-Trace: 9 Mar 2004 06:24:03 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2747
Article PK: 6220

"Matani" <S.Matani@ads-tec.de> wrote in news:404db127@forums-1-dub:

M> i am using Sybase SQL Anywhere 7.0.1 and need to export a data from
M> database into an SQL insert into String to import this data to other
M> Database with the same Structure (empty)
M>
M> it will be realy helpfull when the export dose not incleude the PK
M> because i use to import the result into a Database witch has GLOBAL
M> autoincrement with 10000000 partition!

Write a select statement that excludes the PK column and execute it in
DBISQL.
Use the OUTPUT statement to write the results to a file.
Then use the INPUT statement (again excluding the PK column, in the list
of columns) to read in the file.
This will default the Global autoincrement column.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList


Matani Posted on 2004-03-09 16:45:06.0Z
Reply-To: "Matani" <S.Matani@ads-tec.de>
From: "Matani" <saleh@matani.net>
Newsgroups: ianywhere.public.general
References: <404db127@forums-1-dub> <Xns94A75F4CCF6B8fishburnsybasecom@10.22.241.106>
Subject: Re: how to extract DBA Tables as insert into SQL statments to write this data in other database ?
Lines: 49
Organization: *
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: gabriel.le1.ads-tec.de
X-Original-NNTP-Posting-Host: gabriel.le1.ads-tec.de
Message-ID: <404df492@forums-1-dub>
Date: 9 Mar 2004 08:45:06 -0800
X-Trace: forums-1-dub 1078850706 62.153.239.43 (9 Mar 2004 08:45:06 -0800)
X-Original-Trace: 9 Mar 2004 08:45:06 -0800, gabriel.le1.ads-tec.de
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2754
Article PK: 6225

thanx David , it works ,
but i would like to ask if there is away to do this a batch file? or you
think its not easy!

thanx

Matani

"David Fishburn" <fishburn_spam_off@ianywhere.com> schrieb im Newsbeitrag
news:Xns94A75F4CCF6B8fishburnsybasecom@10.22.241.106...

> "Matani" <S.Matani@ads-tec.de> wrote in news:404db127@forums-1-dub:
>
> M> i am using Sybase SQL Anywhere 7.0.1 and need to export a data from
> M> database into an SQL insert into String to import this data to other
> M> Database with the same Structure (empty)
> M>
> M> it will be realy helpfull when the export dose not incleude the PK
> M> because i use to import the result into a Database witch has GLOBAL
> M> autoincrement with 10000000 partition!
>
> Write a select statement that excludes the PK column and execute it in
> DBISQL.
> Use the OUTPUT statement to write the results to a file.
> Then use the INPUT statement (again excluding the PK column, in the list
> of columns) to read in the file.
> This will default the Global autoincrement column.
> --
> David Fishburn
> Certified ASA Developer Version 8
> iAnywhere Solutions - Sybase
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD number with
> EACH post (dbeng9 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/swx/sdmain.stm
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> CaseXpress - to report bugs
> http://casexpress.sybase.com
>
> CodeXchange - Free samples
> http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList
>


David Fishburn Posted on 2004-03-09 18:54:06.0Z
Newsgroups: ianywhere.public.general
Subject: Re: how to extract DBA Tables as insert into SQL statments to write this data in other database ?
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <404db127@forums-1-dub> <Xns94A75F4CCF6B8fishburnsybasecom@10.22.241.106> <404df492@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns94A78D18498D9fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/06.08.25
NNTP-Posting-Host: 172.31.140.135
X-Original-NNTP-Posting-Host: 172.31.140.135
Date: 9 Mar 2004 10:54:06 -0800
X-Trace: forums-1-dub 1078858446 172.31.140.135 (9 Mar 2004 10:54:06 -0800)
X-Original-Trace: 9 Mar 2004 10:54:06 -0800, 172.31.140.135
Lines: 9
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2756
Article PK: 6227

"Matani" <saleh@matani.net> wrote in news:404df492@forums-1-dub:

M> but i would like to ask if there is away to do this a batch file? or you
M> think its not easy!

Well you know the steps, just put those into a batch file.

--
David Fishburn