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.

Insert data from abother table which is in diffrent database....

12 posts in General Discussion Last posting was on 2004-02-17 15:30:22.0Z
Chandresh Patel Posted on 2004-02-13 22:49:22.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
Subject: Insert data from abother table which is in diffrent database....
Lines: 20
Organization: Shreeji Smart Solution
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
X-Original-NNTP-Posting-Host: acac95fd.ipt.aol.com
Message-ID: <402d570a@forums-2-dub>
X-Original-Trace: 13 Feb 2004 15:00:26 -0800, acac95fd.ipt.aol.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 13 Feb 2004 14:31:11 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 13 Feb 2004 14:49:22 -0800
X-Trace: forums-1-dub 1076712562 10.22.108.75 (13 Feb 2004 14:49:22 -0800)
X-Original-Trace: 13 Feb 2004 14:49:22 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2499
Article PK: 5637

Hi,

I have two table ONE is in Network server and SECOND is locally.

ONE.sales (this is in network server)
SECOND.sales (this is in locally)

Now, I want to copy all data from ONE.sales table To SECOND.sales table
using one insert query.

Both database is connected and I have both DSN. Help me how to copy all data
from server to locally.

How can we use INSERT STATEMENTS

Yes, this solution may be very very helpfule me.

Thanks in Advance.


Breck Carter [TeamSybase] Posted on 2004-02-13 23:00:51.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Insert data from abother table which is in diffrent database....
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com>
References: <402d570a@forums-2-dub>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 13 Feb 2004 15:11:55 -0800, bcarter.sentex.ca
Lines: 39
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 13 Feb 2004 14:42:39 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 13 Feb 2004 15:00:51 -0800
X-Trace: forums-1-dub 1076713251 10.22.108.75 (13 Feb 2004 15:00:51 -0800)
X-Original-Trace: 13 Feb 2004 15:00:51 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2500
Article PK: 5633

You can do it with a proxy table and an INSERT x SELECT * FROM y
statement. See the Help:

=====
ASA SQL User's Guide
Accessing Remote Data
=====

Breck

On 13 Feb 2004 14:49:22 -0800, "Chandresh Patel" <bapashree@yahoo.com>

wrote:

>Hi,
>
>I have two table ONE is in Network server and SECOND is locally.
>
>ONE.sales (this is in network server)
>SECOND.sales (this is in locally)
>
>Now, I want to copy all data from ONE.sales table To SECOND.sales table
>using one insert query.
>
>Both database is connected and I have both DSN. Help me how to copy all data
>from server to locally.
>
>How can we use INSERT STATEMENTS
>
>Yes, this solution may be very very helpfule me.
>
>Thanks in Advance.
>

--
SQL Anywhere Studio 9 Developer's Guide
ISBN 1-55622-506-7
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com


Chandresh Patel Posted on 2004-02-13 23:22:54.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
References: <402d570a@forums-2-dub> <vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com>
Subject: Re: Insert data from abother table which is in diffrent database....
Lines: 67
Organization: Shreeji Smart Solution
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: acac95fd.ipt.aol.com
X-Original-NNTP-Posting-Host: acac95fd.ipt.aol.com
Message-ID: <402d5c4e@forums-1-dub>
Date: 13 Feb 2004 15:22:54 -0800
X-Trace: forums-1-dub 1076714574 172.172.149.253 (13 Feb 2004 15:22:54 -0800)
X-Original-Trace: 13 Feb 2004 15:22:54 -0800, acac95fd.ipt.aol.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2501
Article PK: 5638

Hi,

I try to INSERT data but i can't

Tell me which connection i have to use because one database is in my local
machine and second is server so how do I do this.

Connect local database and run INSERT statement OR connect server and run
INSERT statement and what is exactlly syntex of it....

I read document but I can't understand it.

Thanks in Advance

"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com...
> You can do it with a proxy table and an INSERT x SELECT * FROM y
> statement. See the Help:
>
> =====
> ASA SQL User's Guide
> Accessing Remote Data
> =====
>
> Breck
>
> On 13 Feb 2004 14:49:22 -0800, "Chandresh Patel" <bapashree@yahoo.com>
> wrote:
>
> >Hi,
> >
> >I have two table ONE is in Network server and SECOND is locally.
> >
> >ONE.sales (this is in network server)
> >SECOND.sales (this is in locally)
> >
> >Now, I want to copy all data from ONE.sales table To SECOND.sales table
> >using one insert query.
> >
> >Both database is connected and I have both DSN. Help me how to copy all
data
> >from server to locally.
> >
> >How can we use INSERT STATEMENTS
> >
> >Yes, this solution may be very very helpfule me.
> >
> >Thanks in Advance.
> >
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> ISBN 1-55622-506-7
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> www.risingroad.com


Chandresh Patel Posted on 2004-02-13 23:43:20.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
References: <402d570a@forums-2-dub> <vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com>
Subject: HERE IS THE EXACT PROBLEM
Lines: 78
Organization: Shreeji Smart Solution
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: acac95fd.ipt.aol.com
X-Original-NNTP-Posting-Host: acac95fd.ipt.aol.com
Message-ID: <402d6118@forums-1-dub>
Date: 13 Feb 2004 15:43:20 -0800
X-Trace: forums-1-dub 1076715800 172.172.149.253 (13 Feb 2004 15:43:20 -0800)
X-Original-Trace: 13 Feb 2004 15:43:20 -0800, acac95fd.ipt.aol.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2502
Article PK: 5641

Hi,

I have database called "test.db" and it located on web TCPIP
I am use this table throubh ODBC passing TCPIP address

I have one local database name "temp.db" and it has already table sales
(empty)


Now I want to INSERT all sales data from "test.db" to sales in "temp.db"


My question is how to use insert statement and how about two connection and
so on.....

I read all document but it didn't work so please provide me syntax to do
this.


Thanks in advance.

"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com...
> You can do it with a proxy table and an INSERT x SELECT * FROM y
> statement. See the Help:
>
> =====
> ASA SQL User's Guide
> Accessing Remote Data
> =====
>
> Breck
>
> On 13 Feb 2004 14:49:22 -0800, "Chandresh Patel" <bapashree@yahoo.com>
> wrote:
>
> >Hi,
> >
> >I have two table ONE is in Network server and SECOND is locally.
> >
> >ONE.sales (this is in network server)
> >SECOND.sales (this is in locally)
> >
> >Now, I want to copy all data from ONE.sales table To SECOND.sales table
> >using one insert query.
> >
> >Both database is connected and I have both DSN. Help me how to copy all
data
> >from server to locally.
> >
> >How can we use INSERT STATEMENTS
> >
> >Yes, this solution may be very very helpfule me.
> >
> >Thanks in Advance.
> >
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> ISBN 1-55622-506-7
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> www.risingroad.com


