API tools faq
paste
Advertisement
keith_shannon

Oracle Trace

keith_shannon
Jul 12th, 2012
553
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Oracle 11 48.25 KB | None | 0 0
raw download clone embed print report
  1. Heterogeneous Agent RELEASE
  2. 11.2.0.3.0
  3.  
  4.  
  5.  
  6.  
  7. Oracle Corporation --- THURSDAY  JUL 12 2012 15:54:29.836
  8.  
  9.     Version 11.2.0.3.0
  10.  
  11. Entered hgogprd
  12. HOSGIP FOR "HS_FDS_TRACE_LEVEL" returned "255"
  13. Entered hgosdip
  14.  setting HS_OPEN_CURSORS TO DEFAULT OF 50
  15.  setting HS_FDS_RECOVERY_ACCOUNT TO DEFAULT OF "RECOVER"
  16.  setting HS_FDS_RECOVERY_PWD TO DEFAULT VALUE
  17.  setting HS_FDS_TRANSACTION_LOG TO DEFAULT OF HS_TRANSACTION_LOG
  18.  setting HS_IDLE_TIMEOUT TO DEFAULT OF 0
  19.  setting HS_FDS_TRANSACTION_ISOLATION TO DEFAULT OF "READ_COMMITTED"
  20.  setting HS_NLS_NCHAR TO DEFAULT OF "AL32UTF8"
  21.  setting HS_FDS_TIMESTAMP_MAPPING TO DEFAULT OF "DATE"
  22.  setting HS_FDS_DATE_MAPPING TO DEFAULT OF "DATE"
  23.  setting HS_RPC_FETCH_REBLOCKING TO DEFAULT OF "ON"
  24.  setting HS_FDS_FETCH_ROWS TO DEFAULT OF "100"
  25.  setting HS_FDS_RESULTSET_SUPPORT TO DEFAULT OF "FALSE"
  26.  setting HS_FDS_RSET_RETURN_ROWCOUNT TO DEFAULT OF "FALSE"
  27.  setting HS_FDS_PROC_IS_FUNC TO DEFAULT OF "FALSE"
  28.  setting HS_FDS_MAP_NCHAR TO DEFAULT OF "TRUE"
  29.  setting HS_NLS_DATE_FORMAT TO DEFAULT OF "YYYY-MM-DD HH24:MI:SS"
  30.  setting HS_FDS_REPORT_REAL_AS_DOUBLE TO DEFAULT OF "FALSE"
  31.  setting HS_LONG_PIECE_TRANSFER_SIZE TO DEFAULT OF "65536"
  32.  setting HS_SQL_HANDLE_STMT_REUSE TO DEFAULT OF "FALSE"
  33.  setting HS_FDS_QUERY_DRIVER TO DEFAULT OF "TRUE"
  34.  setting HS_FDS_SUPPORT_STATISTICS TO DEFAULT OF "FALSE"
  35.  setting HS_FDS_QUOTE_IDENTIFIER TO DEFAULT OF "TRUE"
  36.  setting HS_KEEP_REMOTE_COLUMN_SIZE TO DEFAULT OF "OFF"
  37.  setting HS_FDS_GRAPHIC_TO_MBCS TO DEFAULT OF "FALSE"
  38.  setting HS_FDS_MBCS_TO_GRAPHIC TO DEFAULT OF "FALSE"
  39. DEFAULT VALUE OF 64 assumed FOR HS_FDS_SQLLEN_INTERPRETATION
  40.  setting HS_CALL_NAME_ISP TO "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys                                                                                                                                                             ;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
  41.  setting HS_FDS_DELAYED_OPEN TO DEFAULT OF "TRUE"
  42.  setting HS_FDS_WORKAROUNDS TO DEFAULT OF "0"
  43. Exiting hgosdip, rc=0
  44.  ORACLE_SID IS "VDP_acme_DSN"
  45.  Product-Info:
  46.   Port Rls/Upd:3/0 PrdStat:0
  47.   Agent:Oracle DATABASE Gateway FOR ODBC
  48.   Facility:hsa
  49.   Class:ODBC, ClassVsn:11.2.0.3.0_0011, Instance:VDP_acme_DSN
  50. Exiting hgogprd, rc=0
  51. hostmstr:          0:   HOA After hoagprd
  52. hostmstr:          0:   HOA Before hoainit
  53. Entered hgoinit
  54. HOCXU_COMP_CSET=1
  55. HOCXU_DRV_CSET=178
  56. HOCXU_DRV_NCHAR=873
  57. HOCXU_DB_CSET=873
  58. HS_LANGUAGE IS american_america.we8mswin1252
  59. LANG=en_US.UTF-8
  60. HOCXU_SEM_VER=112000
  61. Entered hgolofn AT 2012/07/12-15:54:29
  62. HOSGIP FOR "HS_FDS_SHAREABLE_NAME" returned "/usr/local/lib/libodbc.so"
  63. Entered hgolofns AT 2012/07/12-15:54:29
  64.  libname=/usr/local/lib/libodbc.so, funcname=SQLAllocHandle
  65.  symbol_peflctx=0xb0008350
  66.  hoaerr:0
  67. Exiting hgolofns AT 2012/07/12-15:54:29
  68. Entered hgolofns AT 2012/07/12-15:54:29
  69.  libname=/usr/local/lib/libodbc.so, funcname=SQLBindCol
  70.  symbol_peflctx=0xb0008480
  71.  hoaerr:0
  72. Exiting hgolofns AT 2012/07/12-15:54:29
  73. Entered hgolofns AT 2012/07/12-15:54:29
  74.  libname=/usr/local/lib/libodbc.so, funcname=SQLBindParameter
  75.  symbol_peflctx=0xb0008c60
  76.  hoaerr:0
  77. Exiting hgolofns AT 2012/07/12-15:54:29
  78. Entered hgolofns AT 2012/07/12-15:54:29
  79.  libname=/usr/local/lib/libodbc.so, funcname=SQLCancel
  80.  symbol_peflctx=0xb0009f10
  81.  hoaerr:0
  82. Exiting hgolofns AT 2012/07/12-15:54:29
  83. Entered hgolofns AT 2012/07/12-15:54:29
  84.  libname=/usr/local/lib/libodbc.so, funcname=SQLDescribeParam
  85.  symbol_peflctx=0xb00115e0
  86.  hoaerr:0
  87. Exiting hgolofns AT 2012/07/12-15:54:29
  88. Entered hgolofns AT 2012/07/12-15:54:29
  89.  libname=/usr/local/lib/libodbc.so, funcname=SQLDisconnect
  90.  symbol_peflctx=0xb0011a20
  91.  hoaerr:0
  92. Exiting hgolofns AT 2012/07/12-15:54:29
  93. Entered hgolofns AT 2012/07/12-15:54:29
  94.  libname=/usr/local/lib/libodbc.so, funcname=SQLEndTran
  95.  symbol_peflctx=0xb0014020
  96.  hoaerr:0
  97. Exiting hgolofns AT 2012/07/12-15:54:29
  98. Entered hgolofns AT 2012/07/12-15:54:29
  99.  libname=/usr/local/lib/libodbc.so, funcname=SQLExecute
  100.  symbol_peflctx=0xb00153b0
  101.  hoaerr:0
  102. Exiting hgolofns AT 2012/07/12-15:54:29
  103. Entered hgolofns AT 2012/07/12-15:54:29
  104.  libname=/usr/local/lib/libodbc.so, funcname=SQLFetch
  105.  symbol_peflctx=0xb0015b20
  106.  hoaerr:0
  107. Exiting hgolofns AT 2012/07/12-15:54:29
  108. Entered hgolofns AT 2012/07/12-15:54:29
  109.  libname=/usr/local/lib/libodbc.so, funcname=SQLFreeHandle
  110.  symbol_peflctx=0xb0017420
  111.  hoaerr:0
  112. Exiting hgolofns AT 2012/07/12-15:54:29
  113. Entered hgolofns AT 2012/07/12-15:54:29
  114.  libname=/usr/local/lib/libodbc.so, funcname=SQLFreeStmt
  115.  symbol_peflctx=0xb0017440
  116.  hoaerr:0
  117. Exiting hgolofns AT 2012/07/12-15:54:29
  118. Entered hgolofns AT 2012/07/12-15:54:29
  119.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetData
  120.  symbol_peflctx=0xb00189f0
  121.  hoaerr:0
  122. Exiting hgolofns AT 2012/07/12-15:54:29
  123. Entered hgolofns AT 2012/07/12-15:54:29
  124.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetEnvAttr
  125.  symbol_peflctx=0xb001b9b0
  126.  hoaerr:0
  127. Exiting hgolofns AT 2012/07/12-15:54:29
  128. Entered hgolofns AT 2012/07/12-15:54:29
  129.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetFunctions
  130.  symbol_peflctx=0xb001bd10
  131.  hoaerr:0
  132. Exiting hgolofns AT 2012/07/12-15:54:29
  133. Entered hgolofns AT 2012/07/12-15:54:29
  134.  libname=/usr/local/lib/libodbc.so, funcname=SQLMoreResults
  135.  symbol_peflctx=0xb001d660
  136.  hoaerr:0
  137. Exiting hgolofns AT 2012/07/12-15:54:29
  138. Entered hgolofns AT 2012/07/12-15:54:29
  139.  libname=/usr/local/lib/libodbc.so, funcname=SQLNumResultCols
  140.  symbol_peflctx=0xb001e1a0
  141.  hoaerr:0
  142. Exiting hgolofns AT 2012/07/12-15:54:29
  143. Entered hgolofns AT 2012/07/12-15:54:29
  144.  libname=/usr/local/lib/libodbc.so, funcname=SQLParamData
  145.  symbol_peflctx=0xb001e450
  146.  hoaerr:0
  147. Exiting hgolofns AT 2012/07/12-15:54:29
  148. Entered hgolofns AT 2012/07/12-15:54:29
  149.  libname=/usr/local/lib/libodbc.so, funcname=SQLPutData
  150.  symbol_peflctx=0xb0020160
  151.  hoaerr:0
  152. Exiting hgolofns AT 2012/07/12-15:54:29
  153. Entered hgolofns AT 2012/07/12-15:54:29
  154.  libname=/usr/local/lib/libodbc.so, funcname=SQLRowCount
  155.  symbol_peflctx=0xb00204f0
  156.  hoaerr:0
  157. Exiting hgolofns AT 2012/07/12-15:54:29
  158. Entered hgolofns AT 2012/07/12-15:54:29
  159.  libname=/usr/local/lib/libodbc.so, funcname=SQLSetEnvAttr
  160.  symbol_peflctx=0xb0021f50
  161.  hoaerr:0
  162. Exiting hgolofns AT 2012/07/12-15:54:29
  163. Entered hgolofns AT 2012/07/12-15:54:29
  164.  libname=/usr/local/lib/libodbc.so, funcname=SQLSetDescRec
  165.  symbol_peflctx=0xb0021da0
  166.  hoaerr:0
  167. Exiting hgolofns AT 2012/07/12-15:54:29
  168. Entered hgolofns AT 2012/07/12-15:54:29
  169.  libname=/usr/local/lib/libodbc.so, funcname=SQLColAttribute
  170.  symbol_peflctx=0xb000a4a0
  171.  hoaerr:0
  172. Exiting hgolofns AT 2012/07/12-15:54:29
  173. Entered hgolofns AT 2012/07/12-15:54:29
  174.  libname=/usr/local/lib/libodbc.so, funcname=SQLColumns
  175.  symbol_peflctx=0xb000bba0
  176.  hoaerr:0
  177. Exiting hgolofns AT 2012/07/12-15:54:29
  178. Entered hgolofns AT 2012/07/12-15:54:29
  179.  libname=/usr/local/lib/libodbc.so, funcname=SQLConnect
  180.  symbol_peflctx=0xb000f390
  181.  hoaerr:0
  182. Exiting hgolofns AT 2012/07/12-15:54:29
  183. Entered hgolofns AT 2012/07/12-15:54:29
  184.  libname=/usr/local/lib/libodbc.so, funcname=SQLDescribeCol
  185.  symbol_peflctx=0xb0010ef0
  186.  hoaerr:0
  187. Exiting hgolofns AT 2012/07/12-15:54:29
  188. Entered hgolofns AT 2012/07/12-15:54:29
  189.  libname=/usr/local/lib/libodbc.so, funcname=SQLDriverConnect
  190.  symbol_peflctx=0xb00123e0
  191.  hoaerr:0
  192. Exiting hgolofns AT 2012/07/12-15:54:29
  193. Entered hgolofns AT 2012/07/12-15:54:29
  194.  libname=/usr/local/lib/libodbc.so, funcname=SQLExecDirect
  195.  symbol_peflctx=0xb0014e80
  196.  hoaerr:0
  197. Exiting hgolofns AT 2012/07/12-15:54:29
  198. Entered hgolofns AT 2012/07/12-15:54:29
  199.  libname=/usr/local/lib/libodbc.so, funcname=SQLForeignKeys
  200.  symbol_peflctx=0xb00163b0
  201.  hoaerr:0
  202. Exiting hgolofns AT 2012/07/12-15:54:29
  203. Entered hgolofns AT 2012/07/12-15:54:29
  204.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetConnectAttr
  205.  symbol_peflctx=0xb0017750
  206.  hoaerr:0
  207. Exiting hgolofns AT 2012/07/12-15:54:29
  208. Entered hgolofns AT 2012/07/12-15:54:29
  209.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetDescField
  210.  symbol_peflctx=0xb0019060
  211.  hoaerr:0
  212. Exiting hgolofns AT 2012/07/12-15:54:29
  213. Entered hgolofns AT 2012/07/12-15:54:29
  214.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetDescRec
  215.  symbol_peflctx=0xb00194e0
  216.  hoaerr:0
  217. Exiting hgolofns AT 2012/07/12-15:54:29
  218. Entered hgolofns AT 2012/07/12-15:54:29
  219.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetDiagField
  220.  symbol_peflctx=0xb001a630
  221.  hoaerr:0
  222. Exiting hgolofns AT 2012/07/12-15:54:29
  223. Entered hgolofns AT 2012/07/12-15:54:29
  224.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetDiagRec
  225.  symbol_peflctx=0xb001b230
  226.  hoaerr:0
  227. Exiting hgolofns AT 2012/07/12-15:54:29
  228. Entered hgolofns AT 2012/07/12-15:54:29
  229.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetInfo
  230.  symbol_peflctx=0xb001bf00
  231.  hoaerr:0
  232. Exiting hgolofns AT 2012/07/12-15:54:29
  233. Entered hgolofns AT 2012/07/12-15:54:29
  234.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetStmtAttr
  235.  symbol_peflctx=0xb001c8f0
  236.  hoaerr:0
  237. Exiting hgolofns AT 2012/07/12-15:54:29
  238. Entered hgolofns AT 2012/07/12-15:54:29
  239.  libname=/usr/local/lib/libodbc.so, funcname=SQLGetTypeInfo
  240.  symbol_peflctx=0xb001d300
  241.  hoaerr:0
  242. Exiting hgolofns AT 2012/07/12-15:54:29
  243. Entered hgolofns AT 2012/07/12-15:54:29
  244.  libname=/usr/local/lib/libodbc.so, funcname=SQLPrepare
  245.  symbol_peflctx=0xb001eb80
  246.  hoaerr:0
  247. Exiting hgolofns AT 2012/07/12-15:54:29
  248. Entered hgolofns AT 2012/07/12-15:54:29
  249.  libname=/usr/local/lib/libodbc.so, funcname=SQLPrimaryKeys
  250.  symbol_peflctx=0xb001f060
  251.  hoaerr:0
  252. Exiting hgolofns AT 2012/07/12-15:54:29
  253. Entered hgolofns AT 2012/07/12-15:54:29
  254.  libname=/usr/local/lib/libodbc.so, funcname=SQLProcedureColumns
  255.  symbol_peflctx=0xb001f5d0
  256.  hoaerr:0
  257. Exiting hgolofns AT 2012/07/12-15:54:29
  258. Entered hgolofns AT 2012/07/12-15:54:29
  259.  libname=/usr/local/lib/libodbc.so, funcname=SQLProcedures
  260.  symbol_peflctx=0xb001fc00
  261.  hoaerr:0
  262. Exiting hgolofns AT 2012/07/12-15:54:29
  263. Entered hgolofns AT 2012/07/12-15:54:29
  264.  libname=/usr/local/lib/libodbc.so, funcname=SQLSetConnectAttr
  265.  symbol_peflctx=0xb0020790
  266.  hoaerr:0
  267. Exiting hgolofns AT 2012/07/12-15:54:29
  268. Entered hgolofns AT 2012/07/12-15:54:29
  269.  libname=/usr/local/lib/libodbc.so, funcname=SQLSetStmtAttr
  270.  symbol_peflctx=0xb0023250
  271.  hoaerr:0
  272. Exiting hgolofns AT 2012/07/12-15:54:29
  273. Entered hgolofns AT 2012/07/12-15:54:29
  274.  libname=/usr/local/lib/libodbc.so, funcname=SQLSetDescField
  275.  symbol_peflctx=0xb0021a60
  276.  hoaerr:0
  277. Exiting hgolofns AT 2012/07/12-15:54:29
  278. Entered hgolofns AT 2012/07/12-15:54:29
  279.  libname=/usr/local/lib/libodbc.so, funcname=SQLStatistics
  280.  symbol_peflctx=0xb0024a60
  281.  hoaerr:0
  282. Exiting hgolofns AT 2012/07/12-15:54:29
  283. Entered hgolofns AT 2012/07/12-15:54:29
  284.  libname=/usr/local/lib/libodbc.so, funcname=SQLTables
  285.  symbol_peflctx=0xb0025650
  286.  hoaerr:0
  287. Exiting hgolofns AT 2012/07/12-15:54:29
  288. Exiting hgolofn, rc=0 AT 2012/07/12-15:54:29
  289. HOSGIP FOR "HS_OPEN_CURSORS" returned "50"
  290. HOSGIP FOR "HS_FDS_FETCH_ROWS" returned "100"
  291. HOSGIP FOR "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
  292. HOSGIP FOR "HS_NLS_NUMERIC_CHARACTER" returned ".,"
  293. HOSGIP FOR "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
  294. HOSGIP FOR "HS_FDS_DELAYED_OPEN" returned "TRUE"
  295. HOSGIP FOR "HS_FDS_WORKAROUNDS" returned "0"
  296. HOSGIP FOR "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
  297. HOSGIP FOR "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
  298. Invalid VALUE OF 64 given FOR HS_FDS_SQLLEN_INTERPRETATION
  299. treat_SQLLEN_as_compiled = 1
  300. Exiting hgoinit, rc=0 AT 2012/07/12-15:54:29
  301. hostmstr:          0:   HOA After hoainit
  302. hostmstr:          0:   HOA Before hoalgon
  303. Entered hgolgon AT 2012/07/12-15:54:29
  304.  reco:0, name:ADMIN, tflag:0
  305. Entered hgosuec AT 2012/07/12-15:54:29
  306. Exiting hgosuec, rc=0 AT 2012/07/12-15:54:29
  307. HOSGIP FOR "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
  308. HOSGIP FOR "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
  309. HOSGIP FOR "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
  310. HOSGIP FOR "HS_FDS_DATE_MAPPING" returned "DATE"
  311. HOSGIP FOR "HS_FDS_MAP_NCHAR" returned "TRUE"
  312. HOSGIP FOR "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
  313. HOSGIP FOR "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
  314. HOSGIP FOR "HS_FDS_PROC_IS_FUNC" returned "FALSE"
  315. HOSGIP FOR "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
  316.  USING ADMIN AS DEFAULT VALUE FOR "HS_FDS_DEFAULT_OWNER"
  317. HOSGIP FOR "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
  318. Entered hgocont AT 2012/07/12-15:54:29
  319.  HS_FDS_CONNECT_INFO = "VDP_acme_DSN"
  320.  RC=-1 FROM HOSGIP FOR "HS_FDS_CONNECT_STRING"
  321. Entered hgogenconstr AT 2012/07/12-15:54:29
  322.  dsn:VDP_acme_DSN, name:ADMIN
  323.  optn:
  324. Entered hgocip AT 2012/07/12-15:54:29
  325.  dsn:VDP_acme_DSN
  326. Exiting hgocip, rc=0 AT 2012/07/12-15:54:29
  327. ##>CONNECT Parameters (len=36)<##
  328. ## DSN=VDP_acme_DSN;
  329. #! UID=ADMIN;
  330. #! PWD=*
  331. Exiting hgogenconstr, rc=0 AT 2012/07/12-15:54:29
  332. Entered hgolosf AT 2012/07/12-15:54:29
  333. ODBC Function-Available-ARRAY 0xFFFE 0x00FF 0xFF00 0xFA7F 0x03FF 0x0000
  334.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  335.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  336.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  337.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  338.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  339.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  340.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  341.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  342.                               0x0000 0x0000 0x0000 0x0000 0x0000 0x0000
  343.                               0x0000 0x0000 0xFE00 0x3B5D
  344. Exiting hgolosf, rc=0 AT 2012/07/12-15:54:29
  345. DriverName:psqlodbcw.so, DriverVer:08.04.0200
  346. DBMS Name:PostgreSQL, DBMS Version:8.1.4
  347. Exiting hgocont, rc=0 AT 2012/07/12-15:54:29
  348. SQLGetInfo returns Y FOR SQL_CATALOG_NAME
  349. SQLGetInfo returns 0 FOR SQL_MAX_CATALOG_NAME_LEN
  350. Exiting hgolgon, rc=0 AT 2012/07/12-15:54:29
  351. hostmstr:          0:   HOA After hoalgon
  352. RPC Calling nscontrol(0), rc=0
  353. hostmstr:          0: RPC Before Upload Caps
  354. hostmstr:          0:   HOA Before hoaulcp
  355. Entered hgoulcp AT 2012/07/12-15:54:29
  356. Entered hgowlst AT 2012/07/12-15:54:29
  357. Exiting hgowlst, rc=0 AT 2012/07/12-15:54:29
  358. SQLGetInfo returns 0x1d FOR SQL_OWNER_USAGE
  359. TXN Capable:2, ISOLATION OPTION:0xa
  360. SQLGetInfo returns 64 FOR SQL_MAX_SCHEMA_NAME_LEN
  361. SQLGetInfo returns 64 FOR SQL_MAX_TABLE_NAME_LEN
  362. SQLGetInfo returns 0 FOR SQL_MAX_PROCEDURE_NAME_LEN
  363.  HOSGIP returned VALUE OF "TRUE" FOR HS_FDS_QUOTE_IDENTIFIER
  364. SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR
  365. 2 instance capabilities will be uploaded
  366.  capno:1989, context:0x00000000, add-info:        0
  367.  capno:1992, context:0x0001ffff, add-info:        0
  368. Exiting hgoulcp, rc=0 at 2012/07/12-15:54:30
  369. hostmstr:          0:   HOA After hoaulcp
  370. hostmstr:          0: RPC After Upload Caps
  371. hostmstr:          0: RPC Before Upload DDTR
  372. hostmstr:          0:   HOA Before hoauldt
  373. Entered hgouldt at 2012/07/12-15:54:30
  374. NO instance DD translations were uploaded
  375. Exiting hgouldt, rc=0 at 2012/07/12-15:54:30
  376. hostmstr:          0:   HOA After hoauldt
  377. hostmstr:          0: RPC After Upload DDTR
  378. hostmstr:          0: RPC Before Begin Trans
  379. hostmstr:          0:   HOA Before hoabegn
  380. Entered hgobegn at 2012/07/12-15:54:30
  381. tflag:0 , initial:1
  382. hoi:0x3a904b78, ttid (len 25) is ...
  383.  00: 45544C44 2E636663 62656563 362E3130  [ETLD.cfcbeec6.10]
  384.  10: 2E31352E 31313531 39                 [.15.11519]
  385.                 tbid (len 22) is ...
  386.  00: 45544C44 5B31302E 31352E31 31353139  [ETLD[10.15.11519]
  387.  10: 5D5B312E 345D                        [][1.4]]
  388. Exiting hgobegn, rc=0 at 2012/07/12-15:54:30
  389. hostmstr:          0:   HOA After hoabegn
  390. hostmstr:          0: RPC After Begin Trans
  391. hostmstr:          0: RPC Before Describe Table
  392. hostmstr:          0:   HOA Before hoadtab
  393. Entered hgodtab at 2012/07/12-15:54:30
  394. count:1
  395.  table: ODS_MD__PRODUCT
  396. Allocate hoada[0] @ 0xde63c90
  397. Entered hgopcda at 2012/07/12-15:54:30
  398. Column:1(prd_cd): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:                                                                                                                                                             1, radix:0
  399. Exiting hgopcda, rc=0 at 2012/07/12-15:54:30
  400. Entered hgopcda at 2012/07/12-15:54:30
  401. Column:2(prd_dsc): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign                                                                                                                                                             :1, radix:0
  402. Exiting hgopcda, rc=0 at 2012/07/12-15:54:30
  403. Entered hgopcda at 2012/07/12-15:54:30
  404. Column:3(ld_dt): dtype:93 (TIMESTAMP), prc/scl:19/0, nullbl:1, octet:255, sign:                                                                                                                                                             1, radix:0
  405. Exiting hgopcda, rc=0 at 2012/07/12-15:54:30
  406. Entered hgopcda at 2012/07/12-15:54:30
  407. Column:4(updt_dt): dtype:93 (TIMESTAMP), prc/scl:19/0, nullbl:1, octet:255, sig                                                                                                                                                             n:1, radix:0
  408. Exiting hgopcda, rc=0 at 2012/07/12-15:54:30
  409. Entered hgopcda at 2012/07/12-15:54:30
  410. Column:5(prd_ln_dsc): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, s                                                                                                                                                             ign:1, radix:0
  411. Exiting hgopcda, rc=0 at 2012/07/12-15:54:30
  412. Entered hgopcda at 2012/07/12-15:54:30
  413. Column:6(prd_ln_cd): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, si                                                                                                                                                             gn:1, radix:0
  414. Exiting hgopcda, rc=0 at 2012/07/12-15:54:30
  415. Entered hgopcda at 2012/07/12-15:54:30
  416. Column:7(ln_bus_cd): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, si                                                                                                                                                             gn:1, radix:0
  417. Exiting hgopcda, rc=0 at 2012/07/12-15:54:30
  418. Entered hgopcda at 2012/07/12-15:54:30
  419. Column:8(ln_bus_dsc): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, s                                                                                                                                                             ign:1, radix:0
  420. Exiting hgopcda, rc=0 at 2012/07/12-15:54:30
  421. Entered hgopcda at 2012/07/12-15:54:30
  422. Column:9(co_num): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sign:                                                                                                                                                             1, radix:0
  423. Exiting hgopcda, rc=0 at 2012/07/12-15:54:30
  424. Entered hgopcda at 2012/07/12-15:54:30
  425. Column:10(src_sys_cd): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255,                                                                                                                                                              sign:1, radix:0
  426. Exiting hgopcda, rc=0 at 2012/07/12-15:54:30
  427. Entered hgopcda at 2012/07/12-15:54:30
  428. Column:11(src_sys_key): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255,                                                                                                                                                              sign:1, radix:0
  429. Exiting hgopcda, rc=0 at 2012/07/12-15:54:30
  430. Entered hgopcda at 2012/07/12-15:54:30
  431. Column:12(del_flg): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sig                                                                                                                                                             n:1, radix:0
  432. Exiting hgopcda, rc=0 at 2012/07/12-15:54:30
  433. The hoada for table ODS_MD__PRODUCT follows...
  434. hgodtab, line 1092: Printing hoada @ 0xde63c90
  435. MAX:12, ACTUAL:12, BRC:1, WHT=6 (TABLE_DESCRIBE)
  436. hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
  437. DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
  438. 12 VARCHAR Y        255        255   0/  0    0   0 200 prd_cd
  439. 12 VARCHAR Y        255        255   0/  0    0   0 200 prd_dsc
  440. 91 DATE    Y         16         16   0/  0    0   0   0 ld_dt
  441. 91 DATE    Y         16         16   0/  0    0   0   0 updt_dt
  442. 12 VARCHAR Y        255        255   0/  0    0   0 200 prd_ln_dsc
  443. 12 VARCHAR Y        255        255   0/  0    0   0 200 prd_ln_cd
  444. 12 VARCHAR Y        255        255   0/  0    0   0 200 ln_bus_cd
  445. 12 VARCHAR Y        255        255   0/  0    0   0 200 ln_bus_dsc
  446. 12 VARCHAR Y        255        255   0/  0    0   0 200 co_num
  447. 12 VARCHAR Y        255        255   0/  0    0   0 200 src_sys_cd
  448. 12 VARCHAR Y        255        255   0/  0    0   0 200 src_sys_key
  449. 12 VARCHAR Y        255        255   0/  0    0   0 200 del_flg
  450. Exiting hgodtab, rc=0 at 2012/07/12-15:54:30
  451. hostmstr:          0:   HOA After hoadtab
  452. hostmstr:          0:   HOA Before hoadafr
  453. Entered hgodafr, cursor id 0 at 2012/07/12-15:54:30
  454. Free hoada @ 0xde63c90
  455. Exiting hgodafr, rc=0 at 2012/07/12-15:54:30
  456. hostmstr:          0:   HOA After hoadafr
  457. hostmstr:          0: RPC After Describe Table
  458. hostmstr:          0: RPC Before SQL Bundling
  459. hostmstr:          0:   HOA Before hoxpars
  460. Entered hgopars, cursor id 1 at 2012/07/12-15:54:30
  461. type:0
  462. SQL text from hgopars, id=1, len=201 ...
  463.     00: 53454C45 43542041 312E2270 72645F63  [SELECT A1."prd_c]
  464.      10: 64222C41 312E2270 72645F64 7363222C  [d",A1."prd_dsc",]
  465.     20: 41312E22 6C645F64 74222C41 312E2275  [A1."ld_dt",A1."u]
  466.      30: 7064745F 6474222C 41312E22 7072645F  [pdt_dt",A1."prd_]
  467.      40: 6C6E5F64 7363222C 41312E22 7072645F  [ln_dsc",A1."prd_]
  468.      50: 6C6E5F63 64222C41 312E226C 6E5F6275  [ln_cd",A1."ln_bu]
  469.      60: 735F6364 222C4131 2E226C6E 5F627573  [s_cd",A1."ln_bus]
  470.      70: 5F647363 222C4131 2E22636F 5F6E756D  [_dsc",A1."co_num]
  471.      80: 222C4131 2E227372 635F7379 735F6364  [",A1."src_sys_cd]
  472.      90: 222C4131 2E227372 635F7379 735F6B65  [",A1."src_sys_ke]
  473.      A0: 79222C41 312E2264 656C5F66 6C672220  [y",A1."del_flg" ]
  474.     B0: 46524F4D 20224F44 535F4D44 5F5F5052  [FROM "ODS_MD__PR]
  475.      C0: 4F445543 54222041 31                 [ODUCT" A1]
  476. Entered hgopoer at 2012/07/12-15:54:30
  477. hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...
  478. No query has been executed with that handle {HY000,NativeErr = 1}No query has be                                                                                                                                                             en executed with that handle {HY000,NativeErr = 1}
  479. Exiting hgopoer, rc=0 at 2012/07/12-15:54:30
  480. hgopars, line 526: calling SQLNumResultCols got sqlstate HY000
  481. Exiting hgopars, rc=28500 at 2012/07/12-15:54:30 with error ptr FILE:hgopars.c L                                                                                                                                                             INE:556 FUNCTION:hgopars() ID:Preprocess number of columns
  482. hostmstr:          0:   HOA After hoxpars
  483. hostmstr:          0: RPC After SQL Bundling
  484. hostmstr:          0: RPC Before SQL Bundling
  485. hostmstr:          0:   HOA Before hoxpars
  486. Entered hgopars, cursor id 1 at 2012/07/12-15:58:52
  487. type:0
  488. SQL text from hgopars, id=1, len=201 ...
  489.     00: 53454C45 43542041 312E2270 72645F63  [SELECT A1."prd_c]
  490.      10: 64222C41 312E2270 72645F64 7363222C  [d",A1."prd_dsc",]
  491.     20: 41312E22 6C645F64 74222C41 312E2275  [A1."ld_dt",A1."u]
  492.      30: 7064745F 6474222C 41312E22 7072645F  [pdt_dt",A1."prd_]
  493.      40: 6C6E5F64 7363222C 41312E22 7072645F  [ln_dsc",A1."prd_]
  494.      50: 6C6E5F63 64222C41 312E226C 6E5F6275  [ln_cd",A1."ln_bu]
  495.      60: 735F6364 222C4131 2E226C6E 5F627573  [s_cd",A1."ln_bus]
  496.      70: 5F647363 222C4131 2E22636F 5F6E756D  [_dsc",A1."co_num]
  497.      80: 222C4131 2E227372 635F7379 735F6364  [",A1."src_sys_cd]
  498.      90: 222C4131 2E227372 635F7379 735F6B65  [",A1."src_sys_ke]
  499.      A0: 79222C41 312E2264 656C5F66 6C672220  [y",A1."del_flg" ]
  500.     B0: 46524F4D 20224F44 535F4D44 5F5F5052  [FROM "ODS_MD__PR]
  501.      C0: 4F445543 54222041 31                 [ODUCT" A1]
  502. Entered hgopoer at 2012/07/12-15:58:52
  503. hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...
  504. No query has been executed with that handle {HY000,NativeErr = 1}No query has be                                                                                                                                                             en executed with that handle {HY000,NativeErr = 1}
  505. Exiting hgopoer, rc=0 at 2012/07/12-15:58:52
  506. hgopars, line 526: calling SQLNumResultCols got sqlstate HY000
  507. Exiting hgopars, rc=28500 at 2012/07/12-15:58:52 with error ptr FILE:hgopars.c L                                                                                                                                                             INE:556 FUNCTION:hgopars() ID:Preprocess number of columns
  508. hostmstr:          0:   HOA After hoxpars
  509. hostmstr:          0: RPC After SQL Bundling
  510. hostmstr:          0: RPC Before SQL Bundling
  511. hostmstr:          0:   HOA Before hoxpars
  512. Entered hgopars, cursor id 1 at 2012/07/12-15:58:54
  513. type:0
  514. SQL text from hgopars, id=1, len=201 ...
  515.     00: 53454C45 43542041 312E2270 72645F63  [SELECT A1."prd_c]
  516.      10: 64222C41 312E2270 72645F64 7363222C  [d",A1."prd_dsc",]
  517.     20: 41312E22 6C645F64 74222C41 312E2275  [A1."ld_dt",A1."u]
  518.      30: 7064745F 6474222C 41312E22 7072645F  [pdt_dt",A1."prd_]
  519.      40: 6C6E5F64 7363222C 41312E22 7072645F  [ln_dsc",A1."prd_]
  520.      50: 6C6E5F63 64222C41 312E226C 6E5F6275  [ln_cd",A1."ln_bu]
  521.      60: 735F6364 222C4131 2E226C6E 5F627573  [s_cd",A1."ln_bus]
  522.      70: 5F647363 222C4131 2E22636F 5F6E756D  [_dsc",A1."co_num]
  523.      80: 222C4131 2E227372 635F7379 735F6364  [",A1."src_sys_cd]
  524.      90: 222C4131 2E227372 635F7379 735F6B65  [",A1."src_sys_ke]
  525.      A0: 79222C41 312E2264 656C5F66 6C672220  [y",A1."del_flg" ]
  526.     B0: 46524F4D 20224F44 535F4D44 5F5F5052  [FROM "ODS_MD__PR]
  527.      C0: 4F445543 54222041 31                 [ODUCT" A1]
  528. Entered hgopoer at 2012/07/12-15:58:54
  529. hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...
  530. No query has been executed with that handle {HY000,NativeErr = 1}No query has be                                                                                                                                                             en executed with that handle {HY000,NativeErr = 1}
  531. Exiting hgopoer, rc=0 at 2012/07/12-15:58:54
  532. hgopars, line 526: calling SQLNumResultCols got sqlstate HY000
  533. Exiting hgopars, rc=28500 at 2012/07/12-15:58:54 with error ptr FILE:hgopars.c L                                                                                                                                                             INE:556 FUNCTION:hgopars() ID:Preprocess number of columns
  534. hostmstr:          0:   HOA After hoxpars
  535. hostmstr:          0: RPC After SQL Bundling
  536. hostmstr:          0: RPC Before SQL Bundling
  537. hostmstr:          0:   HOA Before hoxpars
  538. Entered hgopars, cursor id 1 at 2012/07/12-16:04:31
  539. type:0
  540. SQL text from hgopars, id=1, len=201 ...
  541.     00: 53454C45 43542041 312E2270 72645F63  [SELECT A1."prd_c]
  542.      10: 64222C41 312E2270 72645F64 7363222C  [d",A1."prd_dsc",]
  543.     20: 41312E22 6C645F64 74222C41 312E2275  [A1."ld_dt",A1."u]
  544.      30: 7064745F 6474222C 41312E22 7072645F  [pdt_dt",A1."prd_]
  545.      40: 6C6E5F64 7363222C 41312E22 7072645F  [ln_dsc",A1."prd_]
  546.      50: 6C6E5F63 64222C41 312E226C 6E5F6275  [ln_cd",A1."ln_bu]
  547.      60: 735F6364 222C4131 2E226C6E 5F627573  [s_cd",A1."ln_bus]
  548.      70: 5F647363 222C4131 2E22636F 5F6E756D  [_dsc",A1."co_num]
  549.      80: 222C4131 2E227372 635F7379 735F6364  [",A1."src_sys_cd]
  550.      90: 222C4131 2E227372 635F7379 735F6B65  [",A1."src_sys_ke]
  551.      A0: 79222C41 312E2264 656C5F66 6C672220  [y",A1."del_flg" ]
  552.     B0: 46524F4D 20224F44 535F4D44 5F5F5052  [FROM "ODS_MD__PR]
  553.      C0: 4F445543 54222041 31                 [ODUCT" A1]
  554. Entered hgopoer at 2012/07/12-16:04:31
  555. hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...
  556. No query has been executed with that handle {HY000,NativeErr = 1}No query has be                                                                                                                                                             en executed with that handle {HY000,NativeErr = 1}
  557. Exiting hgopoer, rc=0 at 2012/07/12-16:04:31
  558. hgopars, line 526: calling SQLNumResultCols got sqlstate HY000
  559. Exiting hgopars, rc=28500 at 2012/07/12-16:04:31 with error ptr FILE:hgopars.c L                                                                                                                                                             INE:556 FUNCTION:hgopars() ID:Preprocess number of columns
  560. hostmstr:          0:   HOA After hoxpars
  561. hostmstr:          0: RPC After SQL Bundling
  562. hostmstr:          0: RPC Before SQL Bundling
  563. hostmstr:          0:   HOA Before hoxpars
  564. Entered hgopars, cursor id 1 at 2012/07/12-16:04:32
  565. type:0
  566. SQL text from hgopars, id=1, len=201 ...
  567.     00: 53454C45 43542041 312E2270 72645F63  [SELECT A1."prd_c]
  568.      10: 64222C41 312E2270 72645F64 7363222C  [d",A1."prd_dsc",]
  569.     20: 41312E22 6C645F64 74222C41 312E2275  [A1."ld_dt",A1."u]
  570.      30: 7064745F 6474222C 41312E22 7072645F  [pdt_dt",A1."prd_]
  571.      40: 6C6E5F64 7363222C 41312E22 7072645F  [ln_dsc",A1."prd_]
  572.      50: 6C6E5F63 64222C41 312E226C 6E5F6275  [ln_cd",A1."ln_bu]
  573.      60: 735F6364 222C4131 2E226C6E 5F627573  [s_cd",A1."ln_bus]
  574.      70: 5F647363 222C4131 2E22636F 5F6E756D  [_dsc",A1."co_num]
  575.      80: 222C4131 2E227372 635F7379 735F6364  [",A1."src_sys_cd]
  576.      90: 222C4131 2E227372 635F7379 735F6B65  [",A1."src_sys_ke]
  577.      A0: 79222C41 312E2264 656C5F66 6C672220  [y",A1."del_flg" ]
  578.     B0: 46524F4D 20224F44 535F4D44 5F5F5052  [FROM "ODS_MD__PR]
  579.      C0: 4F445543 54222041 31                 [ODUCT" A1]
  580. Entered hgopoer at 2012/07/12-16:04:32
  581. hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...
  582. No query has been executed with that handle {HY000,NativeErr = 1}No query has be                                                                                                                                                             en executed with that handle {HY000,NativeErr = 1}
  583. Exiting hgopoer, rc=0 at 2012/07/12-16:04:32
  584. hgopars, line 526: calling SQLNumResultCols got sqlstate HY000
  585. Exiting hgopars, rc=28500 at 2012/07/12-16:04:32 with error ptr FILE:hgopars.c L                                                                                                                                                             INE:556 FUNCTION:hgopars() ID:Preprocess number of columns
  586. hostmstr:          0:   HOA After hoxpars
  587. hostmstr:          0: RPC After SQL Bundling
  588. hostmstr:          0: RPC Before SQL Bundling
  589. hostmstr:          0:   HOA Before hoxpars
  590. Entered hgopars, cursor id 1 at 2012/07/12-16:04:36
  591. type:0
  592. SQL text from hgopars, id=1, len=201 ...
  593.     00: 53454C45 43542041 312E2270 72645F63  [SELECT A1."prd_c]
  594.      10: 64222C41 312E2270 72645F64 7363222C  [d",A1."prd_dsc",]
  595.     20: 41312E22 6C645F64 74222C41 312E2275  [A1."ld_dt",A1."u]
  596.      30: 7064745F 6474222C 41312E22 7072645F  [pdt_dt",A1."prd_]
  597.      40: 6C6E5F64 7363222C 41312E22 7072645F  [ln_dsc",A1."prd_]
  598.      50: 6C6E5F63 64222C41 312E226C 6E5F6275  [ln_cd",A1."ln_bu]
  599.      60: 735F6364 222C4131 2E226C6E 5F627573  [s_cd",A1."ln_bus]
  600.      70: 5F647363 222C4131 2E22636F 5F6E756D  [_dsc",A1."co_num]
  601.      80: 222C4131 2E227372 635F7379 735F6364  [",A1."src_sys_cd]
  602.      90: 222C4131 2E227372 635F7379 735F6B65  [",A1."src_sys_ke]
  603.      A0: 79222C41 312E2264 656C5F66 6C672220  [y",A1."del_flg" ]
  604.     B0: 46524F4D 20224F44 535F4D44 5F5F5052  [FROM "ODS_MD__PR]
  605.      C0: 4F445543 54222041 31                 [ODUCT" A1]
  606. Entered hgopoer at 2012/07/12-16:04:36
  607. hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...
  608. No query has been executed with that handle {HY000,NativeErr = 1}No query has be                                                                                                                                                             en executed with that handle {HY000,NativeErr = 1}
  609. Exiting hgopoer, rc=0 at 2012/07/12-16:04:36
  610. hgopars, line 526: calling SQLNumResultCols got sqlstate HY000
  611. Exiting hgopars, rc=28500 at 2012/07/12-16:04:36 with error ptr FILE:hgopars.c L                                                                                                                                                             INE:556 FUNCTION:hgopars() ID:Preprocess number of columns
  612. hostmstr:          0:   HOA After hoxpars
  613. hostmstr:          0: RPC After SQL Bundling
  614. hostmstr:          0: RPC Before SQL Bundling
  615. hostmstr:          0:   HOA Before hoxpars
  616. Entered hgopars, cursor id 1 at 2012/07/12-16:04:38
  617. type:0
  618. SQL text from hgopars, id=1, len=201 ...
  619.     00: 53454C45 43542041 312E2270 72645F63  [SELECT A1."prd_c]
  620.      10: 64222C41 312E2270 72645F64 7363222C  [d",A1."prd_dsc",]
  621.     20: 41312E22 6C645F64 74222C41 312E2275  [A1."ld_dt",A1."u]
  622.      30: 7064745F 6474222C 41312E22 7072645F  [pdt_dt",A1."prd_]
  623.      40: 6C6E5F64 7363222C 41312E22 7072645F  [ln_dsc",A1."prd_]
  624.      50: 6C6E5F63 64222C41 312E226C 6E5F6275  [ln_cd",A1."ln_bu]
  625.      60: 735F6364 222C4131 2E226C6E 5F627573  [s_cd",A1."ln_bus]
  626.      70: 5F647363 222C4131 2E22636F 5F6E756D  [_dsc",A1."co_num]
  627.      80: 222C4131 2E227372 635F7379 735F6364  [",A1."src_sys_cd]
  628.      90: 222C4131 2E227372 635F7379 735F6B65  [",A1."src_sys_ke]
  629.      A0: 79222C41 312E2264 656C5F66 6C672220  [y",A1."del_flg" ]
  630.     B0: 46524F4D 20224F44 535F4D44 5F5F5052  [FROM "ODS_MD__PR]
  631.      C0: 4F445543 54222041 31                 [ODUCT" A1]
  632. Entered hgopoer at 2012/07/12-16:04:38
  633. hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...
  634. No query has been executed with that handle {HY000,NativeErr = 1}No query has be                                                                                                                                                             en executed with that handle {HY000,NativeErr = 1}
  635. Exiting hgopoer, rc=0 at 2012/07/12-16:04:38
  636. hgopars, line 526: calling SQLNumResultCols got sqlstate HY000
  637. Exiting hgopars, rc=28500 at 2012/07/12-16:04:38 with error ptr FILE:hgopars.c L                                                                                                                                                             INE:556 FUNCTION:hgopars() ID:Preprocess number of columns
  638. hostmstr:          0:   HOA After hoxpars
  639. hostmstr:          0: RPC After SQL Bundling
  640. hostmstr:          0: RPC Before SQL Bundling
  641. hostmstr:          0:   HOA Before hoxpars
  642. Entered hgopars, cursor id 1 at 2012/07/12-16:04:45
  643. type:0
  644. SQL text from hgopars, id=1, len=201 ...
  645.     00: 53454C45 43542041 312E2270 72645F63  [SELECT A1."prd_c]
  646.      10: 64222C41 312E2270 72645F64 7363222C  [d",A1."prd_dsc",]
  647.     20: 41312E22 6C645F64 74222C41 312E2275  [A1."ld_dt",A1."u]
  648.      30: 7064745F 6474222C 41312E22 7072645F  [pdt_dt",A1."prd_]
  649.      40: 6C6E5F64 7363222C 41312E22 7072645F  [ln_dsc",A1."prd_]
  650.      50: 6C6E5F63 64222C41 312E226C 6E5F6275  [ln_cd",A1."ln_bu]
  651.      60: 735F6364 222C4131 2E226C6E 5F627573  [s_cd",A1."ln_bus]
  652.      70: 5F647363 222C4131 2E22636F 5F6E756D  [_dsc",A1."co_num]
  653.      80: 222C4131 2E227372 635F7379 735F6364  [",A1."src_sys_cd]
  654.      90: 222C4131 2E227372 635F7379 735F6B65  [",A1."src_sys_ke]
  655.      A0: 79222C41 312E2264 656C5F66 6C672220  [y",A1."del_flg" ]
  656.     B0: 46524F4D 20224F44 535F4D44 5F5F5052  [FROM "ODS_MD__PR]
  657.      C0: 4F445543 54222041 31                 [ODUCT" A1]
  658. Entered hgopoer at 2012/07/12-16:04:45
  659. hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...
  660. No query has been executed with that handle {HY000,NativeErr = 1}No query has be                                                                                                                                                             en executed with that handle {HY000,NativeErr = 1}
  661. Exiting hgopoer, rc=0 at 2012/07/12-16:04:45
  662. hgopars, line 526: calling SQLNumResultCols got sqlstate HY000
  663. Exiting hgopars, rc=28500 at 2012/07/12-16:04:45 with error ptr FILE:hgopars.c L                                                                                                                                                             INE:556 FUNCTION:hgopars() ID:Preprocess number of columns
  664. hostmstr:          0:   HOA After hoxpars
  665. hostmstr:          0: RPC After SQL Bundling
  666. hostmstr:          0: RPC Before SQL Bundling
  667. hostmstr:          0:   HOA Before hoxpars
  668. Entered hgopars, cursor id 1 at 2012/07/12-16:07:15
  669. type:0
  670. SQL text from hgopars, id=1, len=201 ...
  671.     00: 53454C45 43542041 312E2270 72645F63  [SELECT A1."prd_c]
  672.      10: 64222C41 312E2270 72645F64 7363222C  [d",A1."prd_dsc",]
  673.     20: 41312E22 6C645F64 74222C41 312E2275  [A1."ld_dt",A1."u]
  674.      30: 7064745F 6474222C 41312E22 7072645F  [pdt_dt",A1."prd_]
  675.      40: 6C6E5F64 7363222C 41312E22 7072645F  [ln_dsc",A1."prd_]
  676.      50: 6C6E5F63 64222C41 312E226C 6E5F6275  [ln_cd",A1."ln_bu]
  677.      60: 735F6364 222C4131 2E226C6E 5F627573  [s_cd",A1."ln_bus]
  678.      70: 5F647363 222C4131 2E22636F 5F6E756D  [_dsc",A1."co_num]
  679.      80: 222C4131 2E227372 635F7379 735F6364  [",A1."src_sys_cd]
  680.      90: 222C4131 2E227372 635F7379 735F6B65  [",A1."src_sys_ke]
  681.      A0: 79222C41 312E2264 656C5F66 6C672220  [y",A1."del_flg" ]
  682.     B0: 46524F4D 20224F44 535F4D44 5F5F5052  [FROM "ODS_MD__PR]
  683.      C0: 4F445543 54222041 31                 [ODUCT" A1]
  684. Entered hgopoer at 2012/07/12-16:07:15
  685. hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...
  686. No query has been executed with that handle {HY000,NativeErr = 1}No query has be                                                                                                                                                             en executed with that handle {HY000,NativeErr = 1}
  687. Exiting hgopoer, rc=0 at 2012/07/12-16:07:15
  688. hgopars, line 526: calling SQLNumResultCols got sqlstate HY000
  689. Exiting hgopars, rc=28500 at 2012/07/12-16:07:15 with error ptr FILE:hgopars.c L                                                                                                                                                             INE:556 FUNCTION:hgopars() ID:Preprocess number of columns
  690. hostmstr:          0:   HOA After hoxpars
  691. hostmstr:          0: RPC After SQL Bundling
  692. hostmstr:          0: RPC Before SQL Bundling
  693. hostmstr:          0:   HOA Before hoxpars
  694. Entered hgopars, cursor id 1 at 2012/07/12-16:07:18
  695. type:0
  696. SQL text from hgopars, id=1, len=201 ...
  697.     00: 53454C45 43542041 312E2270 72645F63  [SELECT A1."prd_c]
  698.      10: 64222C41 312E2270 72645F64 7363222C  [d",A1."prd_dsc",]
  699.     20: 41312E22 6C645F64 74222C41 312E2275  [A1."ld_dt",A1."u]
  700.      30: 7064745F 6474222C 41312E22 7072645F  [pdt_dt",A1."prd_]
  701.      40: 6C6E5F64 7363222C 41312E22 7072645F  [ln_dsc",A1."prd_]
  702.      50: 6C6E5F63 64222C41 312E226C 6E5F6275  [ln_cd",A1."ln_bu]
  703.      60: 735F6364 222C4131 2E226C6E 5F627573  [s_cd",A1."ln_bus]
  704.      70: 5F647363 222C4131 2E22636F 5F6E756D  [_dsc",A1."co_num]
  705.      80: 222C4131 2E227372 635F7379 735F6364  [",A1."src_sys_cd]
  706.      90: 222C4131 2E227372 635F7379 735F6B65  [",A1."src_sys_ke]
  707.      A0: 79222C41 312E2264 656C5F66 6C672220  [y",A1."del_flg" ]
  708.     B0: 46524F4D 20224F44 535F4D44 5F5F5052  [FROM "ODS_MD__PR]
  709.      C0: 4F445543 54222041 31                 [ODUCT" A1]
  710. Entered hgopoer at 2012/07/12-16:07:18
  711. hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...
  712. No query has been executed with that handle {HY000,NativeErr = 1}No query has be                                                                                                                                                             en executed with that handle {HY000,NativeErr = 1}
  713. Exiting hgopoer, rc=0 at 2012/07/12-16:07:18
  714. hgopars, line 526: calling SQLNumResultCols got sqlstate HY000
  715. Exiting hgopars, rc=28500 at 2012/07/12-16:07:18 with error ptr FILE:hgopars.c L                                                                                                                                                             INE:556 FUNCTION:hgopars() ID:Preprocess number of columns
  716. hostmstr:          0:   HOA After hoxpars
  717. hostmstr:          0: RPC After SQL Bundling
  718. hostmstr:          0: RPC Before SQL Bundling
  719. hostmstr:          0:   HOA Before hoxpars
  720. Entered hgopars, cursor id 1 at 2012/07/12-16:07:20
  721. type:0
  722. SQL text from hgopars, id=1, len=201 ...
  723.     00: 53454C45 43542041 312E2270 72645F63  [SELECT A1."prd_c]
  724.      10: 64222C41 312E2270 72645F64 7363222C  [d",A1."prd_dsc",]
  725.     20: 41312E22 6C645F64 74222C41 312E2275  [A1."ld_dt",A1."u]
  726.      30: 7064745F 6474222C 41312E22 7072645F  [pdt_dt",A1."prd_]
  727.      40: 6C6E5F64 7363222C 41312E22 7072645F  [ln_dsc",A1."prd_]
  728.      50: 6C6E5F63 64222C41 312E226C 6E5F6275  [ln_cd",A1."ln_bu]
  729.      60: 735F6364 222C4131 2E226C6E 5F627573  [s_cd",A1."ln_bus]
  730.      70: 5F647363 222C4131 2E22636F 5F6E756D  [_dsc",A1."co_num]
  731.      80: 222C4131 2E227372 635F7379 735F6364  [",A1."src_sys_cd]
  732.      90: 222C4131 2E227372 635F7379 735F6B65  [",A1."src_sys_ke]
  733.      A0: 79222C41 312E2264 656C5F66 6C672220  [y",A1."del_flg" ]
  734.     B0: 46524F4D 20224F44 535F4D44 5F5F5052  [FROM "ODS_MD__PR]
  735.      C0: 4F445543 54222041 31                 [ODUCT" A1]
  736. Entered hgopoer at 2012/07/12-16:07:20
  737. hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...
  738. No query has been executed with that handle {HY000,NativeErr = 1}No query has be                                                                                                                                                             en executed with that handle {HY000,NativeErr = 1}
  739. Exiting hgopoer, rc=0 at 2012/07/12-16:07:20
  740. hgopars, line 526: calling SQLNumResultCols got sqlstate HY000
  741. Exiting hgopars, rc=28500 at 2012/07/12-16:07:20 with error ptr FILE:hgopars.c L                                                                                                                                                             INE:556 FUNCTION:hgopars() ID:Preprocess number of columns
  742. hostmstr:          0:   HOA After hoxpars
  743. hostmstr:          0: RPC After SQL Bundling
  744. hostmstr:          0: RPC Before Describe Table
  745. hostmstr:          0:   HOA Before hoadtab
  746. Entered hgodtab at 2012/07/12-16:18:31
  747. count:1
  748.  table: ODS_MD__SYSTEM_ACCESS
  749. Allocate hoada[0] @ 0xde63c68
  750. Entered hgopcda at 2012/07/12-16:18:31
  751. Column:1(system_access_obj_id): dtype:6 (FLOAT), prc/scl:15/0, nullbl:1, octet:                                                                                                                                                             0, sign:1, radix:10
  752. Exiting hgopcda, rc=0 at 2012/07/12-16:18:31
  753. Entered hgopcda at 2012/07/12-16:18:31
  754. Column:2(system_access_type_cd_id): dtype:6 (FLOAT), prc/scl:15/0, nullbl:1, oc                                                                                                                                                             tet:0, sign:1, radix:10
  755. Exiting hgopcda, rc=0 at 2012/07/12-16:18:31
  756. Entered hgopcda at 2012/07/12-16:18:31
  757. Column:3(system_access_code_value): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1                                                                                                                                                             , octet:255, sign:1, radix:10
  758. Exiting hgopcda, rc=0 at 2012/07/12-16:18:31
  759. Entered hgopcda at 2012/07/12-16:18:31
  760. Column:4(effective_date): dtype:93 (TIMESTAMP), prc/scl:19/0, nullbl:1, octet:2                                                                                                                                                             55, sign:1, radix:10
  761. Exiting hgopcda, rc=0 at 2012/07/12-16:18:31
  762. Entered hgopcda at 2012/07/12-16:18:31
  763. Column:5(expiration_date): dtype:93 (TIMESTAMP), prc/scl:19/0, nullbl:1, octet:                                                                                                                                                             255, sign:1, radix:10
  764. Exiting hgopcda, rc=0 at 2012/07/12-16:18:31
  765. Entered hgopcda at 2012/07/12-16:18:31
  766. Column:6(role_player_id): dtype:6 (FLOAT), prc/scl:15/0, nullbl:1, octet:255, s                                                                                                                                                             ign:1, radix:10
  767. Exiting hgopcda, rc=0 at 2012/07/12-16:18:31
  768. Entered hgopcda at 2012/07/12-16:18:31
  769. Column:7(src_sys_cd): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, s                                                                                                                                                             ign:1, radix:10
  770. Exiting hgopcda, rc=0 at 2012/07/12-16:18:31
  771. Entered hgopcda at 2012/07/12-16:18:31
  772. Column:8(src_sys_key): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255,                                                                                                                                                              sign:1, radix:10
  773. Exiting hgopcda, rc=0 at 2012/07/12-16:18:31
  774. Entered hgopcda at 2012/07/12-16:18:31
  775. Column:9(ld_dt): dtype:93 (TIMESTAMP), prc/scl:19/0, nullbl:1, octet:255, sign:                                                                                                                                                             1, radix:10
  776. Exiting hgopcda, rc=0 at 2012/07/12-16:18:31
  777. Entered hgopcda at 2012/07/12-16:18:31
  778. Column:10(updt_dt): dtype:93 (TIMESTAMP), prc/scl:19/0, nullbl:1, octet:255, si                                                                                                                                                             gn:1, radix:10
  779. Exiting hgopcda, rc=0 at 2012/07/12-16:18:31
  780. Entered hgopcda at 2012/07/12-16:18:31
  781. Column:11(del_flg): dtype:12 (VARCHAR), prc/scl:255/0, nullbl:1, octet:255, sig                                                                                                                                                             n:1, radix:10
  782. Exiting hgopcda, rc=0 at 2012/07/12-16:18:31
  783. Entered hgopcda at 2012/07/12-16:18:31
  784. Column:12(start_date): dtype:93 (TIMESTAMP), prc/scl:19/0, nullbl:1, octet:255,                                                                                                                                                              sign:1, radix:10
  785. Exiting hgopcda, rc=0 at 2012/07/12-16:18:31
  786. Entered hgopcda at 2012/07/12-16:18:31
  787. Column:13(end_date): dtype:93 (TIMESTAMP), prc/scl:19/0, nullbl:1, octet:255, s                                                                                                                                                             ign:1, radix:10
  788. Exiting hgopcda, rc=0 at 2012/07/12-16:18:31
  789. The hoada for table ODS_MD__SYSTEM_ACCESS follows...
  790. hgodtab, line 1092: Printing hoada @ 0xde63c68
  791. MAX:13, ACTUAL:13, BRC:1, WHT=6 (TABLE_DESCRIBE)
  792. hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
  793. DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
  794.  8 DOUBLE  Y          8          8  53/  0    0   0   0 system_access_obj_id
  795.  8 DOUBLE  Y          8          8  53/  0    0   0   0 system_access_type_cd_i                                                                                                                                                             d
  796. 12 VARCHAR Y        255        255   0/  0    0   0 200 system_access_code_valu                                                                                                                                                             e
  797. 91 DATE    Y         16         16   0/  0    0   0   0 effective_date
  798. 91 DATE    Y         16         16   0/  0    0   0   0 expiration_date
  799.  8 DOUBLE  Y          8          8  53/  0    0   0   0 role_player_id
  800. 12 VARCHAR Y        255        255   0/  0    0   0 200 src_sys_cd
  801. 12 VARCHAR Y        255        255   0/  0    0   0 200 src_sys_key
  802. 91 DATE    Y         16         16   0/  0    0   0   0 ld_dt
  803. 91 DATE    Y         16         16   0/  0    0   0   0 updt_dt
  804. 12 VARCHAR Y        255        255   0/  0    0   0 200 del_flg
  805. 91 DATE    Y         16         16   0/  0    0   0   0 start_date
  806. 91 DATE    Y         16         16   0/  0    0   0   0 end_date
  807. Exiting hgodtab, rc=0 at 2012/07/12-16:18:31
  808. hostmstr:          0:   HOA After hoadtab
  809. hostmstr:          0:   HOA Before hoadafr
  810. Entered hgodafr, cursor id 0 at 2012/07/12-16:18:31
  811. Free hoada @ 0xde63c68
  812. Exiting hgodafr, rc=0 at 2012/07/12-16:18:31
  813. hostmstr:          0:   HOA After hoadafr
  814. hostmstr:          0: RPC After Describe Table
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!