An IXF file also contains the tableĭefinition and definitions of any existing indexes, except when columns areįor more information about file formats, see the Appendix C.
LOTUS SYMPHONY SEARCH REPLACE NEWLINE PC
IXF (integrated exchange format, PC version), which means it was exportedįrom the same or another DB2 table.WSF (work sheet format), which is used by programs such as:.DEL (delimited ASCII format), which is used by a variety of database.Specifies the format of the data in the input file: Path is omitted, the current working directory is used. Specifies the file that contains the data being imported. '-DL_LINKTYPE URL-' +-DL_URL_REPLACE_PREFIX- "prefix"-+ '-DL_URL_SUFFIX- "suffix"-' '-INDEX IN- tablespace-name-' '-LONG IN- tablespace-name-' >-HIERARCHY-+-STARTING- sub-table-name-+-| '-| hierarchy description |-+-AS ROOT TABLE-+-' If implicit connect is enabled, a connection to the Sysadm dbadm CONTROL privilege on every sub-table in the hierarchy.ĭatabase. IMPORT to an existing hierarchy using the REPLACE option requires one of.REPLACE_CREATE option on the entire hierarchy is used. CONTROL privilege on every sub-table in the hierarchy, if the.CREATEIN privilege on the schema, if the schema of the table.IMPLICIT_SCHEMA authority on the database, if the schema name of the.Sysadm dbadm CREATETAB authority on the database, and one of: IMPORT to a table or a hierarchy that does not exist using the CREATE, or the REPLACE_CREATE.Sysadm dbadm CONTROL privilege on the table or view. REPLACE_CREATE option, requires one of the following:
IMPORT to an existing table using the INSERT_UPDATE, REPLACE, or the.INSERT and SELECT privilege on each participating table or view. Sysadm dbadm CONTROL privilege on each participating table or view IMPORT using the INSERT option requires one of the following:.Inserts data from an external file with a supported file format into a
0 kommentar(er)