"Michael Gould" <mgould Posted on 2004-02-14 14:31:42.0Z
From: "Michael Gould" <mgould@*I*h*a*t*e*s**p$a*m*omnicc.com>
Newsgroups: ianywhere.public.general
References: <402d570a@forums-2-dub> <vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com> <402d6118@forums-1-dub>
Subject: Re: HERE IS THE EXACT PROBLEM
Lines: 88
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.1106
X-Original-NNTP-Posting-Host: www.freight-aid.com
Message-ID: <402e33e9$1@forums-2-dub>
X-Original-Trace: 14 Feb 2004 06:42:49 -0800, www.freight-aid.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 14 Feb 2004 06:13:27 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 14 Feb 2004 06:31:42 -0800
X-Trace: forums-1-dub 1076769102 10.22.108.75 (14 Feb 2004 06:31:42 -0800)
X-Original-Trace: 14 Feb 2004 06:31:42 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2503
Article PK: 5640

Why not just take a look at using ASA's replication processing? This
sounds exactly what you want to do.

Michael Gould

"Chandresh Patel" <bapashree@yahoo.com> wrote in message
news:402d6118@forums-1-dub...
> Hi,
>
> I have database called "test.db" and it located on web TCPIP
> I am use this table throubh ODBC passing TCPIP address
>
> I have one local database name "temp.db" and it has already table sales
> (empty)
>
>
> Now I want to INSERT all sales data from "test.db" to sales in "temp.db"
>
>
> My question is how to use insert statement and how about two connection
and
> so on.....
>
> I read all document but it didn't work so please provide me syntax to do
> this.
>
>
> Thanks in advance.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
> message news:vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com...
> > You can do it with a proxy table and an INSERT x SELECT * FROM y
> > statement. See the Help:
> >
> > =====
> > ASA SQL User's Guide
> > Accessing Remote Data
> > =====
> >
> > Breck
> >
> > On 13 Feb 2004 14:49:22 -0800, "Chandresh Patel" <bapashree@yahoo.com>
> > wrote:
> >
> > >Hi,
> > >
> > >I have two table ONE is in Network server and SECOND is locally.
> > >
> > >ONE.sales (this is in network server)
> > >SECOND.sales (this is in locally)
> > >
> > >Now, I want to copy all data from ONE.sales table To SECOND.sales table
> > >using one insert query.
> > >
> > >Both database is connected and I have both DSN. Help me how to copy all
> data
> > >from server to locally.
> > >
> > >How can we use INSERT STATEMENTS
> > >
> > >Yes, this solution may be very very helpfule me.
> > >
> > >Thanks in Advance.
> > >
> >
> > --
> > SQL Anywhere Studio 9 Developer's Guide
> > ISBN 1-55622-506-7
> > bcarter@risingroad.com
> > Mobile and Distributed Enterprise Database Applications
> > www.risingroad.com
>
>


Breck Carter [TeamSybase] Posted on 2004-02-14 15:17:56.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: HERE IS THE EXACT PROBLEM
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <irds20t29r9hk48osanspotkgeri1ps9f7@4ax.com>
References: <402d570a@forums-2-dub> <vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com> <402d6118@forums-1-dub>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 14 Feb 2004 07:17:56 -0800
X-Trace: forums-1-dub 1076771876 64.7.134.118 (14 Feb 2004 07:17:56 -0800)
X-Original-Trace: 14 Feb 2004 07:17:56 -0800, bcarter.sentex.ca
Lines: 138
X-Authenticated-User: TeamPS
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2504
Article PK: 5643

Here is a short excerpt from Section 1.38 CREATE EXISTING TABLE in
Chapter 1, Creating, from SQL Anywhere Studio 9 Developer's Guide ISBN
1-55622-506-7 Wordware Publishing to be published soon:

=====
Here is a full, end-to-end example using two SQL Anywhere 9 databases;
the first database is the remote database and the second database
contains the proxy tables. On the first database a global permanent
table t1 is created:

CREATE TABLE t1 (
pkey INTEGER NOT NULL,
c1 VARCHAR ( 20 ) NOT NULL,
PRIMARY KEY ( pkey ) );

INSERT INTO t1 VALUES ( 1, 'Hello, World' );
COMMIT;

On the second database the following commands create the server,
external login and two proxy tables. The first proxy table t1proxy
points to the existing table t1, and the second proxy table t2proxy
causes a new table t2 to be created on the remote database:

CREATE SERVER other CLASS 'ASAODBC' USING 'otherdsn';

CREATE EXTERNLOGIN DBA TO other
REMOTE LOGIN DBA IDENTIFIED BY "SQL";

CREATE EXISTING TABLE t1proxy AT 'other;otherdb;dba;t1';

SELECT * FROM t1proxy; -- displays 'Hello, World'

CREATE TABLE t2proxy (
pkey INTEGER NOT NULL,
c1 VARCHAR ( 20 ) NOT NULL,
PRIMARY KEY ( pkey ) )
AT 'other;otherdb;dba;t2';

INSERT INTO t2proxy VALUES ( 1, 'Goodbye' );

SELECT * FROM t2proxy; -- displays 'Goodbye'
=====

You can copy rows using a statement like this:

INSERT local_table
SELECT *
FROM proxy_table;

Breck

On 13 Feb 2004 15:43:20 -0800, "Chandresh Patel" <bapashree@yahoo.com>

wrote:

>Hi,
>
>I have database called "test.db" and it located on web TCPIP
>I am use this table throubh ODBC passing TCPIP address
>
>I have one local database name "temp.db" and it has already table sales
>(empty)
>
>
>Now I want to INSERT all sales data from "test.db" to sales in "temp.db"
>
>
>My question is how to use insert statement and how about two connection and
>so on.....
>
>I read all document but it didn't work so please provide me syntax to do
>this.
>
>
>Thanks in advance.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
>message news:vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com...
>> You can do it with a proxy table and an INSERT x SELECT * FROM y
>> statement. See the Help:
>>
>> =====
>> ASA SQL User's Guide
>> Accessing Remote Data
>> =====
>>
>> Breck
>>
>> On 13 Feb 2004 14:49:22 -0800, "Chandresh Patel" <bapashree@yahoo.com>
>> wrote:
>>
>> >Hi,
>> >
>> >I have two table ONE is in Network server and SECOND is locally.
>> >
>> >ONE.sales (this is in network server)
>> >SECOND.sales (this is in locally)
>> >
>> >Now, I want to copy all data from ONE.sales table To SECOND.sales table
>> >using one insert query.
>> >
>> >Both database is connected and I have both DSN. Help me how to copy all
>data
>> >from server to locally.
>> >
>> >How can we use INSERT STATEMENTS
>> >
>> >Yes, this solution may be very very helpfule me.
>> >
>> >Thanks in Advance.
>> >
>>
>> --
>> SQL Anywhere Studio 9 Developer's Guide
>> ISBN 1-55622-506-7
>> bcarter@risingroad.com
>> Mobile and Distributed Enterprise Database Applications
>> www.risingroad.com
>

