zOs/SQL/BINDXSE2

$#@
call sqlConnect dp4g
$;
$@#[
select '      , ''' || strip(pgm) || ''''
    from oa1p.tadm41bindParm
    group by pgm
    order by cast(pgm as varchar(8) ccsid ebcdic)

$]
$| call sqlSel $| call fmtFTab
$#out                                              20131115 14:50:40
COL1
      , '%'
      , 'AN5000'
      , 'AU5070'
      , 'AV373@I'
      , 'AV391@I'
      , 'AV403@I'
      , 'AV425@I'
      , 'AV5300'
      , 'AV5560'
      , 'AV7210'
      , 'AV7220'
      , 'AV8460'
      , 'AV8476'
      , 'AV8550'
      , 'BE5010'
      , 'BE5020'
      , 'BE5040'
      , 'BE5050'
      , 'BE5070'
      , 'BE5090'
      , 'BE5900'
      , 'BE5910'
      , 'BE5930'
      , 'BE5931'
      , 'BE5940'
      , 'BE5950'
      , 'BE7110'
      , 'BE7160'
      , 'BE7210'
      , 'BF0010'
      , 'BU012@I'
      , 'BU013@I'
      , 'BU021@I'
      , 'BU062@I'
      , 'CD9997'
      , 'FI5200'
      , 'FI7430'
      , 'FI8190'
      , 'ID6060'
      , 'ID6061'
      , 'KE5480'
      , 'NI5788'
      , 'NI8330'
      , 'NI8340'
      , 'NI8660'
      , 'NZ5820'
      , 'NZ6500'
      , 'OS7110'
      , 'OS7111'
      , 'PCA64@I'
      , 'PCA73@I'
      , 'PCB01@I'
      , 'PCB12@I'
      , 'PCB22@I'
      , 'PCB32@I'
      , 'PCB41@I'
      , 'PCB51@I'
      , 'PCB91@I'
      , 'PCC03@I'
      , 'PCC12@I'
      , 'PCC22@I'
      , 'PCC31@I'
      , 'PCC41@I'
      , 'PCC51@I'
      , 'PCC62@I'
      , 'PCC71@I'
      , 'PCC81@I'
      , 'PCE45@I'
      , 'PCE51@I'
      , 'PCG81@I'
      , 'PCG91@I'
      , 'PC5000'
      , 'PC5020'
      , 'PC5030'
      , 'PC5040'
      , 'PC5050'
      , 'PC5060'
      , 'PC5070'
      , 'PC5080'
      , 'PC5090'
      , 'PC5100'
      , 'PC5110'
      , 'PC5120'
      , 'PC5130'
      , 'PC5140'
      , 'PC5150'
      , 'PC5160'
      , 'PC5170'
      , 'PC5180'
      , 'PC5200'
      , 'PC5210'
      , 'PC5220'
      , 'PC5230'
      , 'PC5240'
      , 'PC5250'
      , 'PC5260'
      , 'PC5270'
      , 'PC5280'
      , 'PC5290'
      , 'PC5300'
      , 'PC5310'
      , 'PC5330'
      , 'PC5340'
      , 'PC5345'
      , 'PC5350'
      , 'PC5400'
      , 'PC7000'
      , 'PC7005'
      , 'PC7010'
      , 'PC7020'
      , 'PC7030'
      , 'PC7040'
      , 'PC7050'
      , 'PC7070'
      , 'PC7900'
      , 'PC8000'
      , 'PC8640'
      , 'PW6230'
      , 'PW6231'
      , 'PW6239'
      , 'PW9998'
      , 'PW9999'
      , 'RI0810'
      , 'WI8710'
      , 'WP0110'
      , 'WP0510'
      , 'WP0550'
      , 'XBIMN30'
      , 'XBIMN4'
      , 'XBIM02'
      , 'XBIM04'
      , 'XBIM041'
      , 'XBIM042'
      , 'XBMIGT1'
      , 'XBMIG04'
      , 'XBMQ400'
      , 'XB9020'
      , 'XB9040'
      , 'XCT002'
      , 'XC413@I'
      , 'XC5008'
      , 'XC6006'
      , 'YAUADCC'
      , 'YAUADCE'
      , 'YAUCORC'
      , 'YAUCRCE'
      , 'YAU016D'
      , 'YAU016F'
      , 'YAU016I'
      , 'YAU016S'
      , 'YAU016U'
      , 'YAU018D'
      , 'YAU018F'
      , 'YAU018I'
      , 'YAU018S'
      , 'YAU018U'
      , 'YAU019D'
      , 'YAU019F'
      , 'YAU019I'
      , 'YAU019S'
      , 'YAU019U'
      , 'YAU030D'
      , 'YAU030F'
      , 'YAU030I'
      , 'YAU030S'
      , 'YAU030U'
      , 'YAU180D'
      , 'YAU180F'
      , 'YAU180I'
      , 'YAU180S'
      , 'YAU180U'
      , 'YAU181D'
      , 'YAU181F'
      , 'YAU181I'
      , 'YAU181S'
      , 'YAU181U'
      , 'YAU190D'
      , 'YAU190F'
      , 'YAU190I'
      , 'YAU190S'
      , 'YAU190U'
      , 'YAU191D'
      , 'YAU191F'
      , 'YAU191I'
      , 'YAU191S'
      , 'YAU191U'
      , 'YAVAAAN'
      , 'YAVAAVL'
      , 'YAVANAN'
      , 'YAVA00'
      , 'YAVA01'
      , 'YAVA02'
      , 'YAVA03'
      , 'YAVA04'
      , 'YAVA05'
      , 'YAVA06'
      , 'YAVA07'
      , 'YAVA08'
      , 'YAVBDAN'
      , 'YAVBDVL'
      , 'YAVBELE'
      , 'YAVBVG'
      , 'YAVBWST'
      , 'YAVCBET'
      , 'YAVCBST'
      , 'YAVCOAN'
      , 'YAVCOBO'
      , 'YAVCPID'
      , 'YAVCUAN'
      , 'YAVDEFA'
      , 'YAVDUAN'
      , 'YAVERAN'
      , 'YAVERBA'
      , 'YAVERTR'
      , 'YAVERVL'
      , 'YAVFNAN'
      , 'YAVFSL'
      , 'YAVGAT'
      , 'YAVGDW'
      , 'YAVGMP'
      , 'YAVGPD'
      , 'YAVGPDD'
      , 'YAVGPDE'
      , 'YAVGPD2'
      , 'YAVGPD3'
      , 'YAVGPER'
      , 'YAVGPFD'
      , 'YAVGVW'
      , 'YAVMAT'
      , 'YAVMAVL'
      , 'YAVMUR'
      , 'YAVOVVW'
      , 'YAVPFX'
      , 'YAVREC1'
      , 'YAVREC2'
      , 'YAVSTA'
      , 'YAVVDPS'
      , 'YAVVDP2'
      , 'YAVVSRV'
      , 'YAVVTXT'
      , 'YAVWHGR'
      , 'YAVX001'
      , 'YAVX012'
      , 'YAVX035'
      , 'YAVX040'
      , 'YAV0065'
      , 'YAV0067'
      , 'YAV0083'
      , 'YAV0101'
      , 'YAV0112'
      , 'YAV0116'
      , 'YAV0123'
      , 'YAV0127'
      , 'YAV0128'
      , 'YAV0129'
      , 'YAV0131'
      , 'YAV0132'
      , 'YAV0133'
      , 'YAV0134'
      , 'YAV0135'
      , 'YAV0136'
      , 'YBEMB'
      , 'YBEM01'
      , 'YBEM02'
      , 'YBEM1DR'
      , 'YBEM2DR'
      , 'YBERR'
      , 'YBER02'
      , 'YBER02E'
      , 'YBER02F'
      , 'YBER03'
      , 'YBER03E'
      , 'YBER03F'
      , 'YBE00MB'
      , 'YBE00MC'
      , 'YBE00RR'
      , 'YBE24'
      , 'YBE25'
      , 'YBE26'
      , 'YBE27'
      , 'YCDOGEE'
      , 'YCDOGEX'
      , 'YCDSGET'
      , 'YCDUVGE'
      , 'YCKSCCA'
      , 'YCTM150'
      , 'YCTM151'
      , 'YCTM152'
      , 'YCTM200'
      , 'YCTM201'
      , 'YCTM202'
      , 'YCTM203'
      , 'YCTM204'
      , 'YCTM205'
      , 'YCTM206'
      , 'YCTM214'
      , 'YCTM215'
      , 'YCTM233'
      , 'YCTM400'
      , 'YCTSVPT'
      , 'YCTS100'
      , 'YCTS150'
      , 'YCTS200'
      , 'YCTS400'
      , 'YCTTRA'
      , 'YITMETA'
      , 'YITRFTG'
      , 'YITRFTS'
      , 'YNILCTG'
      , 'YNILOG'
      , 'YNI0161'
      , 'YNI107G'
      , 'YNI107U'
      , 'YPCCAHI'
      , 'YPCCORI'
      , 'YPCDURA'
      , 'YPCEVPO'
      , 'YPCLOCA'
      , 'YPCRUPD'
      , 'YPCSWCH'
      , 'YPC0500'
      , 'YPC0520'
      , 'YPC0530'
      , 'YPC0540'
      , 'YPC0550'
      , 'YPC0580'
      , 'YPC0590'
      , 'YPC0600'
      , 'YPC0610'
      , 'YPC0620'
      , 'YPC0640'
      , 'YPC0650'
      , 'YPC0660'
      , 'YPC0680'
      , 'YPC0690'
      , 'YPC0700'
      , 'YPC0720'
      , 'YPC0730'
      , 'YPC0740'
      , 'YPC0750'
      , 'YPC0760'
      , 'YPC0770'
      , 'YPC0790'
      , 'YPC0800'
      , 'YPC0820'
      , 'YPC0830'
      , 'YPC0840'
      , 'YPC0850'
      , 'YPC0860'
      , 'YPC0880'
      , 'YPC0890'
      , 'YPC1010'
      , 'YPC1020'
      , 'YPC1030'
      , 'YUU1016'
      , 'YUU1020'
      , 'YUU1021'
      , 'YUU1022'
      , 'YUU1023'
      , 'YWQBERI'
      , 'YXAUECE'
      , 'YXAUENC'
      , 'YXAUEN2'
      , 'YXAUGED'
      , 'YXAUGOD'
      , 'YXB9021'
      , 'YXB9022'
      , 'YXB9023'
      , 'YXB9024'
      , 'YXB9025'
      , 'YXCE03L'
      , 'YXCE08L'
      , 'YYAUATR'
      , 'YYAUAT0'
      , 'YYWM05E'
      , 'YYWM51E'
$#out                                              20131115 14:50:10