midrange.com code scratchpad
Name:
SQLRPGLE UDTF
Scriptlanguage:
Plain Text
Tabwidth:
4
Date:
08/12/2019 05:08:44 pm
IP:
Logged
Description:
Part 2 of 2
Code:
  1. SQL7959              Cursor CRSR0001 was closed.
  2. SQL7913              ODP deleted.
  3. SQL0501              Cursor OBJ not open.
  4. SQL7964              Embedded SELECT completed.
  5. SQL7914              ODP not deleted.
  6. SQL7911              ODP reused.
  7. CPI1901               Breakpoint received in secondary thread.
  8. SQL7985              CALL statement complete.
  9. SQL7967              PREPARE of statement QZA32E87C4D35E9001 completed.
  10. SQL0443              Trigger program or external routine detected an error.
  11. CPF503E              User-defined function error on member QSQPTABL.
  12. CPF503E              User-defined function error on member QSQPTABL.
  13. SQL0501              Cursor OBJ not open.
  14. SQL7964              Embedded SELECT completed.
  15. SQL7914              ODP not deleted.
  16. SQL7911              ODP reused.
  17. CPI1901               Breakpoint received in secondary thread.
  18. SQL7962              Cursor OBJ opened.
  19. SQL7916              Blocking used for query.
  20. SQL7912              ODP created.
  21. CPI434B               **** Ending debug message for query .
  22. CPI433D               Query options used to build the query access plan.
  23. CPI4329               Arrival sequence access was used for file *FUNCTION.
  24. CPI4323               The query access plan has been rebuilt.
  25. CPI434A               **** Starting optimizer debug message for query .
  26. CPI4339               Query options retrieved file QAQQINI in library QUSRSYS.
  27. SQL7967              PREPARE of statement P1 completed.
  28. CPI4323               The query access plan has been rebuilt.
  29. CPI4339               Query options retrieved file QAQQINI in library QUSRSYS.
  30. SQL7964              Embedded SELECT completed.
  31. SQL7914              ODP not deleted.
  32. SQL7916              Blocking used for query.
  33. SQL7912              ODP created.
  34. CPI434B               **** Ending debug message for query .
  35. CPI4329               Arrival sequence access was used for file SYSSCHEMAS.
  36. CPI434A               **** Starting optimizer debug message for query .
  37. CPI4339               Query options retrieved file QAQQINI in library QUSRSYS.
  38. CPI1901               Breakpoint received in secondary thread.
  39. SQL7962              Cursor CRSR0001 opened.
  40. SQL7916              Blocking used for query.
  41. SQL7912              ODP created.
  42. CPI434B               **** Ending debug message for query .
  43. CPI4329               Arrival sequence access was used for file *FUNCTION.
  44. CPI434A               **** Starting optimizer debug message for query .
  45. CPI4339               Query options retrieved file QAQQINI in library QUSRSYS.
  46. SQL7967              PREPARE of statement STMT0001 completed.
  47. SQL7968              DESCRIBE of prepared statement STMT0001 completed.
  48. CPI4323               The query access plan has been rebuilt.
  49. CPI4339               Query options retrieved file QAQQINI in library QUSRSYS.
  50. SQL7985              CALL statement complete.
  51. SQL7967              PREPARE of statement QZA32E87C4B594A001 completed.
  52. SQL7985              CALL statement complete.
  53. SQL7967              PREPARE of statement QZA32E87BFB4766001 completed.
  54. SQL790F              SET CURRENT SCHEMA statement complete.
  55. SQL7985              CALL statement complete.
  56. SQL7967              PREPARE of statement QZA32E87BFB2F52001 completed.
  57. SQL7913              ODP deleted.
  58. SQL7963              21 rows fetched from cursor CRSR0001.
  59. SQL7962              Cursor CRSR0001 opened.
  60. SQL7916              Blocking used for query.
  61. SQL7912              ODP created.
  62. CPI434B               **** Ending debug message for query .
  63. CPI433D               Query options used to build the query access plan.
  64. CPI4323               The query access plan has been rebuilt.
  65. CPI4329               Arrival sequence access was used for file *VALUES.
  66. CPI4323               The query access plan has been rebuilt.
  67. CPI4339               Query options retrieved file QAQQINI in library QUSRSYS.
  68. CPI4339               Query options retrieved file QAQQINI in library QUSRSYS.
  69. CPI434A               **** Starting optimizer debug message for query .
  70. CPI4339               Query options retrieved file QAQQINI in library QUSRSYS.
  71. SQL7967              PREPARE of statement STMT0001 completed.
  72. SQL7968              DESCRIBE of prepared statement STMT0001 completed.
  73. CPI4323               The query access plan has been rebuilt.
  74. CPI4339               Query options retrieved file QAQQINI in library QUSRSYS.
  75. CPI4339               Query options retrieved file QAQQINI in library QUSRSYS.
  76. CPI4339               Query options retrieved file QAQQINI in library QUSRSYS.
  77. SQL7985              CALL statement complete.
  78. SQL792E              GET DIAGNOSTICS statement complete.
  79. SQL7950              Table QSQ_SQL_VAR_VALUES created in QTEMP.
  80. SQL7967              PREPARE of statement QZA32E87B880015001 completed.
  81. SQL0206              Column or global variable PACKAGE_VERSION not found.
  82. CPD432B             Access of global variable object PACKAGE_VERSION in SYSIBM failed.
  83. CPD432B             Access of global variable object PACKAGE_VERSION in SYSIBM failed.
  84. SQL799C              The following special registers have been set: CLIENT_ACCTNG: Windows 10;SSL=false;admin_user=true, CLIENT_APPLNAME: IBM i Access Client Solutions - Run SQL Scripts, CLIENT_PROGRAMID: file:/C:/Users/Public/IBM/ClientSolutions/acsbundle.jar, CLIENT_USERID: rob, CLIENT_WRKSTNNAME: GDL57.dekko-1
  85. CPC1129              Job 167728/QUSER/QZDASOINIT changed by ROB.
  86. CPF1301              ACGDTA for 167728/QUSER/QZDASOINIT not journaled; reason 1.
  87. CPIAD02              User ROB from client 10.10.9.30 connected to server.
  88. CPF1301              ACGDTA for 167728/QUSER/QZDASOINIT not journaled; reason 1.
  89. CPC1129              Job 167728/QUSER/QZDASOINIT changed by ROB.
  90. CPC1129              Job 167728/QUSER/QZDASOINIT changed by ROB.
  91.  
© 2004-2019 by midrange.com generated in 0.009s valid xhtml & css