--
SQL Anywhere Studio 9 Developer's Guide
ISBN 1-55622-506-7
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com


Chandresh Patel Posted on 2004-02-14 19:46:00.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
References: <402d570a@forums-2-dub> <vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com> <402d6118@forums-1-dub> <irds20t29r9hk48osanspotkgeri1ps9f7@4ax.com>
Subject: Re: HERE IS THE EXACT PROBLEM
Lines: 165
Organization: Shreeji Smart Solution
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: acc82bd3.ipt.aol.com
X-Original-NNTP-Posting-Host: acc82bd3.ipt.aol.com
Message-ID: <402e7af8@forums-1-dub>
Date: 14 Feb 2004 11:46:00 -0800
X-Trace: forums-1-dub 1076787960 172.200.43.211 (14 Feb 2004 11:46:00 -0800)
X-Original-Trace: 14 Feb 2004 11:46:00 -0800, acc82bd3.ipt.aol.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2505
Article PK: 5642

Hi,

You did a good job and very helpful code. My question is
Is there anyway to copy all data from server table to local table without
using Proxy table because in my application I want to transfer all data from
server to local table and then run report so it useses local data and my
speed proble is solved.

So let me know if you are any idea to copy or transfer all server data to
local data.

"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:irds20t29r9hk48osanspotkgeri1ps9f7@4ax.com...
> Here is a short excerpt from Section 1.38 CREATE EXISTING TABLE in
> Chapter 1, Creating, from SQL Anywhere Studio 9 Developer's Guide ISBN
> 1-55622-506-7 Wordware Publishing to be published soon:
>
> =====
> Here is a full, end-to-end example using two SQL Anywhere 9 databases;
> the first database is the remote database and the second database
> contains the proxy tables. On the first database a global permanent
> table t1 is created:
>
> CREATE TABLE t1 (
> pkey INTEGER NOT NULL,
> c1 VARCHAR ( 20 ) NOT NULL,
> PRIMARY KEY ( pkey ) );
>
> INSERT INTO t1 VALUES ( 1, 'Hello, World' );
> COMMIT;
>
> On the second database the following commands create the server,
> external login and two proxy tables. The first proxy table t1proxy
> points to the existing table t1, and the second proxy table t2proxy
> causes a new table t2 to be created on the remote database:
>
> CREATE SERVER other CLASS 'ASAODBC' USING 'otherdsn';
>
> CREATE EXTERNLOGIN DBA TO other
> REMOTE LOGIN DBA IDENTIFIED BY "SQL";
>
> CREATE EXISTING TABLE t1proxy AT 'other;otherdb;dba;t1';
>
> SELECT * FROM t1proxy; -- displays 'Hello, World'
>
> CREATE TABLE t2proxy (
> pkey INTEGER NOT NULL,
> c1 VARCHAR ( 20 ) NOT NULL,
> PRIMARY KEY ( pkey ) )
> AT 'other;otherdb;dba;t2';
>
> INSERT INTO t2proxy VALUES ( 1, 'Goodbye' );
>
> SELECT * FROM t2proxy; -- displays 'Goodbye'
> =====
>
> You can copy rows using a statement like this:
>
> INSERT local_table
> SELECT *
> FROM proxy_table;
>
> Breck
>
> On 13 Feb 2004 15:43:20 -0800, "Chandresh Patel" <bapashree@yahoo.com>
> wrote:
>
> >Hi,
> >
> >I have database called "test.db" and it located on web TCPIP
> >I am use this table throubh ODBC passing TCPIP address
> >
> >I have one local database name "temp.db" and it has already table sales
> >(empty)
> >
> >
> >Now I want to INSERT all sales data from "test.db" to sales in "temp.db"
> >
> >
> >My question is how to use insert statement and how about two connection
and
> >so on.....
> >
> >I read all document but it didn't work so please provide me syntax to do
> >this.
> >
> >
> >Thanks in advance.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
> >message news:vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com...
> >> You can do it with a proxy table and an INSERT x SELECT * FROM y
> >> statement. See the Help:
> >>
> >> =====
> >> ASA SQL User's Guide
> >> Accessing Remote Data
> >> =====
> >>
> >> Breck
> >>
> >> On 13 Feb 2004 14:49:22 -0800, "Chandresh Patel" <bapashree@yahoo.com>
> >> wrote:
> >>
> >> >Hi,
> >> >
> >> >I have two table ONE is in Network server and SECOND is locally.
> >> >
> >> >ONE.sales (this is in network server)
> >> >SECOND.sales (this is in locally)
> >> >
> >> >Now, I want to copy all data from ONE.sales table To SECOND.sales
table
> >> >using one insert query.
> >> >
> >> >Both database is connected and I have both DSN. Help me how to copy
all
> >data
> >> >from server to locally.
> >> >
> >> >How can we use INSERT STATEMENTS
> >> >
> >> >Yes, this solution may be very very helpfule me.
> >> >
> >> >Thanks in Advance.
> >> >
> >>
> >> --
> >> SQL Anywhere Studio 9 Developer's Guide
> >> ISBN 1-55622-506-7
> >> bcarter@risingroad.com
> >> Mobile and Distributed Enterprise Database Applications
> >> www.risingroad.com
> >
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> ISBN 1-55622-506-7
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> www.risingroad.com


Chandresh Patel Posted on 2004-02-14 19:58:02.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
References: <402d570a@forums-2-dub> <vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com> <402d6118@forums-1-dub> <irds20t29r9hk48osanspotkgeri1ps9f7@4ax.com>
Subject: Re: IT TAKES MINUTES TO TRANSFER DATA
Lines: 162
Organization: Shreeji Smart Solution
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: acc82bd3.ipt.aol.com
X-Original-NNTP-Posting-Host: acc82bd3.ipt.aol.com
Message-ID: <402e7dca@forums-1-dub>
Date: 14 Feb 2004 11:58:02 -0800
X-Trace: forums-1-dub 1076788682 172.200.43.211 (14 Feb 2004 11:58:02 -0800)
X-Original-Trace: 14 Feb 2004 11:58:02 -0800, acc82bd3.ipt.aol.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2506
Article PK: 5644

Hi,

I alose try this proxt table and write one statement like

INSERT dActivity SELECT * from p_Activity

and this takes 3 minuts to transfer 7 column and 15000 record. I think this
is to much time for me. Do you have any idea to reduce this time.


Thanks in Advance

