10 MYLIB/MYFILE MYMBR /QSYS.LIB/MYLIB.LIB/MYFILE.FILE/MYMBR.MBR 20 MYLIB/MYSAVF (Save File) /QSYS.LIB/MYLIB.LIB/MYSAVF.SAVF 30 MYLIB/MYFILE Program /QSYS.LIB/MYLIB.LIB/MYPGM.PGM
# output IFS file QSH CMD('print It is working > /home/mydir/myfile.txt') # output cmd result to a DB2 file CRTPF FILE(MYLIB/MYFILE) RCDLEN(300) QSH cmd('ls /qsys.lib/mylib.lib/* > /qsys.lib/myfile.lib/myfile.file/myfile.mbr')
# esporta in csv una tabella CPYTOIMPF FROMFILE(MYLIB/HLTHCAR) TOSTMF('/home/test/myexport.csv') MBROPT(*ADD) RCDDLM(*CRLF)
ricerca sorgenti:
# search a word grep EC_CLPAR0F /qsys.lib/ca_src.lib/srcpgm.file/getecr.mbr # search a word in group of files grep -in -e 'invnbrinvoicenumber /qsys.lib/tst.lib/src.file/*
ricerca oggetti:
# search for objects created by USER find /qsys.lib/JL*.LIB /qsys.lib/JA*.LIB -user 'USER' # search programs find /qsys.lib/JL*.LIB /qsys.lib/JA*.LIB -user 'test' –name '*.PGM'
lista membri:
STRQSH cd /qsys.lib/php_src.lib/srcpgm.file ls
eseguire SQL:
QSH CMD('db2 "UPDATE MYLIB.MYFILE SET MYFLD = ''P''" ') QSH CMD('db2 "INSERT INTO MYLIB.MYTABLE VALUES(''jagannath'', 104.20)"')
zippare un file:
jar -cvMf test.zip -C dir1/dir2/ test.txt
Rfile utility reads OS/400 record files (database or device files) and writes the data to standard output, or reads standard input and writes the data to record files.
# Read the contents of source database member, and write it to standard output. Trailing blanks are removed from each line. # r = read, w = write # Q = usa convenzione nomi as400, altrimenti IFS Rfile -rQ 'QTEMP/myfile'