O bloco UNLOAD é necessário para cada descarregamento e fornece muitos dos controles básicos para um descarregamento. Este bloco pode ocorrer mais de uma vez em um arquivo de controle.
O diagrama de sintaxe a seguir mostra o bloco UNLOAD.
Atenção: Este bloco deve terminar com um ponto-e-vírgula.
Figura 1. Bloco 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 )Continuação do bloco de descarregamento:
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 integerGContinuação do bloco de descarregamento:
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 Continuação do bloco de descarregamento:
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 ;Continuação da cláusula de AMBIENTE do TARGET:
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 )Continuação da cláusula LOADMODE:
Figura 3. load_mode:
1 INSERT
1 REPLACE
2.1 KEEPDICTIONARY
2.1 RESETDICTIONARY
1 RESTART
1 TERMINATEContinuação da cláusula LOADMODE para ambientes DPF:
Figura 4. dpf_load_mode:
1 LOAD_ONLY
1 LOAD_ONLY_VERIFY_PART
1 PARTITION_ONLY
1 PARTITION_AND_LOADContinuação da cláusula LOADOTAR:
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 )Continuação da 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. columns_pair_spec:
1 WITH COLUMNS (
2.1 + ' src_col:tgt_col
2.1 dft_colfamily ? , + , src_col:tgt_col:colfamily
1 )Continuação da 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