AS400常用命令的使用
To member or label . . . . . . .*FIRSTName, *FIRST, *FROMMBR
Replace or add records . . . . .*NONE*NONE, *ADD, *REPLACE...
Create file . . . . . . . . . .*NO*NO, *YES
Type options, press Enter.
4=End job 5=Work with job 8=Work with job locks
Opt Job User Lock Status
(There are no locks for the specified object)
Bottom
F3=Exit F5=Refresh F6=Work with member locks F12=Cancel
Starting sequence number . . .1.000.01-9999.99
Increment number . . . . . . .1.000.01-9999.99
Errors allowed . .*NOMAX
Compress out deleted records . .*YES*YES, *NO
Key value . . . . . . . . . .
+ for more values
Copy to record key:
Number of key fields . . . . .*NONENumber, *NONE, *BLDKEY
Key value . . . . . . . . . .
Member . . . . . . . . . . . .*ALLName, generic*, *ALL, *NONE
+ for more values
+ for more values
Save access paths . . . . . . .*NO*NO, *YES
Save file data . . . . . . . . .*YES*YES, *NO
三、创建*SAVF文件:
Create Save File (CRTSAVF)
Type choices, press Enter.
Save file . . . . . . . . . . . >TESTSAVFName
Library . . . . . . . . . . . >TLIB00Name, *CURLIB
Bottom
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display
F24=More keys
查询情况:
Work with Object Locks
System: S653P87M
Object: TCL00F1 Library: TLIB00 Type: *FILE-PHY
Label . . . . . . . . . . . . .*LIB
File expiration date . . . . . .*PERMDate, *PERM
End of tape option . . . . . . .*REWIND*REWIND, *LEAVE, *UNLOAD
Save file . . . . . . . . . . .Name
Print format . . . . . . . . . .*CHAR*CHAR, *HEX
Additional Parameters
Which records to print . . . . .*NONE*NONE, *EXCLD, *COPIED...
+ for more values
Record format of logical file .*ONLYName, *ONLY, *ALL
Object type . . . . . . . . . . > *FILE *ALRTBL, *AUTL, *BNDDIR...
Member . . . . . . . . . . . . . *NONE Name, *NONE, *FIRST, *ALL
Output . . . . . . . . . . . . . * *, *PRINT
Save active message queue . . .*NONEName, *NONE, *WRKSTN
Library . . . . . . . . . . .*LIBLName, *LIBL, *CURLIB
File member:
File . . . . . . . . . . . . .*ALLName, *ALL
Character position . . . . . .Number
Relational operator . . . . .*EQ, *GT, *LT, *NE, *GE...
Value . . . . . . . . . . . .
Include records by field test:
+ for more values
Library . . . . . . . . . . . . >TLIB00Name, generic*
+ for more values
Device . . . . . . . . . . . . . >*SAVFName, *SAVF
+ for more values
Storage . . . . . . . . . . . .*KEEP*KEEP, *FREE
Data compression . . . . . . . .*DEV*DEV, *NO, *YES
Data compaction . . . . . . . .*DEV*DEV, *NO
Libraries to omit . . . . . . .*NONEName, generic*, *NONE
To file . . . . . . . . . . . . >TCL00F2Name, *PRINT
Library . . . . . . . . . . . >NEWLIBName, *LIBL, *CURLIB
From member . . . . . . . . . .*FIRSTName, generic*, *FIRST, *ALL
Bottom
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display
F24=More keys
四、备份操作:SAVOBJ
Save Object (SAVOBJ)
Type choices, press Enter.
Objects . . . . . . . . . . . . >*ALLName, generic*, *ALL
Object types . . . . . . . . . .*ALL*ALL, *ALRTBL, *BNDDIR...
+ for more values
Volume identifier . . . . . . .*MOUNTED
+ for more values
Sequence number . . . . . . . .*END1-16777215, *END
Object pre-check . . . . . . . .*NO*NO, *YES
Save active . . . . . . . . . .*NO*NO, *LIB, *SYNCLIB, *SYSDFN
Save active wait time . . . . .1200-99999, *NOMAX
常用命令的使用
一、拷贝数据库文件命令:CPYF
Copy File (CPYF)
Type choices, press Enter.
From file . . . . . . . . . . . >TCL00F1Name
Library . . . . . . . . . . . >TLIB00Name, *LIBL, *CURLIB
+ for more values
Number of records to copy . . .*ENDNumber, *END
Include records by char test:
Field . . . . . . . . . . . .*NONEName, *NONE, *RCD, *FLD
二、查找目标锁定情况命令:WRKOBJLCK
Work with Object Locks (WRKOBJLCK)
Type choices, press Enter.
Object . . . . . . . . . . . . . > TCL00F1 Name
Library . . . . . . . . . . . > TLIB00 Name, *LIBL, *CURLIB
Text 'description' . . . . . . . >'this is a test save-file'
Additional Parameters
Maximum records . . . . . . . .*NOMAX1-536854528, *NOMAX
Auxiliary storage pool ID . . .*LIBASP1-64, *LIBASP
Library . . . . . . . . . . .*LIBLName, *LIBL, *CURLIB