file browser

zOs/REXX/TBCNT

$#@
call sqlConnect 'DBAF'
$;
$<#[
select creator, name
    from sysibm.sysTables
    where dbName = 'PTDB'
    order by 2
$] call sqlSel
$|
$@forWith i $@[
    r = $CREATOR'.'$NAME sql2one('select count(*) from' ,
                                       $CREATOR'.'$NAME)
    say r
    $$- r
$]
$#out                                              20120919 14:21:02
PTI.ACCUM_STRATEGY 0
PTI.ALOGFILE 0
PTI.ALOGRANGE 0
PTI.BPLOG_0203 89
PTI.OFS_PK 105
PTI.OFS_RT 328
PTI.PTALT_ACM_0160 0
PTI.PTALT_SYSTBL_0160 0
PTI.PTAN_PRFM_0201 0
PTI.PTAN_PRFM_1200 0
PTI.PTAN_SQL_0201 0
PTI.PTAN_SQL_1200 0
PTI.PTAN_STMT_0201 0
PTI.PTAN_STMT_1200 0
PTI.PTDC1_STRAT_0100 0
PTI.PTGEN_AUTH_0100 0
PTI.PTGEN_DEFAULT_0100 0
PTI.PTGL500_HISTORY 0
PTI.PTGL600_RESTART 0
PTI.PTGL600_RESTART2 0
PTI.PT24G_BACKUP2_0202 0
PTI.PTLOG_BACKUP_0202 0
PTI.PTLOG_CTSTATS_1105 0
PTI.PTLOG_DASTATS_1105 0
PTI.PTLOG_MAIN_1500 1008
PTI.PTLOG_RDAMSG_1105 1
PTI.PTLOG_SEC_0102 0
PTI.PTMG1_STRAT_0200 171
PTI.PTMG2_ALTER_0200 212
PTI.PTMG4_RULES_0300 4
PTI.PTMG5_GLOBAL_0400 14
PTI.PTMG7_GROUP_0400 1
PTI.PTMG8_OUTPUT_0401 0
PTI.PTMG9_MASK_0510 8
PTI.PTMGA_LNAME_0200 33
PTI.PTMGB_APTABLE_0100 1
PTI.PTMGB_SPTABLE_0100 43
PTI.PTMGB_UPTABLE_0100 1
*** run error ***
SQLCODE = -766: THE OBJECT OF A STATEMENT IS A TABLE FOR
    WHICH THE REQUESTED OPERATION IS NOT PERMITTED
stmt = prepare s11 into :M.SQL.11.D from :src
with into :M.SQL.11.D = M.SQL.11.D
     from :src = select count(*) from PTI.PTMGE_STRAUX_0200
$#out                                              20120919 14:20:34
*** run error ***
SQLCODE = -766: THE OBJECT OF A STATEMENT IS A TABLE FOR
    WHICH THE REQUESTED OPERATION IS NOT PERMITTED
stmt = prepare s11 into :M.SQL.11.D from :src
with into :M.SQL.11.D = M.SQL.11.D
     from :src = select count(*) from PTI.PTMGE_STRAUX_0200
