dbTalk Databases Forums  

ISQL import command

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss ISQL import command in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Kerber
 
Posts: n/a

Default ISQL import command - 10-29-2009 , 10:10 AM






ISQL/ASA 9.0.2.3804

What command does the import wizard in ISQL use when I do Data | Import,
and select a .txt file? Is it LOAD TABLE?

What I need is to script up an import that duplicates the ISQL Data
Import function.


--
/~\ The ASCII
\ / Ribbon Campaign
X Against HTML
/ \ Email!

Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

Reply With Quote
  #2  
Old   
Nick Elson [Sybase iAnywhere]
 
Posts: n/a

Default Re: ISQL import command - 10-29-2009 , 12:10 PM






It does inserts operations that you can see from
a request log. Basically it is the INPUT operation
that is built into and implemented by dbisql.

Since 9.0.x had no concept of a load table from
client (v11.0 has that one) this is a client side
operation that must map to basic insert operations.

So, to script this, see the INPUT statement.


"David Kerber" <ns_dkerber (AT) ns_WarrenRogersAssociates (DOT) com> wrote

Quote:
ISQL/ASA 9.0.2.3804

What command does the import wizard in ISQL use when I do Data | Import,
and select a .txt file? Is it LOAD TABLE?

What I need is to script up an import that duplicates the ISQL Data
Import function.


--
/~\ The ASCII
\ / Ribbon Campaign
X Against HTML
/ \ Email!

Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

Reply With Quote
  #3  
Old   
David Kerber
 
Posts: n/a

Default Re: ISQL import command - 10-29-2009 , 12:57 PM



In article <4ae9da84$1@forums-1-dub>, "Nick Elson [Sybase iAnywhere]"
<@nick@dot@elson@at@sybase@dot@com@> says...
Quote:
It does inserts operations that you can see from
a request log. Basically it is the INPUT operation
that is built into and implemented by dbisql.

Since 9.0.x had no concept of a load table from
client (v11.0 has that one) this is a client side
operation that must map to basic insert operations.

So, to script this, see the INPUT statement.
Thanks!

.....

--
/~\ The ASCII
\ / Ribbon Campaign
X Against HTML
/ \ Email!

Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.