"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:irds20t29r9hk48osanspotkgeri1ps9f7@4ax.com...
> Here is a short excerpt from Section 1.38 CREATE EXISTING TABLE in
> Chapter 1, Creating, from SQL Anywhere Studio 9 Developer's Guide ISBN
> 1-55622-506-7 Wordware Publishing to be published soon:
>
> =====
> Here is a full, end-to-end example using two SQL Anywhere 9 databases;
> the first database is the remote database and the second database
> contains the proxy tables. On the first database a global permanent
> table t1 is created:
>
> CREATE TABLE t1 (
> pkey INTEGER NOT NULL,
> c1 VARCHAR ( 20 ) NOT NULL,
> PRIMARY KEY ( pkey ) );
>
> INSERT INTO t1 VALUES ( 1, 'Hello, World' );
> COMMIT;
>
> On the second database the following commands create the server,
> external login and two proxy tables. The first proxy table t1proxy
> points to the existing table t1, and the second proxy table t2proxy
> causes a new table t2 to be created on the remote database:
>
> CREATE SERVER other CLASS 'ASAODBC' USING 'otherdsn';
>
> CREATE EXTERNLOGIN DBA TO other
> REMOTE LOGIN DBA IDENTIFIED BY "SQL";
>
> CREATE EXISTING TABLE t1proxy AT 'other;otherdb;dba;t1';
>
> SELECT * FROM t1proxy; -- displays 'Hello, World'
>
> CREATE TABLE t2proxy (
> pkey INTEGER NOT NULL,
> c1 VARCHAR ( 20 ) NOT NULL,
> PRIMARY KEY ( pkey ) )
> AT 'other;otherdb;dba;t2';
>
> INSERT INTO t2proxy VALUES ( 1, 'Goodbye' );
>
> SELECT * FROM t2proxy; -- displays 'Goodbye'
> =====
>
> You can copy rows using a statement like this:
>
> INSERT local_table
> SELECT *
> FROM proxy_table;
>
> Breck
>
> On 13 Feb 2004 15:43:20 -0800, "Chandresh Patel" <bapashree@yahoo.com>
> wrote:
>
> >Hi,
> >
> >I have database called "test.db" and it located on web TCPIP
> >I am use this table throubh ODBC passing TCPIP address
> >
> >I have one local database name "temp.db" and it has already table sales
> >(empty)
> >
> >
> >Now I want to INSERT all sales data from "test.db" to sales in "temp.db"
> >
> >
> >My question is how to use insert statement and how about two connection
and
> >so on.....
> >
> >I read all document but it didn't work so please provide me syntax to do
> >this.
> >
> >
> >Thanks in advance.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
> >message news:vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com...
> >> You can do it with a proxy table and an INSERT x SELECT * FROM y
> >> statement. See the Help:
> >>
> >> =====
> >> ASA SQL User's Guide
> >> Accessing Remote Data
> >> =====
> >>
> >> Breck
> >>
> >> On 13 Feb 2004 14:49:22 -0800, "Chandresh Patel" <bapashree@yahoo.com>
> >> wrote:
> >>
> >> >Hi,
> >> >
> >> >I have two table ONE is in Network server and SECOND is locally.
> >> >
> >> >ONE.sales (this is in network server)
> >> >SECOND.sales (this is in locally)
> >> >
> >> >Now, I want to copy all data from ONE.sales table To SECOND.sales
table
> >> >using one insert query.
> >> >
> >> >Both database is connected and I have both DSN. Help me how to copy
all
> >data
> >> >from server to locally.
> >> >
> >> >How can we use INSERT STATEMENTS
> >> >
> >> >Yes, this solution may be very very helpfule me.
> >> >
> >> >Thanks in Advance.
> >> >
> >>
> >> --
> >> SQL Anywhere Studio 9 Developer's Guide
> >> ISBN 1-55622-506-7
> >> bcarter@risingroad.com
> >> Mobile and Distributed Enterprise Database Applications
> >> www.risingroad.com
> >
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> ISBN 1-55622-506-7
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> www.risingroad.com


Breck Carter [TeamSybase] Posted on 2004-02-15 15:22:29.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: IT TAKES MINUTES TO TRANSFER DATA
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <9b2v2052n01p4qtdmnkdtfhp2n5rel691a@4ax.com>
References: <402d570a@forums-2-dub> <vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com> <402d6118@forums-1-dub> <irds20t29r9hk48osanspotkgeri1ps9f7@4ax.com> <402e7dca@forums-1-dub>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 15 Feb 2004 07:22:29 -0800
X-Trace: forums-1-dub 1076858549 64.7.134.118 (15 Feb 2004 07:22:29 -0800)
X-Original-Trace: 15 Feb 2004 07:22:29 -0800, bcarter.sentex.ca
Lines: 184
X-Authenticated-User: TeamPS
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2507
Article PK: 5645

Make separate client connections to each database. Run UNLOAD TABLE on
one connection, LOAD TABLE on the other. One of the two commands may
have to refer to the file as it exists on the other computer using the
UNC naming convention since the UNLOAD and LOAD file specifications
are relative to the machine running the server, not the client. Or,
you could have an intermediate step to transfer the file via FTP or
some other mechanism.

UNLOAD and LOAD are very fast. Proxy tables often are not.

Breck


On 14 Feb 2004 11:58:02 -0800, "Chandresh Patel" <bapashree@yahoo.com>

wrote:

