UNLOAD 块

1  LOADOPT
2.1  (
2.2.1+ ,
2.2.1  SAVECOUNT nn
2.2.1  ROWCOUNT nn
2.2.1  WARNINGCOUNT nn
2.2.1  MESSAGES "filename"
2.2.1  TEMPFILES PATH "pathname"
2.2.1  STATISTICS
2.2.2.1 USE PROFILE
2.2.2.1 NO
2.2.1 load_recovery_option
2.2.1  DATA BUFFER nn
2.2.1  SORT BUFFER nn
2.2.1  CPU_PARALLELISM nn
2.2.1  DISK_PARALLELISM nn
2.2.1  INDEXING MODE
2.2.2.1 AUTOSELECT
2.2.2.1 REBUILD
2.2.2.1 INCREMENTAL
2.2.2.1 DEFERRED
2.2.1  ALLOW
2.2.2.1 NO ACCESS
2.2.2.1  READ ACCESS
2.2.2.2.1  USE tsname
2.2.1  SET INTEGRITY PENDING CASCADE
2.2.2.1 IMMEDIATE
2.2.2.1 DEFERRED
2.2.1 LOCK WITH FORCE
2.1 )
2?  LOADTEMPFILES ( "path" )
1  INTERVAL nn
1  DB2
2.1 YES
2.1 NO
1  format_clause
1 +  SELECT select_clause
1  outfile_clause
1  LOCK
2.1 YES
2.1 NO
1  FLUSH BUFFERPOOLS
2.1 YES
2.1 NO
1  SIZELIMIT
2.1 integerK
2.1 integerM
2.1 integerG

1?  SCHEMA schema_name?  SHARED_DATAPART_PROCESSING
2.1 NO
2.1 YES?  TARGET KEYS  (
2.1 DEFAULT
2.1 CURRENT
2.1  PARTS
2.2.1  (
2.2.2.1! ALL
2.2.2.1 
2.2.2.2.1+ ,
2.2.2.2.1 nn
2.2.2.2.1 nn:nn
2.2.1 )
2.2.1?  IN ”filename” )
1  SKIP nn
1  LOB IN ( + , "lob_path_with_template"
2.1 for_parts_clause )
1  LOBFILE ( + , "base_file_name_with_template" )
1  XML IN ( + , "xml_path_with template"
2.1 for_parts_clause )
1  XMLFILE ( + , "base_file_name-with-template" )
1  FILEMAXSIZE
2.1 integerK
2.1 integerM
2.1 integerG
1  options_clause
1  CCSID ( ccsid_mixed
2.1  , ccsid_dbcs
1 )
1  ASIS
1  ASCII
1  UNICODE
1  EBCDIC
1  LOCALE
1 
2.1 database_backup block
2.1 copy block
10?  MAXTHREADS n
1  TARGET ENVIRONMENT ( target_db2nodes_specification?  IN dbname?  TENANT tenant_name?  REPART
2.1 NO
2.1 PMAP_4K
2.1 PMAP_32K )
11?  WORKING IN ( "dirname"? WITH FILES? 
12.1 UNIX
12.1 WINDOWS
11 PATH )
11?  replace_string_clause
11?  translate_string_clause

1  DDLFILE (
2.1 "path/filename"
2.1 "host:path/filename"
1 )
1  DDLOPT (
2.1+ ,
2.1 WITH LIKE CLAUSE
2.1  IN ( + , 'tablespace_name' )
1 )
3?  LOBINLINESIZE nnK
1  INTO TABLES
2.1  ( + , tables_pair_spec?  columns_pair_spec ?  IN (
2.2.1+ ,
2.2.1 tsname
2.1 ) )
2.1  IN "path/filename"
2.1  WITH SCHEMA schema_name
1  TABLES MODIFIERS
2.1  ( + ,  ( + , modifier )? 
2.2.1 FOR
2.2.1 EXCEPT
2.1  ( + ,
2.2.1 tablename
2.2.1 qualifier.tablename ) )
2.1  IN "filename"
5?  XMLSERIALIZE ( xmlserialization_spec )
1  OVERRIDE ( + , "original_dir" BY "new_dir" )
1  SEARCH (  "search_dir" )
1  MAXROWS nn
7?  STAGING IN ( "dirname" )
1  loaddest_clause
8  ;

1  INSTANCE "instance_name"
2.1?  ON "hostname"
2.1  FILE "filename_with_template"?  EXCEPT PARTS (
2.1+ ,
2.1 nn
2.1 nn:nn
1 )

1 INSERT
1  REPLACE
2.1 KEEPDICTIONARY
2.1 RESETDICTIONARY
1 RESTART
1 TERMINATE

1 LOAD_ONLY
1 LOAD_ONLY_VERIFY_PART
1 PARTITION_ONLY
1 PARTITION_AND_LOAD

1 NONRECOVERABLE
1  COPY
2.1 NO
2.1  YES (
2.2.1  USE TSM
2.2.2.1  OPEN nn SESSIONS
2.2.1  TO + , "directory"
2.2.1  LOAD "shared library"
2.2.2.1?  OPEN nn SESSIONS
2.1 )

1 
2.1 src_tbname
2.1 src_qualifier.src_tbname  : 
2.1 tgt_tbname
2.1 tgt_qualifier.tgt_tbname

1  WITH COLUMNS (
2.1 + ' src_col:tgt_col
2.1  dft_colfamily?  , + , src_col:tgt_col:colfamily
1 )

2.1 
2.2.1 CHARACTER
2.2.1 CHAR
2.1?  ( integer
2.2.1 OCTETS
2.2.1 CODEUNITS32
2.1 )
2.1 
2.2.1 VARCHAR
2.2.1 
2.2.2.1 CHARACTER
2.2.2.1 CHAR
2.2.1 VARYING
2.1  ( integer
2.2.1 OCTETS
2.2.1 CODEUNITS32
2.1 )
2.1 
2.2.1 CLOB
2.2.1 
2.2.2.1 CHARACTER
2.2.2.1 CHAR
2.2.1 LARGE OBJECT
2.1?  ( integer
2.2.1 K
2.2.1 M
2.2.1 G
2.2.1 OCTETS
2.2.1 CODEUNITS32
2.1 )
2.1 
2.2.1 BLOB
2.2.1  BINARY LARGE OBJECT
2.1?  ( integer
2.2.1 K
2.2.1 M
2.2.1 G
2.1 )
1 
2.1 EXCLUDING
2.1 INCLUDING
1 XMLDECLARATION