zOs/REXX/WSHTTX
select creator ||']',name
from sysibm.systables
where creator = 'SYSIBM' and name like 'SYSTAB%'
$#out 20160812 15:37:48
scanErr ending Apostroph missing
last token ' scanPosition SY
pos 22 in line 3: where creator = 'SY
in wsh phase runSQL
$#out 20160812 15:37:12
fatal error in WST: SQLCODE = -104: ILLEGAL SYMBOL "<END-OF-STATEMENT>". SOME
SYMBOLS THAT MIGHT BE LEGAL ARE: + - ( TRIM XMLSERIALIZE CAST
XMLCAST CASE CURRENT_D
src select creator ||']' from sysibm.syst where creator =
> >>>pos 59 of 59>>>
sql = select creator ||']' from sysibm.syst where creator =
stmt = prepare s49 into :M.SQL.49.D from :src
with into :M.SQL.49.D = M.SQL.49.D
sqlCode 0: rollback
$#out 20160812 15:36:58
input error in WST: no rz/dbSys for 20
in wsh phase compile
$#out 20160812 15:34:26
COL1 NAME
SYSIBM ] SYSTABAUTH
SYSIBM ] SYSTABCONST
SYSIBM ] SYSTABLEPART
SYSIBM ] SYSTABLEPART_HIST
SYSIBM ] SYSTABLES
SYSIBM ] SYSTABLESPACE
SYSIBM] SYSTABLESPACESTATS
SYSIBM ] SYSTABLES_HIST
SYSIBM] SYSTABLES_PROFILES
SYSIBM ] SYSTABSTATS
SYSIBM ] SYSTABSTATS_HIST
11 rows fetched: select creator ||']',name from sysibm.systables where cre...
$#out 20160812 15:34:14
O.205.1=[COL1=SYSIBM ] NAME=SYSTABAUTH]
O.205.2=[COL1=SYSIBM ] NAME=SYSTABCONST]
O.205.3=[COL1=SYSIBM ] NAME=SYSTABLEPART]
O.205.4=[COL1=SYSIBM ] NAME=SYSTABLEPART_HIST]
O.205.5=[COL1=SYSIBM ] NAME=SYSTABLES]
O.205.6=[COL1=SYSIBM ] NAME=SYSTABLESPACE]
O.205.7=[COL1=SYSIBM] NAME=SYSTABLESPACESTATS]
O.205.8=[COL1=SYSIBM ] NAME=SYSTABLES_HIST]
O.205.9=[COL1=SYSIBM] NAME=SYSTABLES_PROFILES]
O.205.10=[COL1=SYSIBM ] NAME=SYSTABSTATS]
O.205.11=[COL1=SYSIBM ] NAME=SYSTABSTATS_HIST]
11 rows fetched: select creator ||']',name from sysibm.systables where cre...
$#out 20160812 15:33:45
O.205.1=[CREATOR=SYSIBM NAME=SYSTABAUTH]
O.205.2=[CREATOR=SYSIBM NAME=SYSTABCONST]
O.205.3=[CREATOR=SYSIBM NAME=SYSTABLEPART]
O.205.4=[CREATOR=SYSIBM NAME=SYSTABLEPART_HIST]
O.205.5=[CREATOR=SYSIBM NAME=SYSTABLES]
O.205.6=[CREATOR=SYSIBM NAME=SYSTABLESPACE]
O.205.7=[CREATOR=SYSIBM NAME=SYSTABLESPACESTATS]
O.205.8=[CREATOR=SYSIBM NAME=SYSTABLES_HIST]
O.205.9=[CREATOR=SYSIBM NAME=SYSTABLES_PROFILES]
O.205.10=[CREATOR=SYSIBM NAME=SYSTABSTATS]
O.205.11=[CREATOR=SYSIBM NAME=SYSTABSTATS_HIST]
11 rows fetched: select creator,name from sysibm.systables where creator =...
$#out 20160812 15:32:20
--- row 1 ----------------------------------------------------------------------
CREATOR SYSIBM
NAME SYSTABAUTH
--- row 2 ----------------------------------------------------------------------
CREATOR SYSIBM
NAME SYSTABCONST
--- row 3 ----------------------------------------------------------------------
CREATOR SYSIBM
NAME SYSTABLEPART
--- row 4 ----------------------------------------------------------------------
CREATOR SYSIBM
NAME SYSTABLEPART_HIST
--- row 5 ----------------------------------------------------------------------
CREATOR SYSIBM
NAME SYSTABLES
--- row 6 ----------------------------------------------------------------------
CREATOR SYSIBM
NAME SYSTABLESPACE
--- row 7 ----------------------------------------------------------------------
CREATOR SYSIBM
NAME SYSTABLESPACESTATS
--- row 8 ----------------------------------------------------------------------
CREATOR SYSIBM
NAME SYSTABLES_HIST
--- row 9 ----------------------------------------------------------------------
CREATOR SYSIBM
NAME SYSTABLES_PROFILES
--- row 10 ---------------------------------------------------------------------
CREATOR SYSIBM
NAME SYSTABSTATS
--- row 11 ---------------------------------------------------------------------
CREATOR SYSIBM
NAME SYSTABSTATS_HIST
--- end of 11 rows -------------------------------------------------------------
11 rows fetched: select creator,name from sysibm.systables where creator =...
$#out 20160812 15:32:13
CREATOR
NAME
CREATO NAME
SYSIBM SYSTABAUTH
SYSIBM SYSTABCONST
SYSIBM SYSTABLEPART
SYSIBM SYSTABLEPART_HIST
SYSIBM SYSTABLES
SYSIBM SYSTABLESPACE
SYSIBM SYSTABLESPACESTATS
SYSIBM SYSTABLES_HIST
SYSIBM SYSTABLES_PROFILES
SYSIBM SYSTABSTATS
SYSIBM SYSTABSTATS_HIST
11 rows fetched: select creator,name from sysibm.systables where creator =...
$#out 20160812 15:32:04
CREATOR
NAME
CREATO NAME
SYSIBM SYSTABAUTH
SYSIBM SYSTABCONST
SYSIBM SYSTABLEPART
SYSIBM SYSTABLEPART_HIST
SYSIBM SYSTABLES
SYSIBM SYSTABLESPACE
SYSIBM SYSTABLESPACESTATS
SYSIBM SYSTABLES_HIST
SYSIBM SYSTABLES_PROFILES
SYSIBM SYSTABSTATS
SYSIBM SYSTABSTATS_HIST
11 rows fetched: select creator,name from sysibm.systables where creator =...
$#out 20160812 15:31:41
CREATOR NAME
SYSIBM SYSTABAUTH
SYSIBM SYSTABCONST
SYSIBM SYSTABLEPART
SYSIBM SYSTABLEPART_HIST
SYSIBM SYSTABLES
SYSIBM SYSTABLESPACE
SYSIBM SYSTABLESPACESTATS
SYSIBM SYSTABLES_HIST
SYSIBM SYSTABLES_PROFILES
SYSIBM SYSTABSTATS
SYSIBM SYSTABSTATS_HIST
11 rows fetched: select creator,name from sysibm.systables where creator =...
$#out 20160812 15:26:24
11 rows fetched: select creator,name from sysibm.systables where creator =...
$#out 20160812 15:20:48
11 rows fetched: select creator,name from sysibm.systables where creator =...
$#out