>Hi,
>
>I alose try this proxt table and write one statement like
>
>INSERT dActivity SELECT * from p_Activity
>
>and this takes 3 minuts to transfer 7 column and 15000 record. I think this
>is to much time for me. Do you have any idea to reduce this time.
>
>
>Thanks in Advance
>
>
>
>
>
>
>"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
>message news:irds20t29r9hk48osanspotkgeri1ps9f7@4ax.com...
>> Here is a short excerpt from Section 1.38 CREATE EXISTING TABLE in
>> Chapter 1, Creating, from SQL Anywhere Studio 9 Developer's Guide ISBN
>> 1-55622-506-7 Wordware Publishing to be published soon:
>>
>> =====
>> Here is a full, end-to-end example using two SQL Anywhere 9 databases;
>> the first database is the remote database and the second database
>> contains the proxy tables. On the first database a global permanent
>> table t1 is created:
>>
>> CREATE TABLE t1 (
>> pkey INTEGER NOT NULL,
>> c1 VARCHAR ( 20 ) NOT NULL,
>> PRIMARY KEY ( pkey ) );
>>
>> INSERT INTO t1 VALUES ( 1, 'Hello, World' );
>> COMMIT;
>>
>> On the second database the following commands create the server,
>> external login and two proxy tables. The first proxy table t1proxy
>> points to the existing table t1, and the second proxy table t2proxy
>> causes a new table t2 to be created on the remote database:
>>
>> CREATE SERVER other CLASS 'ASAODBC' USING 'otherdsn';
>>
>> CREATE EXTERNLOGIN DBA TO other
>> REMOTE LOGIN DBA IDENTIFIED BY "SQL";
>>
>> CREATE EXISTING TABLE t1proxy AT 'other;otherdb;dba;t1';
>>
>> SELECT * FROM t1proxy; -- displays 'Hello, World'
>>
>> CREATE TABLE t2proxy (
>> pkey INTEGER NOT NULL,
>> c1 VARCHAR ( 20 ) NOT NULL,
>> PRIMARY KEY ( pkey ) )
>> AT 'other;otherdb;dba;t2';
>>
>> INSERT INTO t2proxy VALUES ( 1, 'Goodbye' );
>>
>> SELECT * FROM t2proxy; -- displays 'Goodbye'
>> =====
>>
>> You can copy rows using a statement like this:
>>
>> INSERT local_table
>> SELECT *
>> FROM proxy_table;
>>
>> Breck
>>
>> On 13 Feb 2004 15:43:20 -0800, "Chandresh Patel" <bapashree@yahoo.com>
>> wrote:
>>
>> >Hi,
>> >
>> >I have database called "test.db" and it located on web TCPIP
>> >I am use this table throubh ODBC passing TCPIP address
>> >
>> >I have one local database name "temp.db" and it has already table sales
>> >(empty)
>> >
>> >
>> >Now I want to INSERT all sales data from "test.db" to sales in "temp.db"
>> >
>> >
>> >My question is how to use insert statement and how about two connection
>and
>> >so on.....
>> >
>> >I read all document but it didn't work so please provide me syntax to do
>> >this.
>> >
>> >
>> >Thanks in advance.
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
>> >message news:vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com...
>> >> You can do it with a proxy table and an INSERT x SELECT * FROM y
>> >> statement. See the Help:
>> >>
>> >> =====
>> >> ASA SQL User's Guide
>> >> Accessing Remote Data
>> >> =====
>> >>
>> >> Breck
>> >>
>> >> On 13 Feb 2004 14:49:22 -0800, "Chandresh Patel" <bapashree@yahoo.com>
>> >> wrote:
>> >>
>> >> >Hi,
>> >> >
>> >> >I have two table ONE is in Network server and SECOND is locally.
>> >> >
>> >> >ONE.sales (this is in network server)
>> >> >SECOND.sales (this is in locally)
>> >> >
>> >> >Now, I want to copy all data from ONE.sales table To SECOND.sales
>table
>> >> >using one insert query.
>> >> >
>> >> >Both database is connected and I have both DSN. Help me how to copy
>all
>> >data
>> >> >from server to locally.
>> >> >
>> >> >How can we use INSERT STATEMENTS
>> >> >
>> >> >Yes, this solution may be very very helpfule me.
>> >> >
>> >> >Thanks in Advance.
>> >> >
>> >>
>> >> --
>> >> SQL Anywhere Studio 9 Developer's Guide
>> >> ISBN 1-55622-506-7
>> >> bcarter@risingroad.com
>> >> Mobile and Distributed Enterprise Database Applications
>> >> www.risingroad.com
>> >
>>
>> --
>> SQL Anywhere Studio 9 Developer's Guide
>> ISBN 1-55622-506-7
>> bcarter@risingroad.com
>> Mobile and Distributed Enterprise Database Applications
>> www.risingroad.com
>

--
SQL Anywhere Studio 9 Developer's Guide
ISBN 1-55622-506-7
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com


Chandresh Patel Posted on 2004-02-17 05:13:47.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
References: <402d570a@forums-2-dub> <vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com> <402d6118@forums-1-dub> <irds20t29r9hk48osanspotkgeri1ps9f7@4ax.com> <402e7dca@forums-1-dub> <9b2v2052n01p4qtdmnkdtfhp2n5rel691a@4ax.com>
Subject: Re: IT TAKES MINUTES TO TRANSFER DATA
Lines: 209
Organization: Shreeji Smart Solution
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: ac83947f.ipt.aol.com
X-Original-NNTP-Posting-Host: ac83947f.ipt.aol.com
Message-ID: <4031a30b@forums-1-dub>
Date: 16 Feb 2004 21:13:47 -0800
X-Trace: forums-1-dub 1076994827 172.131.148.127 (16 Feb 2004 21:13:47 -0800)
X-Original-Trace: 16 Feb 2004 21:13:47 -0800, ac83947f.ipt.aol.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2527
Article PK: 5663

Thank you very much.

Amazingggggggggggggg!!! Wow... Thank you very much.


Now only one thing I have to ask you. Can I create locally few tables using
this database OR Ultra thing I dont know which is best for me.

Do i need licenses for that database. ( I have already 10 user copy)

