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.

Loading/bulk inserting data efficiently

3 posts in General Discussion Last posting was on 2009-12-25 04:32:36.0Z
Irving Zhu Posted on 2009-12-24 18:38:47.0Z
Sender: 6258.4b33b2b7.1804289383@sybase.com
From: Irving Zhu
Newsgroups: ianywhere.public.general
Subject: Loading/bulk inserting data efficiently
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b33b537.62da.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Dec 2009 10:38:47 -0800
X-Trace: forums-1-dub 1261679927 10.22.241.41 (24 Dec 2009 10:38:47 -0800)
X-Original-Trace: 24 Dec 2009 10:38:47 -0800, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7842
Article PK: 6879

Hi,

We need to bulk insert a lot of records into a table. The
table contains a lot of LONG BINARY fields. Usually I can
use the LOAD statement, but in this case the problem I have
is that I have to represent bytes in LONG BINARY as hexical
and that is quite verbose. Is there any way to efficiently
represent binary data in a file that can be subsequently
LOADed into the db?

Thanks


Jeff Albion [Sybase iAnywhere] Posted on 2009-12-24 19:52:32.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5) Gecko/20091204 Thunderbird/3.0
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Loading/bulk inserting data efficiently
References: <4b33b537.62da.1681692777@sybase.com>
In-Reply-To: <4b33b537.62da.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b33c680$1@forums-1-dub>
Date: 24 Dec 2009 11:52:32 -0800
X-Trace: forums-1-dub 1261684352 10.22.241.152 (24 Dec 2009 11:52:32 -0800)
X-Original-Trace: 24 Dec 2009 11:52:32 -0800, vip152.sybase.com
Lines: 19
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7844
Article PK: 6874

Hi Irving,

I have responded on sybase.public.sqlanywhere.general. In the future,
please do not cross-post.

Regards,

On 12/24/2009 1:38 PM, Irving Zhu wrote:
> We need to bulk insert a lot of records into a table.

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/


Irving Zhu Posted on 2009-12-25 04:32:36.0Z
Sender: 709a.4b344030.1804289383@sybase.com
From: Irving Zhu
Newsgroups: ianywhere.public.general
Subject: Re: Loading/bulk inserting data efficiently
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b344064.70a2.1681692777@sybase.com>
References: <4b33c680$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Dec 2009 20:32:36 -0800
X-Trace: forums-1-dub 1261715556 10.22.241.41 (24 Dec 2009 20:32:36 -0800)
X-Original-Trace: 24 Dec 2009 20:32:36 -0800, 10.22.241.41
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7846
Article PK: 6878

Sorry.

> Hi Irving,
>
> I have responded on sybase.public.sqlanywhere.general. In
> the future, please do not cross-post.
>
> Regards,
>
> On 12/24/2009 1:38 PM, Irving Zhu wrote:
> > We need to bulk insert a lot of records into a table.
>
> --
> Jeff Albion, Sybase iAnywhere
>
> iAnywhere Developer Community :
>
http://www.sybase.com/developer/library/sql-anywhere-techcorner
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals SQL
> Anywhere Patches and EBFs :
>
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
> Report a Bug/Open a Case :
> http://case-express.sybase.com/cx/