Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
827
|
| sqlimport | Imports data. |
|---|---|
| Synopsis |
sqlimport [OPTION ...] FILE TABLE |
| Description | sqlimport imports data stored in FILE into TABLE. Data stored in FILE can be in one of these formats: Delimited or Fixed Width Columns; see -f option for details. If FILE is not specified, sqlimport will read data from the standard input. |
| Options |
If both short form and long form are specified on the command line, the long form will take precedence. -c, --charset CHARSET The character set for reading data; supported values are: 'UTF-8' and 'platform-default', defaults to 'UTF-8'. -CN, --column-names BOOLEAN Indicates whether the first row contains column names, defaults to 'true'. See BOOLEAN Values section below for supported BOOLEAN values. -CW, --column-widths COLUMN-WIDTHS A list of comma separated widths. This option applies when the 'fixed' data format is selected. -d, --database DATABASE The name of the database where TABLE is defined, defaults to the connected database. -DD, --delimiter DELIMITER The delimiter for separating data; default to ','. Use words 'tab', 'space' for setting tab character, space character, as delimiter respectively. -DS, --decimal-symbol SYMBOL Decimal symbol; defaults to '.'. -f, --format FORMAT The format of data stored in FILE; supported values are: 'csv', 'fixed', defaults to 'csv'. -II, --identity-insert BOOLEAN Enable or disable identity insert, defaults to 'false'. See BOOLEAN Values section below for supported BOOLEAN values. -l, --line-separator LINE-SEPARATOR The line separator; supported values are: 'unix', 'windows', defaults to platform's line separator. -NT, --null-text BOOLEAN Indicates if NULL value is represented as (null) text, defaults to 'true'. See BOOLEAN Values section below for supported BOOLEAN values. -PA, --datetime PATTERN Pattern for formatting date and time, defaults to 'yyyy/MM/dd:hh:mm:ss a'. -PD, --date PATTERN Pattern for formatting date, defaults to 'yyyy/MM/dd'. -PT, --time PATTERN Pattern for formatting time, defaults to 'hh:mm:ss a'. -s, --schema SCHEMA The name of the schema where TABLE is defined. -SQ, --string-quote IDENTIFIER String quoted identifier; supported values are: 'double-quote', 'single-quote, 'none', defaults to 'double-quote'. This option is applicable only in CSV mode. -TE, --tx-type TYPE The transaction method applied to executed statements; supported values are: 'Full', 'Batch', 'Threshold', 'Full' (default). -TS, --tx-batch-size BATCH-SIZE Number of statements per transaction when transaction type is set to 'Batch'; defaults to '500'. -TT, --tx-threshold THRESHOLD Time limit threshold per transaction, in milliseconds, when transaction type is set to 'Threshold'; defaults to '5000'. -TW, --tx-wait-time WAIT-TIME The amount of time to wait, in milliseconds, between transactions; disabled if negative value specified; default is disabled. The following options will take effect if data format is set to 'csv': -DD, --delimiter DELIMITER The delimiter for separating data; default to ','. Use words 'tab', 'space' for setting tab character, space character, as delimiter respectively. The following options will take effect if data format is set to 'fixed': -CW, --column-widths COLUMN-WIDTHS A list of comma separated widths. This option must be specified for 'fixed' data format. BOOLEAN VALUES: The followings are supported BOOLEAN values: 'true', 'false', 'yes', 'no', 'on', 'off', '1', '0'. |
| Example |
To import to the table with data in csv format, single quoted identifier and transaction type Threshold, use:sqlimport -c 'UTF-8' -d 'NORTHWIND' -f 'csv' -l 'unix' -s 'dbo' -CN 'true' -DS '.' -II 'false' -NT 'true' -PA 'yyyy/MM/dd hh:mm:ss a' -PD 'yyyy/MM/dd' -PT 'hh:mm:ss a' -SQ 'double-quote' -TE 'Threshold' -DD ',' Dataforimport.csv "MY_TABLE" |
| See Also | sqlexport |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017