"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:9b2v2052n01p4qtdmnkdtfhp2n5rel691a@4ax.com...
> Make separate client connections to each database. Run UNLOAD TABLE on
> one connection, LOAD TABLE on the other. One of the two commands may
> have to refer to the file as it exists on the other computer using the
> UNC naming convention since the UNLOAD and LOAD file specifications
> are relative to the machine running the server, not the client. Or,
> you could have an intermediate step to transfer the file via FTP or
> some other mechanism.
>
> UNLOAD and LOAD are very fast. Proxy tables often are not.
>
> Breck
>
>
> On 14 Feb 2004 11:58:02 -0800, "Chandresh Patel" <bapashree@yahoo.com>
> wrote:
>
> >Hi,
> >
> >I alose try this proxt table and write one statement like
> >
> >INSERT dActivity SELECT * from p_Activity
> >
> >and this takes 3 minuts to transfer 7 column and 15000 record. I think
this
> >is to much time for me. Do you have any idea to reduce this time.
> >
> >
> >Thanks in Advance
> >
> >
> >
> >
> >
> >
> >"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
> >message news:irds20t29r9hk48osanspotkgeri1ps9f7@4ax.com...
> >> Here is a short excerpt from Section 1.38 CREATE EXISTING TABLE in
> >> Chapter 1, Creating, from SQL Anywhere Studio 9 Developer's Guide ISBN
> >> 1-55622-506-7 Wordware Publishing to be published soon:
> >>
> >> =====
> >> Here is a full, end-to-end example using two SQL Anywhere 9 databases;
> >> the first database is the remote database and the second database
> >> contains the proxy tables. On the first database a global permanent
> >> table t1 is created:
> >>
> >> CREATE TABLE t1 (
> >> pkey INTEGER NOT NULL,
> >> c1 VARCHAR ( 20 ) NOT NULL,
> >> PRIMARY KEY ( pkey ) );
> >>
> >> INSERT INTO t1 VALUES ( 1, 'Hello, World' );
> >> COMMIT;
> >>
> >> On the second database the following commands create the server,
> >> external login and two proxy tables. The first proxy table t1proxy
> >> points to the existing table t1, and the second proxy table t2proxy
> >> causes a new table t2 to be created on the remote database:
> >>
> >> CREATE SERVER other CLASS 'ASAODBC' USING 'otherdsn';
> >>
> >> CREATE EXTERNLOGIN DBA TO other
> >> REMOTE LOGIN DBA IDENTIFIED BY "SQL";
> >>
> >> CREATE EXISTING TABLE t1proxy AT 'other;otherdb;dba;t1';
> >>
> >> SELECT * FROM t1proxy; -- displays 'Hello, World'
> >>
> >> CREATE TABLE t2proxy (
> >> pkey INTEGER NOT NULL,
> >> c1 VARCHAR ( 20 ) NOT NULL,
> >> PRIMARY KEY ( pkey ) )
> >> AT 'other;otherdb;dba;t2';
> >>
> >> INSERT INTO t2proxy VALUES ( 1, 'Goodbye' );
> >>
> >> SELECT * FROM t2proxy; -- displays 'Goodbye'
> >> =====
> >>
> >> You can copy rows using a statement like this:
> >>
> >> INSERT local_table
> >> SELECT *
> >> FROM proxy_table;
> >>
> >> Breck
> >>
> >> On 13 Feb 2004 15:43:20 -0800, "Chandresh Patel" <bapashree@yahoo.com>
> >> wrote:
> >>
> >> >Hi,
> >> >
> >> >I have database called "test.db" and it located on web TCPIP
> >> >I am use this table throubh ODBC passing TCPIP address
> >> >
> >> >I have one local database name "temp.db" and it has already table
sales
> >> >(empty)
> >> >
> >> >
> >> >Now I want to INSERT all sales data from "test.db" to sales in
"temp.db"
> >> >
> >> >
> >> >My question is how to use insert statement and how about two
connection
> >and
> >> >so on.....
> >> >
> >> >I read all document but it didn't work so please provide me syntax to
do
> >> >this.
> >> >
> >> >
> >> >Thanks in advance.
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
> >> >message news:vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com...
> >> >> You can do it with a proxy table and an INSERT x SELECT * FROM y
> >> >> statement. See the Help:
> >> >>
> >> >> =====
> >> >> ASA SQL User's Guide
> >> >> Accessing Remote Data
> >> >> =====
> >> >>
> >> >> Breck
> >> >>
> >> >> On 13 Feb 2004 14:49:22 -0800, "Chandresh Patel"
<bapashree@yahoo.com>
> >> >> wrote:
> >> >>
> >> >> >Hi,
> >> >> >
> >> >> >I have two table ONE is in Network server and SECOND is locally.
> >> >> >
> >> >> >ONE.sales (this is in network server)
> >> >> >SECOND.sales (this is in locally)
> >> >> >
> >> >> >Now, I want to copy all data from ONE.sales table To SECOND.sales
> >table
> >> >> >using one insert query.
> >> >> >
> >> >> >Both database is connected and I have both DSN. Help me how to copy
> >all
> >> >data
> >> >> >from server to locally.
> >> >> >
> >> >> >How can we use INSERT STATEMENTS
> >> >> >
> >> >> >Yes, this solution may be very very helpfule me.
> >> >> >
> >> >> >Thanks in Advance.
> >> >> >
> >> >>
> >> >> --
> >> >> SQL Anywhere Studio 9 Developer's Guide
> >> >> ISBN 1-55622-506-7
> >> >> bcarter@risingroad.com
> >> >> Mobile and Distributed Enterprise Database Applications
> >> >> www.risingroad.com
> >> >
> >>
> >> --
> >> SQL Anywhere Studio 9 Developer's Guide
> >> ISBN 1-55622-506-7
> >> bcarter@risingroad.com
> >> Mobile and Distributed Enterprise Database Applications
> >> www.risingroad.com
> >
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> ISBN 1-55622-506-7
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> www.risingroad.com


Robert Waywell Posted on 2004-02-17 14:09:38.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <402d570a@forums-2-dub> <vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com> <402d6118@forums-1-dub> <irds20t29r9hk48osanspotkgeri1ps9f7@4ax.com> <402e7dca@forums-1-dub> <9b2v2052n01p4qtdmnkdtfhp2n5rel691a@4ax.com> <4031a30b@forums-1-dub>
Subject: Re: IT TAKES MINUTES TO TRANSFER DATA
Lines: 245
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
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <40322348@forums-2-dub>
X-Original-Trace: 17 Feb 2004 06:20:56 -0800, rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Feb 2004 05:51:05 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Feb 2004 06:09:38 -0800
X-Trace: forums-1-dub 1077026978 10.22.108.75 (17 Feb 2004 06:09:38 -0800)
X-Original-Trace: 17 Feb 2004 06:09:38 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2529
Article PK: 5667

Yes the Personal Server is licensed separately from the network server.

--
-----------------------------------------------
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://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
ug

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

