Sybase IQ从远程数据库插入到本地数据库

最新推荐文章于 2020-07-15 19:08:13 发布

-爱拼才会赢-

最新推荐文章于 2020-07-15 19:08:13 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/housheng33/article/details/9118751

Sybase IQ Insert location使用
1 命令介绍
INSERT [INTO] [owner.]table-name[ (column-name [, ... ] ) ]
... insert-load-options
[ LOCATION 'servername.dbname'
[ location-options ] ]
... { select-statement }
【参数说明】
 insert-load-options
 [ LIMIT number-of-rows ]：The LIMIT option specifies the maximum number of rows to insert into the table from a query. The default is 0 for no limit. The maximum is 2GB -1.指定插入的最大的行数。
 [ NOTIFY number-of-rows ]：The NOTIFY option specifies that you be notified with a message each time the number of rows are successfully inserted into the table. The default is every 100,000 rows. 每次插入时都有消息提示，默认是100，000行提示一次。
 [ SKIP number-of-rows ]：The SKIP option lets you define a number of rows to skip at the beginning of the input tables for this insert. The default is 0.忽略几行开始插入
 [ START ROW ID number ]：The START ROW ID option specifies the record identification number of a ro