Bloque UNLOAD

El bloque UNLOAD es necesario para todas las descargas y proporciona muchos de los controles básicos para una descarga. Este bloque puede tener lugar más de una vez en un archivo de control.

El siguiente diagrama de sintaxis muestra el bloque UNLOAD.

Atención: Este bloque debe finalizar con un punto y coma.
Figura 1. Bloque UNLOAD

1 
2.1 UNLOAD
2.1 MIGRATE
2.1  DATABASE?  db_name
2.1  TABLESPACE?  ts_name
1  PART  (
2.1 ALL
2.2.1+ ,
2.2.1 nn
2.2.1 nn:nn
1 )
1  ONLY TABLES
2.1  (
2.2.1+ ,
2.2.1 tablename
2.2.1 qualifier.tablename
2.1 )
2.1  IN "filename"
1  EXCEPT TABLES
2.1  (
2.2.1+ ,
2.2.1 tablename
2.2.1 qualifier.tablename
2.1 )
2.1  IN "filename"
1  HEADER
2.1 FIRST
2.1 NONE
2.1 ALL
2.1  EXTERNAL "filename"
6?  HIDDEN
7.1 NO
7.1 YES
1  LOADFILE (
2.1 "path/filename"
2.1 "host:path/filename"
1 )
1  LOADMODE
2.1 load_mode
2.1  ( load_mode?  WITH dpf_load_mode )
Continuación del bloque 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
Continuación del bloque UNLOAD:

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
Continuación del bloque UNLOAD:

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  ;
Continuación de la cláusula TARGET ENVIRONMENT:
Figura 2. target_db2nodes_specification:

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 )
Continuación de la cláusula LOADMODE:
Figura 3. load_mode:

1 INSERT
1  REPLACE
2.1 KEEPDICTIONARY
2.1 RESETDICTIONARY
1 RESTART
1 TERMINATE
Continuación de la cláusula LOADMODE para entornos DPF:
Figura 4. dpf_load_mode:

1 LOAD_ONLY
1 LOAD_ONLY_VERIFY_PART
1 PARTITION_ONLY
1 PARTITION_AND_LOAD
Continuación de la cláusula LOADOPT:
Figura 5. load_recovery_option:

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 )
Continuación de la cláusula INTO TABLES:
Figura 6. tables_pair_spec:

1 
2.1 src_tbname
2.1 src_qualifier.src_tbname  : 
2.1 tgt_tbname
2.1 tgt_qualifier.tgt_tbname
Figura 7. columnas_par_spec:

1  WITH COLUMNS (
2.1 + ' src_col:tgt_col
2.1  dft_colfamily?  , + , src_col:tgt_col:colfamily
1 )
Continuación de la cláusula XMLSERIALIZE:
Figura 8. xmlserialization_spec:

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