"Chandresh Patel" <bapashree@yahoo.com> wrote in message
news:4031a30b@forums-1-dub...
> Thank you very much.
>
> Amazingggggggggggggg!!! Wow... Thank you very much.
>
>
> Now only one thing I have to ask you. Can I create locally few tables
using
> this database OR Ultra thing I dont know which is best for me.
>
> Do i need licenses for that database. ( I have already 10 user copy)
>
>
>
>
>
>
> "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
> message news:9b2v2052n01p4qtdmnkdtfhp2n5rel691a@4ax.com...
> > Make separate client connections to each database. Run UNLOAD TABLE on
> > one connection, LOAD TABLE on the other. One of the two commands may
> > have to refer to the file as it exists on the other computer using the
> > UNC naming convention since the UNLOAD and LOAD file specifications
> > are relative to the machine running the server, not the client. Or,
> > you could have an intermediate step to transfer the file via FTP or
> > some other mechanism.
> >
> > UNLOAD and LOAD are very fast. Proxy tables often are not.
> >
> > Breck
> >
> >
> > On 14 Feb 2004 11:58:02 -0800, "Chandresh Patel" <bapashree@yahoo.com>
> > wrote:
> >
> > >Hi,
> > >
> > >I alose try this proxt table and write one statement like
> > >
> > >INSERT dActivity SELECT * from p_Activity
> > >
> > >and this takes 3 minuts to transfer 7 column and 15000 record. I think
> this
> > >is to much time for me. Do you have any idea to reduce this time.
> > >
> > >
> > >Thanks in Advance
> > >
> > >
> > >
> > >
> > >
> > >
> > >"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
> > >message news:irds20t29r9hk48osanspotkgeri1ps9f7@4ax.com...
> > >> Here is a short excerpt from Section 1.38 CREATE EXISTING TABLE in
> > >> Chapter 1, Creating, from SQL Anywhere Studio 9 Developer's Guide
ISBN
> > >> 1-55622-506-7 Wordware Publishing to be published soon:
> > >>
> > >> =====
> > >> Here is a full, end-to-end example using two SQL Anywhere 9
databases;
> > >> the first database is the remote database and the second database
> > >> contains the proxy tables. On the first database a global permanent
> > >> table t1 is created:
> > >>
> > >> CREATE TABLE t1 (
> > >> pkey INTEGER NOT NULL,
> > >> c1 VARCHAR ( 20 ) NOT NULL,
> > >> PRIMARY KEY ( pkey ) );
> > >>
> > >> INSERT INTO t1 VALUES ( 1, 'Hello, World' );
> > >> COMMIT;
> > >>
> > >> On the second database the following commands create the server,
> > >> external login and two proxy tables. The first proxy table t1proxy
> > >> points to the existing table t1, and the second proxy table t2proxy
> > >> causes a new table t2 to be created on the remote database:
> > >>
> > >> CREATE SERVER other CLASS 'ASAODBC' USING 'otherdsn';
> > >>
> > >> CREATE EXTERNLOGIN DBA TO other
> > >> REMOTE LOGIN DBA IDENTIFIED BY "SQL";
> > >>
> > >> CREATE EXISTING TABLE t1proxy AT 'other;otherdb;dba;t1';
> > >>
> > >> SELECT * FROM t1proxy; -- displays 'Hello, World'
> > >>
> > >> CREATE TABLE t2proxy (
> > >> pkey INTEGER NOT NULL,
> > >> c1 VARCHAR ( 20 ) NOT NULL,
> > >> PRIMARY KEY ( pkey ) )
> > >> AT 'other;otherdb;dba;t2';
> > >>
> > >> INSERT INTO t2proxy VALUES ( 1, 'Goodbye' );
> > >>
> > >> SELECT * FROM t2proxy; -- displays 'Goodbye'
> > >> =====
> > >>
> > >> You can copy rows using a statement like this:
> > >>
> > >> INSERT local_table
> > >> SELECT *
> > >> FROM proxy_table;
> > >>
> > >> Breck
> > >>
> > >> On 13 Feb 2004 15:43:20 -0800, "Chandresh Patel"
<bapashree@yahoo.com>
> > >> wrote:
> > >>
> > >> >Hi,
> > >> >
> > >> >I have database called "test.db" and it located on web TCPIP
> > >> >I am use this table throubh ODBC passing TCPIP address
> > >> >
> > >> >I have one local database name "temp.db" and it has already table
> sales
> > >> >(empty)
> > >> >
> > >> >
> > >> >Now I want to INSERT all sales data from "test.db" to sales in
> "temp.db"
> > >> >
> > >> >
> > >> >My question is how to use insert statement and how about two
> connection
> > >and
> > >> >so on.....
> > >> >
> > >> >I read all document but it didn't work so please provide me syntax
to
> do
> > >> >this.
> > >> >
> > >> >
> > >> >Thanks in advance.
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote
in
> > >> >message news:vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com...
> > >> >> You can do it with a proxy table and an INSERT x SELECT * FROM y
> > >> >> statement. See the Help:
> > >> >>
> > >> >> =====
> > >> >> ASA SQL User's Guide
> > >> >> Accessing Remote Data
> > >> >> =====
> > >> >>
> > >> >> Breck
> > >> >>
> > >> >> On 13 Feb 2004 14:49:22 -0800, "Chandresh Patel"
> <bapashree@yahoo.com>
> > >> >> wrote:
> > >> >>
> > >> >> >Hi,
> > >> >> >
> > >> >> >I have two table ONE is in Network server and SECOND is locally.
> > >> >> >
> > >> >> >ONE.sales (this is in network server)
> > >> >> >SECOND.sales (this is in locally)
> > >> >> >
> > >> >> >Now, I want to copy all data from ONE.sales table To SECOND.sales
> > >table
> > >> >> >using one insert query.
> > >> >> >
> > >> >> >Both database is connected and I have both DSN. Help me how to
copy
> > >all
> > >> >data
> > >> >> >from server to locally.
> > >> >> >
> > >> >> >How can we use INSERT STATEMENTS
> > >> >> >
> > >> >> >Yes, this solution may be very very helpfule me.
> > >> >> >
> > >> >> >Thanks in Advance.
> > >> >> >
> > >> >>
> > >> >> --
> > >> >> SQL Anywhere Studio 9 Developer's Guide
> > >> >> ISBN 1-55622-506-7
> > >> >> bcarter@risingroad.com
> > >> >> Mobile and Distributed Enterprise Database Applications
> > >> >> www.risingroad.com
> > >> >
> > >>
> > >> --
> > >> SQL Anywhere Studio 9 Developer's Guide
> > >> ISBN 1-55622-506-7
> > >> bcarter@risingroad.com
> > >> Mobile and Distributed Enterprise Database Applications
> > >> www.risingroad.com
> > >
> >
> > --
> > SQL Anywhere Studio 9 Developer's Guide
> > ISBN 1-55622-506-7
> > bcarter@risingroad.com
> > Mobile and Distributed Enterprise Database Applications
> > www.risingroad.com
>
>


Chandresh Patel Posted on 2004-02-17 15:30:22.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
References: <402d570a@forums-2-dub> <vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com> <402d6118@forums-1-dub> <irds20t29r9hk48osanspotkgeri1ps9f7@4ax.com> <402e7dca@forums-1-dub> <9b2v2052n01p4qtdmnkdtfhp2n5rel691a@4ax.com> <4031a30b@forums-1-dub> <40322348@forums-2-dub>
Subject: Re: IT TAKES MINUTES TO TRANSFER DATA
Lines: 260
Organization: Shreeji Smart Solution
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
X-Original-NNTP-Posting-Host: ac83dec6.ipt.aol.com
Message-ID: <40323634@forums-2-dub>
X-Original-Trace: 17 Feb 2004 07:41:40 -0800, ac83dec6.ipt.aol.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Feb 2004 07:11:48 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Feb 2004 07:30:22 -0800
X-Trace: forums-1-dub 1077031822 10.22.108.75 (17 Feb 2004 07:30:22 -0800)
X-Original-Trace: 17 Feb 2004 07:30:22 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2530
Article PK: 5668

Hi,

I am not talking about personal server but some individule database table in
local machine.

"Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
news:40322348@forums-2-dub...
> Yes the Personal Server is licensed separately from the network server.
>
> --
> -----------------------------------------------
> 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://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
> ug
>
> 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
>
> "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> news:4031a30b@forums-1-dub...
> > Thank you very much.
> >
> > Amazingggggggggggggg!!! Wow... Thank you very much.
> >
> >
> > Now only one thing I have to ask you. Can I create locally few tables
> using
> > this database OR Ultra thing I dont know which is best for me.
> >
> > Do i need licenses for that database. ( I have already 10 user copy)
> >
> >
> >
> >
> >
> >
> > "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
> > message news:9b2v2052n01p4qtdmnkdtfhp2n5rel691a@4ax.com...
> > > Make separate client connections to each database. Run UNLOAD TABLE on
> > > one connection, LOAD TABLE on the other. One of the two commands may
> > > have to refer to the file as it exists on the other computer using the
> > > UNC naming convention since the UNLOAD and LOAD file specifications
> > > are relative to the machine running the server, not the client. Or,
> > > you could have an intermediate step to transfer the file via FTP or
> > > some other mechanism.
> > >
> > > UNLOAD and LOAD are very fast. Proxy tables often are not.
> > >
> > > Breck
> > >
> > >
> > > On 14 Feb 2004 11:58:02 -0800, "Chandresh Patel" <bapashree@yahoo.com>
> > > wrote:
> > >
> > > >Hi,
> > > >
> > > >I alose try this proxt table and write one statement like
> > > >
> > > >INSERT dActivity SELECT * from p_Activity
> > > >
> > > >and this takes 3 minuts to transfer 7 column and 15000 record. I
think
> > this
> > > >is to much time for me. Do you have any idea to reduce this time.
> > > >
> > > >
> > > >Thanks in Advance
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
> > > >message news:irds20t29r9hk48osanspotkgeri1ps9f7@4ax.com...
> > > >> Here is a short excerpt from Section 1.38 CREATE EXISTING TABLE in
> > > >> Chapter 1, Creating, from SQL Anywhere Studio 9 Developer's Guide
> ISBN
> > > >> 1-55622-506-7 Wordware Publishing to be published soon:
> > > >>
> > > >> =====
> > > >> Here is a full, end-to-end example using two SQL Anywhere 9
> databases;
> > > >> the first database is the remote database and the second database
> > > >> contains the proxy tables. On the first database a global permanent
> > > >> table t1 is created:
> > > >>
> > > >> CREATE TABLE t1 (
> > > >> pkey INTEGER NOT NULL,
> > > >> c1 VARCHAR ( 20 ) NOT NULL,
> > > >> PRIMARY KEY ( pkey ) );
> > > >>
> > > >> INSERT INTO t1 VALUES ( 1, 'Hello, World' );
> > > >> COMMIT;
> > > >>
> > > >> On the second database the following commands create the server,
> > > >> external login and two proxy tables. The first proxy table t1proxy
> > > >> points to the existing table t1, and the second proxy table t2proxy
> > > >> causes a new table t2 to be created on the remote database:
> > > >>
> > > >> CREATE SERVER other CLASS 'ASAODBC' USING 'otherdsn';
> > > >>
> > > >> CREATE EXTERNLOGIN DBA TO other
> > > >> REMOTE LOGIN DBA IDENTIFIED BY "SQL";
> > > >>
> > > >> CREATE EXISTING TABLE t1proxy AT 'other;otherdb;dba;t1';
> > > >>
> > > >> SELECT * FROM t1proxy; -- displays 'Hello, World'
> > > >>
> > > >> CREATE TABLE t2proxy (
> > > >> pkey INTEGER NOT NULL,
> > > >> c1 VARCHAR ( 20 ) NOT NULL,
> > > >> PRIMARY KEY ( pkey ) )
> > > >> AT 'other;otherdb;dba;t2';
> > > >>
> > > >> INSERT INTO t2proxy VALUES ( 1, 'Goodbye' );
> > > >>
> > > >> SELECT * FROM t2proxy; -- displays 'Goodbye'
> > > >> =====
> > > >>
> > > >> You can copy rows using a statement like this:
> > > >>
> > > >> INSERT local_table
> > > >> SELECT *
> > > >> FROM proxy_table;
> > > >>
> > > >> Breck
> > > >>
> > > >> On 13 Feb 2004 15:43:20 -0800, "Chandresh Patel"
> <bapashree@yahoo.com>
> > > >> wrote:
> > > >>
> > > >> >Hi,
> > > >> >
> > > >> >I have database called "test.db" and it located on web TCPIP
> > > >> >I am use this table throubh ODBC passing TCPIP address
> > > >> >
> > > >> >I have one local database name "temp.db" and it has already table
> > sales
> > > >> >(empty)
> > > >> >
> > > >> >
> > > >> >Now I want to INSERT all sales data from "test.db" to sales in
> > "temp.db"
> > > >> >
> > > >> >
> > > >> >My question is how to use insert statement and how about two
> > connection
> > > >and
> > > >> >so on.....
> > > >> >
> > > >> >I read all document but it didn't work so please provide me syntax
> to
> > do
> > > >> >this.
> > > >> >
> > > >> >
> > > >> >Thanks in advance.
> > > >> >
> > > >> >
> > > >> >
> > > >> >
> > > >> >
> > > >> >
> > > >> >
> > > >> >
> > > >> >
> > > >> >
> > > >> >
> > > >> >
> > > >> >
> > > >> >
> > > >> >"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote
> in
> > > >> >message news:vjkq20l50u0ga5ff9j1ni2ua658gpflbr9@4ax.com...
> > > >> >> You can do it with a proxy table and an INSERT x SELECT * FROM y
> > > >> >> statement. See the Help:
> > > >> >>
> > > >> >> =====
> > > >> >> ASA SQL User's Guide
> > > >> >> Accessing Remote Data
> > > >> >> =====
> > > >> >>
> > > >> >> Breck
> > > >> >>
> > > >> >> On 13 Feb 2004 14:49:22 -0800, "Chandresh Patel"
> > <bapashree@yahoo.com>
> > > >> >> wrote:
> > > >> >>
> > > >> >> >Hi,
> > > >> >> >
> > > >> >> >I have two table ONE is in Network server and SECOND is
locally.
> > > >> >> >
> > > >> >> >ONE.sales (this is in network server)
> > > >> >> >SECOND.sales (this is in locally)
> > > >> >> >
> > > >> >> >Now, I want to copy all data from ONE.sales table To
SECOND.sales
> > > >table
> > > >> >> >using one insert query.
> > > >> >> >
> > > >> >> >Both database is connected and I have both DSN. Help me how to
> copy
> > > >all
> > > >> >data
> > > >> >> >from server to locally.
> > > >> >> >
> > > >> >> >How can we use INSERT STATEMENTS
> > > >> >> >
> > > >> >> >Yes, this solution may be very very helpfule me.
> > > >> >> >
> > > >> >> >Thanks in Advance.
> > > >> >> >
> > > >> >>
> > > >> >> --
> > > >> >> SQL Anywhere Studio 9 Developer's Guide
> > > >> >> ISBN 1-55622-506-7
> > > >> >> bcarter@risingroad.com
> > > >> >> Mobile and Distributed Enterprise Database Applications
> > > >> >> www.risingroad.com
> > > >> >
> > > >>
> > > >> --
> > > >> SQL Anywhere Studio 9 Developer's Guide
> > > >> ISBN 1-55622-506-7
> > > >> bcarter@risingroad.com
> > > >> Mobile and Distributed Enterprise Database Applications
> > > >> www.risingroad.com
> > > >
> > >
> > > --
> > > SQL Anywhere Studio 9 Developer's Guide
> > > ISBN 1-55622-506-7
> > > bcarter@risingroad.com
> > > Mobile and Distributed Enterprise Database Applications
> > > www.risingroad.com
> >
> >
>
>