TAFJ Supported Commands
TAFJ Supported Commands
TAFJ Supported Commands
Revi si o
Dat e Ame n d e d Na m e De s c r i p t i o n
n
18 th Octobe r
1 TAFJ Tea m Initial Version
2019
M.
2 25 th Marc h 2020 R20 AMR Review
Siranje evi
M.
3 12 th April 2021 R21 AMR Review
Siranje evi
2
TAFJ S u p po rt e d Co m m a n d s
Copyri g h t
Pleas e includ e your na m e , comp a n y, addr e s s, and telep h o n e and fax num b e r s , and email add r e s s if
applica bl e. TAFJdev@t e m e n o s . c o m
Intro d u c t i o n
TAFJ is not TAFC and in many case s does not acce p t som e of the com m a n d s that TAFC does. When a
custo m e r migr a t e s from TAFC to TAFJ, custo m e r s need to know the suppo r t e d com m a n d s . This
docu m e n t aims at providin g this inform a ti o n.
What goes betw e e n the quot e s of an EXECUTE stat e m e n t is tran sl a t e d into a SQL stat e m e n t in most
case s. Ther efor e , one SHOULD NOT put OS com m a n d s in an EXECUTE claus e (altho u g h som e are
suppo r t e d )
4
TAFJ S u p po rt e d Co m m a n d s
In JBC, TAFJ - Su p p o r t e d Com m a n d s
EXECUTE “ ”
EXECUTE “LOGOFF etc“ In effect does nothin g in TAFJ
EXECUTE “SPOOL etc“ In effect does nothin g in TAFJ
EXECUTE “CD DVOC etc“
EXECUTE “PHANTOM”
EXECUTE “BASIC”
EXECUTE “CATALOG” “ In effect does nothin g in TAFJ as once a file is com pile d, the .class file is
cat alog e d
EXECUTE “ICOMP etc”
EXECUTE “COMO etc”
EXECUTE “HUS H etc”
EXECUTE “GET.LIST etc”
EXECUTE “SAVE.LIST etc”
EXECUTE “SETPTR etc”
EXECUTE “CLEARSELECT”
EXECUTE “SH –c etc”
EXECUTE “DOS –c etc”
EXECUTE “DOS /c etc”
EXECUTE “COUNT MYFILE etc” W h e r e MYFILE is a valid file as a RECID in the TAFJ_VOC table
EXECUTE “SELECT MYFILE etc” W h e r e MYFILE is a valid file as a RECID in the TAFJ_VOC tabl e. If
MYFILE is a UD, no WITH claus e is allowe d, ie only EXECUTE “SELECT MYFILE”.
EXECUTE “SSELECT MYFILE etc” Wher e MYFILE is a valid file as a RECID in the TAFJ_VOC table. If
MYFILE is a UD, no WITH claus e is allowe d, ie only EXECUTE “SSELECT MYFILE”.
EXECUTE “DELETE MYFILE etc” W h e r e MYFILE is a valid file as a RECID in the TAFJ_VOC tabl e. If
MYFILE is a UD, no WITH claus e is allowe d, ie only EXECUTE “DELETE MYFILE”
EXECUTE “DELETE- FILE MYFILE”
EXECUTE “CLEAR- FILE MYFILE”
EXECUTE “CREATE- FILE MYFILE”
EXECUTE “CREATE- FILE MYFILE 1 1” H e r e the “1 1” is ignor e d
EXECUTE “CREATE- FILE MYFILE Type = U D” T h i s will crea t e a UD file wher e the key
tem n. t afj.r u n ti m e . di r e c t o r y.c u r r e n t points in the tafj.prop e r t i e s file
EXECUTE “CREATE- FILE MYFILE Type = ( CLOB |XML|BLOB|VARCHAR)” T h i s will cre a t e a table with
the given type. Only availabl e in TAFJ afte r R13.SP 2 and after.