/* REXX TBSORT Sort an ISPF table. If the sort sequence is not specified, TBLGEN is interrogated to find the default sequence. Written by Frank Clarke 20070417 Impact Analysis . SYSEXEC TRAPOUT . SYSEXEC TBLGEN Modification History ccyymmdd xxx ..... .... */ arg argline address TSO /* REXXSKEL ver.20040227 */ arg parms "((" opts signal on syntax signal on novalue call TOOLKIT_INIT /* conventional start-up -*/ rc = Trace("O"); rc = Trace(tv) info = parms /* to enable parsing */ call A_INIT /* */ call B_TABLE_OPS /* */ if \sw.nested then call DUMP_QUEUE /* -*/ exit /*@ TBSORT */ /* . ----------------------------------------------------------------- */ A_INIT: /*@ */ if branch then call BRANCH address TSO call AA_SETUP_LOG /* */ parse value "" with, sortspec tbltype helpmsg , $tn$ isptlib tbldata openmode.0 = "WRITE" /* based on NOUPDT */ openmode.1 = "NOWRITE" call AK_KEYWDS /* */ return /*@ A_INIT */ /* . ----------------------------------------------------------------- */ AA_SETUP_LOG: /*@ */ if branch then call BRANCH address TSO parse value "0" with, log# log. parse value Date("S") Time("S") Time("N") with, yyyymmdd sssss hhmmss . parse var yyyymmdd 4 yrdigit 5 mm 7 dd /* 9 12 14 maybe */ if Pos(yrdigit,"13579") > 0 then mm = mm + 12 /* mm=24 */ logtag = Substr("ABCDEFGHIJKLMNOPQRSTUVWX",mm,1) /* logtag=X */ subid = logtag""dd""Right(sssss,5,0) /* X1423722 ? */ vb4k.0 = "NEW CATALOG UNIT(SYSDA) SPACE(1 5) TRACKS", "RECFM(V B) LRECL(4096) BLKSIZE(0)" vb4k.1 = "SHR" /* if it already exists... */ logdsn = "@@LOG."exec_name"."subid".#CILIST" call ZL_LOGMSG(exec_name "started by" Userid() yyyymmdd hhmmss) call ZL_LOGMSG("Arg:" argline) return /*@ AA_SETUP_LOG */ /* . ----------------------------------------------------------------- */ AK_KEYWDS: /*@ */ if branch then call BRANCH address TSO parse value KEYWD("TABLE") "?" with , $tn$ . parse value KEYWD("IN") "?" with , isptlib . parse value KEYWD("TYPE") "?" with , tbltype . sortspec = KEYPHRS("TO") if sortspec = "" then, sortspec = "DEFAULT" if WordPos( "?",$tn$ isptlib tbltype ) > 0 then, helpmsg = "TABLE, IN, and TYPE are required parameters. " if helpmsg <> "" then, call HELP /* ...and don't come back */ tag = exec_name "("BRANCH("ID")")" call ZL_LOGMSG( tag "Using table" $tn$ "in" isptlib ) call ZL_LOGMSG( tag "Table-type is" tbltype ) if sortspec <> "DEFAULT" then, call ZL_LOGMSG( tag "Sort spec is" sortspec ) return /*@ AK_KEYWDS */ /* . ----------------------------------------------------------------- */ B_TABLE_OPS: /*@ */ if branch then call BRANCH address TSO call BA_OPEN /* open the table */ if \sw.0error_found then, call BS_SORT /* sort the table */ call BZ_CLOSE /* close the table */ return /*@ B_TABLE_OPS */ /* . ----------------------------------------------------------------- */ BA_OPEN: /*@ */ if branch then call BRANCH address ISPEXEC tag = exec_name "("BRANCH("ID")")" "LIBDEF ISPTLIB DATASET ID("isptlib") STACK" "TBSTATS" $tn$ "STATUS1(s1) STATUS2(s2)" if s1 > 1 then do say "Table" $tn$ "not available." zerrsm = "Table" $tn$ "not available." zerrlm = "Table" $tn$ "not found in the ISPTLIB library chain" call ZL_LOGMSG( tag zerrlm ) sw.0error_found = "1"; return end; else, if s2 = 1 then do "TBOPEN " $tn$ openmode.noupdt end else "TBTOP" $tn$ "LIBDEF ISPTLIB" return /*@ BA_OPEN */ /* Sort the table. contains the sortspec in the format: {, { } } If is specified, it must be A or D. Additional sortspecs may be appended. . ----------------------------------------------------------------- */ BS_SORT: /*@ */ if branch then call BRANCH address ISPEXEC call BSD_DESCRIBE /* sets ORIGSORT -*/ text = sortspec /* set up for parsing */ origtext = text sortspec = "" tag = exec_name "("BRANCH("ID")")" if origtext = "DEFAULT" then, sortspec = origsort else, do while text <> "" parse var text spec text /* isolate next spec */ parse var spec fld "," dir if fld = "" then do zerrsm = "Error in SORT specification" zerrlm = "You specified:", "<"Strip(origtext)">. ", " SORT specifications must contain table", "field names with optional directional indicators,", "(e.g.) 'ZORT,A BLAT GORF,D'. " exec_name, "detected a missing field-name." "SETMSG MSG(ISRZ002)" call ZL_LOGMSG( tag zerrlm ) return end /* no fld ! */ if Wordpos(fld,keys names) = 0 then do zerrsm = "Error in SORT specification" zerrlm = "You specified:", "<"Strip(origtext)">. ", " SORT specifications must contain table", "field names with optional directional indicators,", "(e.g.) 'ZORT,A BLAT GORF,D'. " exec_name, "detected an incorrect field-name. ", "The valid field-names are:" , "<"Strip(keys names)">." "SETMSG MSG(ISRZ002)" call ZL_LOGMSG( tag zerrlm ) return end /* unknown field name */ parse value dir "A" with dir . /* default to A */ if Wordpos(dir,"A D") = 0 then do zerrsm = "Error in SORT specification" zerrlm = "You specified:", "<"Strip(origtext)">. ", " SORT specifications must contain table", "field names with optional directional indicators.", " Directional indicators may be either A or D. ", exec_name "detected an incorrect directional", "indicator." "SETMSG MSG(ISRZ002)" call ZL_LOGMSG( tag zerrlm ) return end /* bad dir ! */ sortspec = sortspec fld",C,"dir end /* text */ sortspec = Strip(sortspec) sortspec = Translate(sortspec , "," , " ") call ZL_LOGMSG( tag "Final SORTSPEC:" sortspec ) "TBSORT" $tn$ "FIELDS("sortspec")" if rc = 0 then do zerrsm = "Sorted" zerrlm = "Table" $tn$ "was successfully sorted to ", "new order" sortspec "SETMSG MSG(ISRZ002)" end else do zerrsm = "Sort failed" zerrlm = "Sort of table" $tn$ "to ", "new order" sortspec "returned RC="rc "SETMSG MSG(ISRZ002)" end return /*@ BS_SORT */ /* Ask TBLGEN to describe the table. . ----------------------------------------------------------------- */ BSD_DESCRIBE: /*@ */ if branch then call BRANCH address TSO "NEWSTACK" "TBLGEN" tbltype "DESCRIBE" pull tbldata "DELSTACK" parse var tbldata "KEYS(" keys ")" , "NAMES(" names ")" , "SORT(" origsort ")" return /*@ BSD_DESCRIBE */ /* . ----------------------------------------------------------------- */ BZ_CLOSE: /*@ */ if branch then call BRANCH address ISPEXEC "LIBDEF ISPTABL DATASET ID("isptlib") STACK" "TBCLOSE" $tn$ "LIBDEF ISPTABL" return /*@ BZ_CLOSE */ /* . ----------------------------------------------------------------- */ LOCAL_PREINIT: /*@ customize opts */ address TSO return /*@ LOCAL_PREINIT */ /* subroutines below LOCAL_PREINIT are not selected by SHOWFLOW */ /* . ----------------------------------------------------------------- */ ZB_SAVELOG: /*@ */ if branch then call BRANCH address TSO if Symbol("LOG#") = "LIT" then return /* not yet set */ "ALLOC FI($LOG) DA("logdsn") REU" vb4k.0 "EXECIO" log# "DISKW $LOG (STEM LOG. FINIS" "FREE FI($LOG)" return /*@ ZB_SAVELOG */ /* . ----------------------------------------------------------------- */ ZL_LOGMSG: Procedure expose, /*@ */ (tk_globalvars) log. log# rc = Trace("O") address TSO parse arg msgtext parse value log#+1 msgtext with, zz log.zz 1 log# . if monitor then say, msgtext return /*@ ZL_LOGMSG */ /* . ----------------------------------------------------------------- */ HELP: /*@ */ address TSO;"CLEAR" ; say "" if helpmsg <> "" then do ; say helpmsg; say ""; end ex_nam = Left(exec_name,8) /* predictable size */ say " "ex_nam" Sort an ISPF table. If the sort sequence is not " say " specified, TBLGEN is interrogated to find the default " say " sequence. " say " " say " Syntax: "ex_nam" (Required)" say " (Required)" say " (Choose)" say " (Choose)" say " " say " tblname identifies the table to be sorted. " say " " say " library names the ISPF table library dataset. " say " " say " srtspec specifies the order to which the table is to " say " be sorted. " say " " say " tbltype identifies a key on table AAMSTR from which the " say " sort sequence will be extracted. " say " " say " Either or must be specified. " "NEWSTACK"; pull ; "CLEAR" ; "DELSTACK" say " Debugging tools provided include: " say " " say " MONITOR: displays key information throughout processing. " say " " say " NOUPDT: by-pass all update logic. " say " " say " BRANCH: show all paragraph entries. " say " " say " TRACE tv: will use value following TRACE to place the " say " execution in REXX TRACE Mode. " say " " say " " say " Debugging tools can be accessed in the following manner: " say " " say " TSO "ex_nam" parameters (( debug-options " say " " say " For example: " say " " say " TSO "ex_nam" (( MONITOR TRACE ?R " if sw.inispf then, address ISPEXEC "CONTROL DISPLAY REFRESH" exit /*@ HELP */ /* . ----------------------------------------------------------------- */ BRANCH: Procedure expose, /*@ */ sigl exec_name rc = trace("O") /* we do not want to see this */ arg brparm . origin = sigl /* where was I called from ? */ do currln = origin to 1 by -1 /* inch backward to label */ if Right(Word(Sourceline(currln),1),1) = ":" then do parse value sourceline(currln) with pgfname ":" . /* Label */ leave ; end /* name */ end /* currln */ select when brparm = "NAME" then return(pgfname) /* Return full name */ when brparm = "ID" then do /* wants the prefix */ parse var pgfname pgfpref "_" . /* get the prefix */ return(pgfpref) end /* brparm = "ID" */ otherwise say left(sigl,6) left(pgfname,40) exec_name "Time:" time("L") end /* select */ return /*@ BRANCH */ /* . ----------------------------------------------------------------- */ DUMP_QUEUE: /*@ Take whatever is in stack */ rc = trace("O") /* and write to the screen */ address TSO arg mode . "QSTACK" /* how many stacks? */ stk2dump = rc - tk_init_stacks /* remaining stacks */ if stk2dump = 0 & queued() = 0 then return if mode <> "QUIET" then, say "Total Stacks" rc , /* rc = #of stacks */ " Begin Stacks" tk_init_stacks , /* Stacks present at start */ " Excess Stacks to dump" stk2dump do dd = rc to tk_init_stacks by -1 /* empty each one. */ if mode <> "QUIET" then, say "Processing Stack #" dd " Total Lines:" queued() do queued();parse pull line;say line;end /* pump to the screen */ "DELSTACK" /* remove stack */ end /* dd = 1 to rc */ return /*@ DUMP_QUEUE */ /* Handle CLIST-form keywords added 20020513 . ----------------------------------------------------------------- */ CLKWD: Procedure expose info /*@ hide all except info */ arg kw kw = kw"(" /* form is 'KEY(DATA)' */ kw_pos = Pos(kw,info) /* find where it is, maybe */ if kw_pos = 0 then return "" /* send back a null, not found*/ rtpt = Pos(") ",info" ",kw_pos) /* locate end-paren */ slug = Substr(info,kw_pos,rtpt-kw_pos+1) /* isolate */ info = Delstr(info,kw_pos,rtpt-kw_pos+1) /* excise */ parse var slug (kw) slug /* drop kw */ slug = Reverse(Substr(Reverse(Strip(slug)),2)) return slug /*@CLKWD */ /* Handle multi-word keys 20020513 . ----------------------------------------------------------------- */ KEYWD: Procedure expose info /*@ hide all vars, except info*/ arg kw /* form is 'KEY DATA' */ kw_pos = wordpos(kw,info) /* find where it is, maybe */ if kw_pos = 0 then return "" /* send back a null, not found*/ kw_val = word(info,kw_pos+Words(kw))/* get the next word */ info = Delword(info,kw_pos,2) /* remove both */ return kw_val /*@ KEYWD */ /* . ----------------------------------------------------------------- */ KEYPHRS: Procedure expose, /*@ */ info helpmsg exec_name /* except these three */ arg kp /* form is 'KEY ;: DATA ;:' */ wp = wordpos(kp,info) /* where is it? */ if wp = 0 then return "" /* not found */ front = subword(info,1,wp-1) /* everything before kp */ back = subword(info,wp+1) /* everything after kp */ parse var back dlm back /* 1st token must be 2 bytes */ if length(dlm) <> 2 then /* Must be two bytes */ helpmsg = helpmsg "Invalid length for delimiter("dlm") with KEYPHRS("kp")" if wordpos(dlm,back) = 0 then /* search for ending delimiter*/ helpmsg = helpmsg "No matching second delimiter("dlm") with KEYPHRS("kp")" if helpmsg <> "" then call HELP /* Something is wrong */ parse var back kpval (dlm) back /* get everything b/w delim */ info = front back /* restore remainder */ return Strip(kpval) /*@ KEYPHRS */ /* . ----------------------------------------------------------------- */ NOVALUE: /*@ */ say exec_name "raised NOVALUE at line" sigl say " " say "The referenced variable is" condition("D") say " " zsigl = sigl signal SHOW_SOURCE /*@ NOVALUE */ /* . ----------------------------------------------------------------- */ SHOW_SOURCE: /*@ */ call DUMP_QUEUE /* Spill contents of stacks -*/ if sourceline() <> "0" then /* to screen */ say sourceline(zsigl) rc = trace("?R") nop exit /*@ SHOW_SOURCE */ /* . ----------------------------------------------------------------- */ SS: Procedure /*@ Show Source */ arg ssbeg ssct . /* 'call ss 122 6' maybe */ if ssct = "" then ssct = 10 if \datatype(ssbeg,"W") | \datatype(ssct,"W") then return ssend = ssbeg + ssct do ssii = ssbeg to ssend ; say Strip(sourceline(ssii),'T') ; end return /*@ SS */ /* . ----------------------------------------------------------------- */ SWITCH: Procedure expose info /*@ */ arg kw /* form is 'KEY' */ sw_val = Wordpos(kw,info) > 0 /* exists = 1; not found = 0 */ if sw_val then /* exists */ info = Delword(info,Wordpos(kw,info),1) /* remove it */ return sw_val /*@ SWITCH */ /* . ----------------------------------------------------------------- */ SYNTAX: /*@ */ errormsg = exec_name "encountered REXX error" rc "in line" sigl":", errortext(rc) say errormsg zsigl = sigl signal SHOW_SOURCE /*@ SYNTAX */ /* Can call TRAPOUT. . ----------------------------------------------------------------- */ TOOLKIT_INIT: /*@ */ address TSO info = Strip(opts,"T",")") /* clip trailing paren */ parse source sys_id how_invokt exec_name DD_nm DS_nm, as_invokt cmd_env addr_spc usr_tokn parse value "" with tv helpmsg . parse value 0 "ISR00000 YES" "Error-Press PF1" with, sw. zerrhm zerralrm zerrsm if SWITCH("TRAPOUT") then do "TRAPOUT" exec_name parms "(( TRACE R" info exit end /* trapout */ sw.nested = sysvar("SYSNEST") = "YES" sw.batch = sysvar("SYSENV") = "BACK" sw.inispf = sysvar("SYSISPF") = "ACTIVE" if Word(parms,1) = "?" then call HELP /* I won't be back */ "QSTACK" ; tk_init_stacks = rc /* How many stacks? */ parse value SWITCH("BRANCH") SWITCH("MONITOR") SWITCH("NOUPDT") with, branch monitor noupdt . parse value mvsvar("SYSNAME") sysvar("SYSNODE") with, #tk_cpu node . parse value KEYWD("TRACE") "O" with tv . tk_globalvars = "exec_name tv helpmsg sw. zerrhm zerralrm ", "zerrsm zerrlm tk_init_stacks branch monitor ", "noupdt" call LOCAL_PREINIT /* for more opts -*/ return /*@ TOOLKIT_INIT */