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.

Sybase ASA and bulk-copy

2 posts in General Discussion Last posting was on 2007-05-17 17:58:59.0Z
ericr Posted on 2007-05-17 16:47:44.0Z
From: ericr@trans-soft.net
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Sybase ASA and bulk-copy
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: ip68-2-42-77.ph.ph.cox.net
X-Original-NNTP-Posting-Host: ip68-2-42-77.ph.ph.cox.net
Message-ID: <464c8730$1@forums-1-dub>
Date: 17 May 2007 09:47:44 -0700
X-Trace: forums-1-dub 1179420464 68.2.42.77 (17 May 2007 09:47:44 -0700)
X-Original-Trace: 17 May 2007 09:47:44 -0700, ip68-2-42-77.ph.ph.cox.net
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6013
Article PK: 2472

Hello,

I'm looking for a way to import a lot, 10000 records per load, into my
database. I'm looking for a dos-shell bcp command so I can kick off the
job once the file appears. Or should I kick off a process to use the
'LOAD TABLE' command?

What is the behavior of triggers during this type of load? Any and all
info will be greatly appreciated.

Currently running:
Sybase ASA 9.0.2.3228
Windows 2000

Thanks
eric


Rob Waywell Posted on 2007-05-17 17:58:59.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <464c8730$1@forums-1-dub>
Subject: Re: Sybase ASA and bulk-copy
Lines: 91
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <464c97e3$1@forums-1-dub>
Date: 17 May 2007 10:58:59 -0700
X-Trace: forums-1-dub 1179424739 10.25.98.235 (17 May 2007 10:58:59 -0700)
X-Original-Trace: 17 May 2007 10:58:59 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6014
Article PK: 2474

LOAD TABLE is the right tool. No it does not fire triggers, this is
documented under:

ASA SQL User's Guide

Importing and Exporting Data

Importing data into databases

Importing tables
...
Neither the TRUNCATE TABLE statement nor the LOAD TABLE statement fires
triggers, including referential integrity actions, such as cascaded deletes.

It is also mentioned under:

ASA SQL Reference

SQL Statements

LOAD TABLE statement
...
Side effects
...
The LOAD TABLE statement does not fire any triggers associated with the
table.
...


--
-----------------------------------------------
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=Bug

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

<ericr@trans-soft.net> wrote in message news:464c8730$1@forums-1-dub...
> Hello,
>
> I'm looking for a way to import a lot, 10000 records per load, into my
> database. I'm looking for a dos-shell bcp command so I can kick off the
> job once the file appears. Or should I kick off a process to use the
> 'LOAD TABLE' command?
>
> What is the behavior of triggers during this type of load? Any and all
> info will be greatly appreciated.
>
> Currently running:
> Sybase ASA 9.0.2.3228
> Windows 2000
>
> Thanks
> eric
>

arrowdn.gif