LOAD

                    Load

1.       LOAD JCL

//LEBRONJ  JOB (12345678),LEBRON,MSGCLASS=H,            

//        MSGLEVEL=(1,1),CLASS=A,NOTIFY=&SYSUID         

//UTIL EXEC DSNUPROC,SYSTEM=DB8G,UID='LEBRONJ',UTPROC=''                        

//DSNUPROC.SORTWK01 DD DSN=LEBRON.SORTWK01,             

//     DISP=(MOD,DELETE,CATLG),                         

//     SPACE=(16384,(20,20),,,ROUND),                   

//     UNIT=SYSDA                                       

//DSNUPROC.SORTWK02 DD DSN=LEBRON.SORTWK02,             

//     DISP=(MOD,DELETE,CATLG),                         

//     SPACE=(16384,(20,20),,,ROUND),                   

//     UNIT=SYSDA                                       

//DSNUPROC.SORTWK03 DD DSN=LEBRON.SORTWK03,             

//     DISP=(MOD,DELETE,CATLG),                         

//     SPACE=(16384,(20,20),,,ROUND),                

//     UNIT=SYSDA                              

//DSNUPROC.SORTWK04 DD DSN=LEBRON.SORTWK04,    

//     DISP=(MOD,DELETE,CATLG),                

//     SPACE=(16384,(20,20),,,ROUND),          

//     UNIT=SYSDA                              

//DSNUPROC.SYSREC DD DSN=LEBRON.TABLE.DATA,    

//     DISP=OLD                                

//DSNUPROC.SYSUT1 DD DSN=LEBRON.SYSUT1,        

//     DISP=(MOD,DELETE,CATLG),                

//     SPACE=(16384,(20,20),,,ROUND),          

//     UNIT=SYSDA                              

//DSNUPROC.SORTOUT DD DSN=LEBRON.SORTOUT,      

//     DISP=(MOD,DELETE,CATLG),                

//     SPACE=(16384,(20,20),,,ROUND),          

//     UNIT=SYSDA                              

//DSNUPROC.SYSERR DD DSN=LEBRON.SYSERR,        

//     DISP=(MOD,DELETE,CATLG),                

//     SPACE=(16384,(20,20),,,ROUND),         

//     UNIT=SYSDA                              

//DSNUPROC.SYSMAP DD DSN=LEBRON.SYSMAP,       

//     DISP=(MOD,DELETE,CATLG),               

//     SPACE=(16384,(20,20),,,ROUND),         

//     UNIT=SYSDA                             

//DSNUPROC.SYSIN    DD  DSN=LEBRON.TABLE.RUN, 

//     DISP=(MOD,CATLG)                       

//                                                

2.       DSNUPROC.SYSREC

存放的是从TableUNLOAD的数据.

3.       DSNUPROC.SYSIN

存放的是从UNLOAD过程中生成的control statement, see a example below:

LOAD DATA INDDN SYSREC ENFORCE NO          

 EBCDIC  CCSID(00037,00000,00000)          

 INTO TABLE "LEBRON"."LBNTABLE"            

 WHEN(00001:00002 = X'0003')               

 ( "ID"                                    

        POSITION(  00003:00022) CHAR(00020)

 , "NAME"                                   

        POSITION(  00023:00042) CHAR(00020)

 )  

 

LOAD Parameters

l        LOAD RESUME

Append the data to the table. That means you won't lost existing data.

l        LOAD REPLACE

Delete the existing data in tablespace(all the tables in tablespace will lost the data) and load the given data in mentioned table.

l        LOAD ENFORCE CONSTRAINTS

The ENFORCE CONSTRAINTS option indicates that LOAD is to enforce referential constraints on the data that is being added. This option is also the default. All violations are reported in the output. All records causing these violations are not loaded and placed in the SYSDISC data set, which is the default data set for discarded records.

l        LOAD ENFORCE NO

ENFORCE NO indicates that the LOAD utility is not to enforce referential constraints and places the table in CHECK-PENDING status. Use this option if you are loading data into several tables that are related in such a way that the referential constraints cannot be checked until all tables are loaded. For example, a column in table A depends on a column in table B; a column in table B depends on a column in table C; and a column in table C depends on a column in table A.

l        LOAD LOG YES

LOG YES indicates that logging is to occur during the LOAD job.

l        LOAD LOG NO

Cause tablespace to COPY-PENDING status except using LOAD LOG NO NOCOPYPEND. To remove the COPY PENDING status, you take an image copy or use REPAIR Utility or use command like -START DATABASE(dbname) SPACENAM(tablespace name) ACCESS(FORCE).

 

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值