$#out                                              20120919 14:14:28
@O.172.1 class=SQL172, CREATOR=PTI, NAME=ACCUM_STRATEGY
@O.172.2 class=SQL172, CREATOR=PTI, NAME=ALOGFILE
@O.172.3 class=SQL172, CREATOR=PTI, NAME=ALOGRANGE
@O.172.4 class=SQL172, CREATOR=PTI, NAME=BPLOG_0203
@O.172.5 class=SQL172, CREATOR=PTI, NAME=OFS_PK
@O.172.6 class=SQL172, CREATOR=PTI, NAME=OFS_RT
@O.172.7 class=SQL172, CREATOR=PTI, NAME=PTALT_ACM_0160
@O.172.8 class=SQL172, CREATOR=PTI, NAME=PTALT_SYSTBL_0160
@O.172.9 class=SQL172, CREATOR=PTI, NAME=PTAN_PRFM_0201
@O.172.10 class=SQL172, CREATOR=PTI, NAME=PTAN_PRFM_1200
@O.172.11 class=SQL172, CREATOR=PTI, NAME=PTAN_SQL_0201
@O.172.12 class=SQL172, CREATOR=PTI, NAME=PTAN_SQL_1200
@O.172.13 class=SQL172, CREATOR=PTI, NAME=PTAN_STMT_0201
@O.172.14 class=SQL172, CREATOR=PTI, NAME=PTAN_STMT_1200
@O.172.15 class=SQL172, CREATOR=PTI, NAME=PTDC1_STRAT_0100
@O.172.16 class=SQL172, CREATOR=PTI, NAME=PTGEN_AUTH_0100
@O.172.17 class=SQL172, CREATOR=PTI, NAME=PTGEN_DEFAULT_0100
@O.172.18 class=SQL172, CREATOR=PTI, NAME=PTGL500_HISTORY
@O.172.19 class=SQL172, CREATOR=PTI, NAME=PTGL600_RESTART
@O.172.20 class=SQL172, CREATOR=PTI, NAME=PTGL600_RESTART2
@O.172.21 class=SQL172, CREATOR=PTI, NAME=PTLOG_BACKUP2_0202
@O.172.22 class=SQL172, CREATOR=PTI, NAME=PTLOG_BACKUP_0202
@O.172.23 class=SQL172, CREATOR=PTI, NAME=PTLOG_CTSTATS_1105
@O.172.24 class=SQL172, CREATOR=PTI, NAME=PTLOG_DASTATS_1105
@O.172.25 class=SQL172, CREATOR=PTI, NAME=PTLOG_MAIN_1500
@O.172.26 class=SQL172, CREATOR=PTI, NAME=PTLOG_RDAMSG_1105
@O.172.27 class=SQL172, CREATOR=PTI, NAME=PTLOG_SEC_0102
@O.172.28 class=SQL172, CREATOR=PTI, NAME=PTMG1_STRAT_0200
@O.172.29 class=SQL172, CREATOR=PTI, NAME=PTMG2_ALTER_0200
@O.172.30 class=SQL172, CREATOR=PTI, NAME=PTMG4_RULES_0300
@O.172.31 class=SQL172, CREATOR=PTI, NAME=PTMG5_GLOBAL_0400
@O.172.32 class=SQL172, CREATOR=PTI, NAME=PTMG7_GROUP_0400
@O.172.33 class=SQL172, CREATOR=PTI, NAME=PTMG8_OUTPUT_0401
@O.172.34 class=SQL172, CREATOR=PTI, NAME=PTMG9_MASK_0510
@O.172.35 class=SQL172, CREATOR=PTI, NAME=PTMGA_LNAME_0200
@O.172.36 class=SQL172, CREATOR=PTI, NAME=PTMGB_APTABLE_0100
@O.172.37 class=SQL172, CREATOR=PTI, NAME=PTMGB_SPTABLE_0100
@O.172.38 class=SQL172, CREATOR=PTI, NAME=PTMGB_UPTABLE_0100
@O.172.39 class=SQL172, CREATOR=PTI, NAME=PTMGE_STRAUX_0200
@O.172.40 class=SQL172, CREATOR=PTI, NAME=PTMGE_STRINGS_0200
@O.172.41 class=SQL172, CREATOR=PTI, NAME=PTMOD_UTLSYM_0401
@O.172.42 class=SQL172, CREATOR=PTI, NAME=PTPA_AUTOHVER_1200
@O.172.43 class=SQL172, CREATOR=PTI, NAME=PTPA_ES_EXPL_1500
@O.172.44 class=SQL172, CREATOR=PTI, NAME=PTPA_ES_EXSRC_1200
@O.172.45 class=SQL172, CREATOR=PTI, NAME=PTPA_ES_IMSQL_1200
@O.172.46 class=SQL172, CREATOR=PTI, NAME=PTPA_ES_RU2RE_1200
@O.172.47 class=SQL172, CREATOR=PTI, NAME=PTPA_ES_RULES_1200
@O.172.48 class=SQL172, CREATOR=PTI, NAME=PTPA_ES_RULID_1200
@O.172.49 class=SQL172, CREATOR=PTI, NAME=PTPA_ES_STRAT_1200
@O.172.50 class=SQL172, CREATOR=PTI, NAME=PTPA_ES_VOUTP_1200
@O.172.51 class=SQL172, CREATOR=PTI, NAME=PTPA_EXCPT_1200
@O.172.52 class=SQL172, CREATOR=PTI, NAME=PTPA_EXPLPROF_1200
@O.172.53 class=SQL172, CREATOR=PTI, NAME=PTPMM_PURGE_0510
@O.172.54 class=SQL172, CREATOR=PTI, NAME=PTPRI_KEYCOLS_0100
@O.172.55 class=SQL172, CREATOR=PTI, NAME=PTPRI_SYSCOLS_0100
@O.172.56 class=SQL172, CREATOR=PTI, NAME=PTPRI_SYSFKEY_0100
@O.172.57 class=SQL172, CREATOR=PTI, NAME=PTPRI_SYSINDX_0100
@O.172.58 class=SQL172, CREATOR=PTI, NAME=PTPRI_SYSKEYS_0100
@O.172.59 class=SQL172, CREATOR=PTI, NAME=PTPRI_SYSRELS_0100
@O.172.60 class=SQL172, CREATOR=PTI, NAME=PTPRI_TABKEYS_0100
@O.172.61 class=SQL172, CREATOR=PTI, NAME=PTPS_DBASTATS_1200
@O.172.62 class=SQL172, CREATOR=PTI, NAME=PTPS_MASKS_0702
@O.172.63 class=SQL172, CREATOR=PTI, NAME=PTPS_OBJECTS_0702
@O.172.64 class=SQL172, CREATOR=PTI, NAME=PTPS_STRAT_0702
@O.172.65 class=SQL172, CREATOR=PTI, NAME=PTPS_SYSSTATS_0702
@O.172.66 class=SQL172, CREATOR=PTI, NAME=PTRA_SYSCOPY_0301
@O.172.67 class=SQL172, CREATOR=PTI, NAME=PTRCE_OPTION_0103
@O.172.68 class=SQL172, CREATOR=PTI, NAME=PTRCQ_DESC_0200
@O.172.69 class=SQL172, CREATOR=PTI, NAME=PTRCQ_SAVED_RPTS
@O.172.70 class=SQL172, CREATOR=PTI, NAME=PTRI_PSFKEY_0100
@O.172.71 class=SQL172, CREATOR=PTI, NAME=PTRI_PSSYSCOL_0100
@O.172.72 class=SQL172, CREATOR=PTI, NAME=PTRU2_DROPR_0202
@O.172.73 class=SQL172, CREATOR=PTI, NAME=PTSE_AD_PREFX_0105
@O.172.74 class=SQL172, CREATOR=PTI, NAME=PTSE_AD_PREFX_NFM
@O.172.75 class=SQL172, CREATOR=PTI, NAME=PTSQL_DATA_0102
@O.172.76 class=SQL172, CREATOR=PTI, NAME=PTSQL_DATA_115
@O.172.77 class=SQL172, CREATOR=PTI, NAME=PTSQL_TEXT_0101
@O.172.78 class=SQL172, CREATOR=PTI, NAME=PTSQL_TEXT_115
@O.172.79 class=SQL172, CREATOR=PTI, NAME=PTSSC_STRAT_0200
@O.172.80 class=SQL172, CREATOR=PTI, NAME=PTSYS_DEFAULT_0100
@O.172.81 class=SQL172, CREATOR=PTI, NAME=PVPA_ES_EXPL_1500
@O.172.82 class=SQL172, CREATOR=PTI, NAME=RACA_CONN_1105
@O.172.83 class=SQL172, CREATOR=PTI, NAME=RACD_STATS_1105
@O.172.84 class=SQL172, CREATOR=PTI, NAME=RACL_STATS_1105
@O.172.85 class=SQL172, CREATOR=PTI, NAME=RACN_CONN_1105
@O.172.86 class=SQL172, CREATOR=PTI, NAME=RACP_PROCD_1105
@O.172.87 class=SQL172, CREATOR=PTI, NAME=RACR_PROC_1105
@O.172.88 class=SQL172, CREATOR=PTI, NAME=RAEP_PROC_1105
@O.172.89 class=SQL172, CREATOR=PTI, NAME=RAFQ_STATS_1105
@O.172.90 class=SQL172, CREATOR=PTI, NAME=RAIK_STATS_1105
@O.172.91 class=SQL172, CREATOR=PTI, NAME=RAIX_STATS_1105
@O.172.92 class=SQL172, CREATOR=PTI, NAME=RAOS_PROC_1105
@O.172.93 class=SQL172, CREATOR=PTI, NAME=RARP_PROCD_1105
@O.172.94 class=SQL172, CREATOR=PTI, NAME=RATB_STATS_1105
@O.172.95 class=SQL172, CREATOR=PTI, NAME=RATS_STATS_1105
@O.172.96 class=SQL172, CREATOR=PTI, NAME=RAUT_HIST_1105
@O.172.97 class=SQL172, CREATOR=PTI, NAME=RAVL_STATS_1105
$#out                                              20120919 14:13:57
*** run error ***
no class found for object M.SQL.CONNECTION
$#out                                              20120919 14:13:45
$#out