home *** CD-ROM | disk | FTP | other *** search
/ OS/2 Shareware BBS: 10 Tools / 10-Tools.zip / GPF.ZIP / DLL / GPFDLL02.BND (.txt) < prev    next >
DB2 Bind  |  1991-04-02  |  3KB  |  68 lines
  1. GPFDLL02GB6SKCEHUSERID  0
  2. INCLUDE SQLCA
  3. INCLUDE SQLDA
  4. BEGIN DECLARE SECTION
  5. END DECLARE SECTION
  6. DECLARE C1 CURSOR FOR      SELECT NAME,CREATOR,REMARKS      FROM SYSIBM.SYSTABLES      WHERE (CREATOR <> 'SYSIBM' AND      CREATOR <> 'QRWSYS')      ORDER BY NAME,CREATOR
  7. OPEN C1
  8. FETCH C1 INTO      :SYSTABLES_NAME ,:SYSTABLES_CREATOR ,      :SYSTABLES_REMARKS:SYSTABLES_REMARKS_NULL
  9. CLOSE C1
  10. COMMIT WORK
  11. DECLARE C2 CURSOR FOR      SELECT NAME,COLTYPE,LENGTH,SCALE,NULLS,CODEPAGE      FROM SYSIBM.SYSCOLUMNS      WHERE (TBNAME = :SYSTABLES_NAME)      ORDER BY NAME
  12. OPEN C2
  13. FETCH C2 INTO      :SYSCOLUMNS_NAME ,      :SYSCOLUMNS_COLTYPE ,      :SYSCOLUMNS_LENGTH ,      :SYSCOLUMNS_SCALE ,      :SYSCOLUMNS_NULLS ,      :SYSCOLUMNS_CODEPAGE
  14. CLOSE C2
  15. COMMIT WORK
  16. DECLARE C0 CURSOR FOR         SELECT NAME,CREATOR,REMARKS         FROM SYSIBM.SYSTABLES         WHERE (CREATOR <> 'SYSIBM' AND         CREATOR <> 'QRWSYS')
  17. OPEN C0
  18. CLOSE C0
  19. COMMIT WORK
  20. ROLLBACK
  21. GRANT EXECUTE ON PROGRAM GPFDLL02 TO PUBLIC
  22. SYSCOLUMNS_AVGCOLLEN
  23. SYSCOLUMNS_CODEPAGE
  24. SYSCOLUMNS_COLCARD
  25. SYSCOLUMNS_COLNO
  26. SYSCOLUMNS_COLTYPE
  27. SYSCOLUMNS_DBCSCODEPG
  28. SYSCOLUMNS_HIGH2KEY
  29. SYSCOLUMNS_KEYSEQ
  30. SYSCOLUMNS_KEYSEQ_NULL
  31. SYSCOLUMNS_LENGTH
  32. SYSCOLUMNS_LOW2KEY
  33. SYSCOLUMNS_NAME
  34. SYSCOLUMNS_NULLS
  35. SYSCOLUMNS_REMARKS
  36. SYSCOLUMNS_REMARKS_NULL
  37. SYSCOLUMNS_SCALE
  38. SYSCOLUMNS_TBCREATOR
  39. SYSCOLUMNS_TBNAME
  40. SYSTABLES_CARD
  41. SYSTABLES_CHILDREN
  42. SYSTABLES_CHILDREN_NULL
  43. SYSTABLES_COLCOUNT
  44. SYSTABLES_CREATOR
  45. SYSTABLES_CTIME
  46. SYSTABLES_FID
  47. SYSTABLES_FPAGES
  48. SYSTABLES_KEYCOLUMNS
  49. SYSTABLES_KEYCOLUMNS_NULL
  50. SYSTABLES_KEYOBID
  51. SYSTABLES_KEYOBID_NULL
  52. SYSTABLES_NAME
  53. SYSTABLES_NPAGES
  54. SYSTABLES_OVERFLOW
  55. SYSTABLES_PACKED_DESC
  56. SYSTABLES_PARENTS
  57. SYSTABLES_PARENTS_NULL
  58. SYSTABLES_REL_DESC
  59. SYSTABLES_REL_DESC_NULL
  60. SYSTABLES_REMARKS
  61. SYSTABLES_REMARKS_NULL
  62. SYSTABLES_SELFREFS
  63. SYSTABLES_SELFREFS_NULL
  64. SYSTABLES_TID
  65. SYSTABLES_TYPE
  66. SYSTABLES_VIEW_DESC
  67. SYSTABLES_VIEW_DESC_NULL
  68.