3 Replies Latest reply: Aug 16, 2013 10:14 AM by SébastienG RSS

    Missing nvarchar columns when querying a MSSQL table from Oracle

    SébastienG

      Hi,

       

           I've configured a dblink from Oracle to MSSQL and when I'm querying a table, some columns are missing. The missing columns are all MSSQL nvarchar(4000) and from the trace file of dg4odbc, it seems that the database gateway cannot handle that datatype or maybe the size of those problematic columns.

       

      I'm wondering if there is an initialization parameter or any setting that could help hs to map correctly a MSSQL nvarchar(4000) knowing that other nvarchar columns with a smaller size can be mapped correctly ?

       

      From the dg4odbc trace file, I get this error for each MSSQL nvarchar(4000) columns:

       

      Column:10(TITLE) : dtype -9 (WVARCHAR), prc/scl:4000/3, nullbl:1, octet:8000, sign:1, radix:10

      Column 10 (TITLE): dtype -9 (WVARCHAR): this datatype is not supoprted.

       

      I'm suspecting oracle to not being able to handle "octet" bigger than 4000 knowing that after some testing on a DEV server, all MSSQL nvarchar columns smaller than 2000 in size are returned correctly by a query from Oracle.

       

      Here is some info:

       

      select * from v$nls_parameters

       

      PARAMETER
      VALUE
      NLS_LANGUAGECANADIAN FRENCH
      NLS_TERRITORYCANADA
      NLS_CURRENCY$
      NLS_ISO_CURRENCYCANADA
      NLS_NUMERIC_CHARACTERS,
      NLS_CALENDARGREGORIAN
      NLS_DATE_FORMATRR-MM-DD
      NLS_DATE_LANGUAGECANADIAN FRENCH
      NLS_CHARACTERSETWE8ISO8859P1
      NLS_SORTCANADIAN FRENCH
      NLS_TIME_FORMATHH24:MI:SSXFF
      NLS_TIMESTAMP_FORMATRR-MM-DD HH24:MI:SSXFF
      NLS_TIME_TZ_FORMATHH24:MI:SSXFF TZR
      NLS_TIMESTAMP_TZ_FORMATRR-MM-DD HH24:MI:SSXFF TZR
      NLS_DUAL_CURRENCY$
      NLS_NCHAR_CHARACTERSETAL16UTF16
      NLS_COMPBINARY
      NLS_LENGTH_SEMANTICSBYTE
      NLS_NCHAR_CONV_EXCPFALSE

       

      MSSQL Synprod db collation:

      Danish_Norwegian_CI_AS

       

      HS init file:

      # This is a sample agent init file that contains the HS parameters that are

      # needed for the Database Gateway for ODBC

       

      #

      # HS init parameters

      #

      HS_FDS_CONNECT_INFO = SYNPROD

      #HS_FDS_TRACE_LEVEL = off

      HS_FDS_TRACE_LEVEL=DEBUG

      HS_NLS_LANGUAGE = UCS2

      #

      # Environment variables required for the non-Oracle system

      #

      #set <envvar>=<value>

       

      HS trace file when querying a table description:

      Oracle Corporation --- THURSDAY  AUG 15 2013 15:42:08.007

       

       

      Heterogeneous Agent Release

      11.2.0.3.0

       

       

       

       

      Oracle Corporation --- THURSDAY  AUG 15 2013 15:42:08.007

       

          Version 11.2.0.3.0

       

      Entered hgogprd

      HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"

      Entered hgosdip

      setting HS_OPEN_CURSORS to default of 50

      setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"

      setting HS_FDS_RECOVERY_PWD to default value

      setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG

      setting HS_IDLE_TIMEOUT to default of 0

      setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"

      setting HS_NLS_NCHAR to default of "UCS2"

      setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"

      setting HS_FDS_DATE_MAPPING to default of "DATE"

      setting HS_RPC_FETCH_REBLOCKING to default of "ON"

      setting HS_FDS_FETCH_ROWS to default of "100"

      setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"

      setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"

      setting HS_FDS_PROC_IS_FUNC to default of "FALSE"

      setting HS_FDS_MAP_NCHAR to default of "TRUE"

      setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"

      setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"

      setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"

      setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"

      setting HS_FDS_QUERY_DRIVER to default of "TRUE"

      setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"

      setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE"

      setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"

      setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"

      setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"

      Default value of 64 assumed for HS_FDS_SQLLEN_INTERPRETATION

      setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"

      setting HS_FDS_DELAYED_OPEN to default of "TRUE"

      setting HS_FDS_WORKAROUNDS to default of "0"

      Exiting hgosdip, rc=0

      ORACLE_SID is "dg4odbc"

      Product-Info:

        Port Rls/Upd:3/0 PrdStat:0

        Agent:Oracle Database Gateway for ODBC

        Facility:hsa

        Class:ODBC, ClassVsn:11.2.0.3.0_0012, Instance:dg4odbc

      Exiting hgogprd, rc=0

      Entered hgoinit

      HOCXU_COMP_CSET=1

      HOCXU_DRV_CSET=178

      HOCXU_DRV_NCHAR=1000

      HOCXU_DB_CSET=31

      HS_LANGUAGE not specified

      rc=1239980 attempting to get LANG environment variable.

      HOCXU_SEM_VER=102000

      Entered hgolofn at 2013/08/15-15:42:08

      Exiting hgolofn, rc=0 at 2013/08/15-15:42:08

      HOSGIP for "HS_OPEN_CURSORS" returned "50"

      HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"

      HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"

      HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"

      HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"

      HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"

      HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"

      HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"

      HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"

      Invalid value of 64 given for HS_FDS_SQLLEN_INTERPRETATION

      treat_SQLLEN_as_compiled = 1

      Exiting hgoinit, rc=0 at 2013/08/15-15:42:08

      Entered hgolgon at 2013/08/15-15:42:08

      reco:0, name:synergiRead, tflag:0

      Entered hgosuec at 2013/08/15-15:42:08

      Exiting hgosuec, rc=0 at 2013/08/15-15:42:08

      HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"

      HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"

      HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"

      HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"

      HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"

      HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"

      HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"

      HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"

      HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"

      using synergiRead as default value for "HS_FDS_DEFAULT_OWNER"

      HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"

      Entered hgocont at 2013/08/15-15:42:08

      HS_FDS_CONNECT_INFO = "SYNPROD"

      RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"

      Entered hgogenconstr at 2013/08/15-15:42:08

      dsn:SYNPROD, name:synergiRead

      optn:

      Entered hgocip at 2013/08/15-15:42:08

      dsn:SYNPROD

      Exiting hgocip, rc=0 at 2013/08/15-15:42:08

      Exiting hgogenconstr, rc=0 at 2013/08/15-15:42:08

      Entered hgopoer at 2013/08/15-15:42:08

      hgopoer, line 234: got native error 5701 and sqlstate 01000; message follows...

      [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed database context to 'Synprod'. {01000,NativeErr = 5701}[Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language setting to us_english. {01000,NativeErr = 5703}

      Exiting hgopoer, rc=0 at 2013/08/15-15:42:08

      hgocont, line 2690: calling SqlDriverConnect got sqlstate 01000

      Entered hgolosf at 2013/08/15-15:42:08

      Exiting hgolosf, rc=0 at 2013/08/15-15:42:08

      DriverName:sqlncli10.dll, DriverVer:10.50.4000

      DBMS Name:Microsoft SQL Server, DBMS Version:10.50.4000

      Exiting hgocont, rc=0 at 2013/08/15-15:42:08 with error ptr FILE:hgocont.c LINE:2690 ID:SQLDriverConnect

      SQLGetInfo returns Y for SQL_CATALOG_NAME

      SQLGetInfo returns 128 for SQL_MAX_CATALOG_NAME_LEN

      Exiting hgolgon, rc=0 at 2013/08/15-15:42:08

      Entered hgoulcp at 2013/08/15-15:42:08

      Entered hgowlst at 2013/08/15-15:42:08

      Exiting hgowlst, rc=0 at 2013/08/15-15:42:08

      SQLGetInfo returns 0x1f for SQL_OWNER_USAGE

      TXN Capable:2, Isolation Option:0x2f

      SQLGetInfo returns 128 for SQL_MAX_SCHEMA_NAME_LEN

      SQLGetInfo returns 128 for SQL_MAX_TABLE_NAME_LEN

      SQLGetInfo returns 134 for SQL_MAX_PROCEDURE_NAME_LEN

      HOSGIP returned value of "TRUE" for HS_FDS_QUOTE_IDENTIFIER

      SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR

      14 instance capabilities will be uploaded

        capno:1989, context:0x00000000, add-info:        0

        capno:1992, context:0x0001ffff, add-info:        0

        capno:3042, context:0x00000000, add-info:        0, translation:"42"

        capno:3047, context:0x00000000, add-info:        0, translation:"57"

        capno:3049, context:0x00000000, add-info:        0, translation:"59"

        capno:3050, context:0x00000000, add-info:        0, translation:"60"

        capno:3066, context:0x00000000, add-info:        0

        capno:3067, context:0x00000000, add-info:        0

        capno:3068, context:0x00000000, add-info:        0

        capno:3069, context:0x00000000, add-info:        0

        capno:3500, context:0x00000001, add-info:       91, translation:"42"

        capno:3501, context:0x00000001, add-info:       93, translation:"57"

        capno:3502, context:0x00000001, add-info:      107, translation:"59"

        capno:3503, context:0x00000001, add-info:      110, translation:"60"

      Exiting hgoulcp, rc=0 at 2013/08/15-15:42:10

      Entered hgouldt at 2013/08/15-15:42:10

      NO instance DD translations were uploaded

      Exiting hgouldt, rc=0 at 2013/08/15-15:42:10

      Entered hgobegn at 2013/08/15-15:42:10

      tflag:0 , initial:1

      hoi:0x12ee18, ttid (len 38) is ...

        00: 43415350 45522E45 414D2E45 4C4B454D  [CASPER.EAM.ELKEM]

        10: 2E303030 33303039 662E3131 2E31362E  [.0003009f.11.16.]

        20: 31343533 3631                        [145361]

                       tbid (len 10) is ...

        0: 0B001000 D1370200 0104               [.....7....]

      Exiting hgobegn, rc=0 at 2013/08/15-15:42:11

      Entered hgodtab at 2013/08/15-15:42:11

      count:1

        table: ENERGY.D_TRANS

      Allocate hoada[0] @ 0000000005725F40

      Entered hgopcda at 2013/08/15-15:42:11

      Column:1(TRANS): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:2(UNIT_RESPONSIBLE): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:3(TRANS_ID): dtype:-5 (BIGINT), prc/scl:19/0, nullbl:1, octet:0, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:4(MODIFIED): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:0, octet:0, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:5(UNIT_IN_CHARGE): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:6(PERSON_IN_CHARGE): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:7(APPLICATION): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:8(STATUS): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:9(TRANS_DATE): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:0, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:10(TITLE): dtype:-9 (WVARCHAR), prc/scl:4000/3, nullbl:1, octet:8000, sign:1, radix:10

      Column 10 (TITLE): dtype -9 (WVARCHAR): this datatype is not supported.

      Entered hgopcda at 2013/08/15-15:42:11

      Column:10(DESCRIPTION): dtype:-9 (WVARCHAR), prc/scl:4000/3, nullbl:1, octet:8000, sign:1, radix:10

      Column 10 (DESCRIPTION): dtype -9 (WVARCHAR): this datatype is not supported.

      Entered hgopcda at 2013/08/15-15:42:11

      Column:10(COMMENTS): dtype:-9 (WVARCHAR), prc/scl:4000/3, nullbl:1, octet:8000, sign:1, radix:10

      Column 10 (COMMENTS): dtype -9 (WVARCHAR): this datatype is not supported.

      Entered hgopcda at 2013/08/15-15:42:11

      Column:10(DEADLINE): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:11(IMPORT_DATABASE_ID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:12(IMPORT_TRANS_ID): dtype:-9 (WVARCHAR), prc/scl:254/0, nullbl:1, octet:508, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:13(PERIOD_START): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:508, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:14(CREATED): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:0, octet:508, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:15(PERIOD_END): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:508, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:16(FLG_CONFIDENTIAL): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:508, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:11

      Entered hgopcda at 2013/08/15-15:42:11

      Column:17(TMP_MAIL_CMT_CIRCULATION): dtype:-9 (WVARCHAR), prc/scl:4000/0, nullbl:1, octet:8000, sign:1, radix:10

      Column 17 (TMP_MAIL_CMT_CIRCULATION): dtype -9 (WVARCHAR): this datatype is not supported.

      Entered hgopcda at 2013/08/15-15:42:11

      Column:17(TMP_MAIL_CMT_IN_CHARGE_OF): dtype:-9 (WVARCHAR), prc/scl:4000/0, nullbl:1, octet:8000, sign:1, radix:10

      Column 17 (TMP_MAIL_CMT_IN_CHARGE_OF): dtype -9 (WVARCHAR): this datatype is not supported.

      Entered hgopcda at 2013/08/15-15:42:11

      Column:17(TMP_MAIL_CASE_COMMENT): dtype:-9 (WVARCHAR), prc/scl:4000/0, nullbl:1, octet:8000, sign:1, radix:10

      Column 17 (TMP_MAIL_CASE_COMMENT): dtype -9 (WVARCHAR): this datatype is not supported.

      Entered hgopcda at 2013/08/15-15:42:11

      Column:17(TMP_MAIL_RECEIVERS_TO): dtype:-9 (WVARCHAR), prc/scl:4000/0, nullbl:1, octet:8000, sign:1, radix:10

      Column 17 (TMP_MAIL_RECEIVERS_TO): dtype -9 (WVARCHAR): this datatype is not supported.

      Entered hgopcda at 2013/08/15-15:42:12

      Column:17(TMP_MAIL_RECEIVERS_CC): dtype:-9 (WVARCHAR), prc/scl:4000/0, nullbl:1, octet:8000, sign:1, radix:10

      Column 17 (TMP_MAIL_RECEIVERS_CC): dtype -9 (WVARCHAR): this datatype is not supported.

      Entered hgopcda at 2013/08/15-15:42:12

      Column:17(TMP_MAIL_RECEIVERS_BCC): dtype:-9 (WVARCHAR), prc/scl:4000/0, nullbl:1, octet:8000, sign:1, radix:10

      Column 17 (TMP_MAIL_RECEIVERS_BCC): dtype -9 (WVARCHAR): this datatype is not supported.

      Entered hgopcda at 2013/08/15-15:42:12

      Column:17(DATE_EXT_1): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:18(DATE_EXT_2): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:19(DATE_EXT_3): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:20(DATE_EXT_4): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:21(DATE_EXT_5): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:22(FLG_REGENERATE_INDEX): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:23(CLOSED_IN_DAYS): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:24(PERSON_EXT_1): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:25(PERSON_EXT_2): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:26(OBSERVER): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:27(SHIFT): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:28(CHECK_LIST_CATEGORY): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:29(INVOLVED_PERSONS): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:30(FLG_ALLOW_ACCESS_PW): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:8000, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:31(CASE_PW): dtype:-9 (WVARCHAR), prc/scl:80/0, nullbl:1, octet:160, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:32(TMP_BUSINESS_TYPE): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:160, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:33(FLOAT_EXT_1): dtype:6 (FLOAT), prc/scl:53/0, nullbl:1, octet:160, sign:1, radix:2

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:34(FLOAT_EXT_2): dtype:6 (FLOAT), prc/scl:53/0, nullbl:1, octet:160, sign:1, radix:2

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:35(FLOAT_EXT_3): dtype:6 (FLOAT), prc/scl:53/0, nullbl:1, octet:160, sign:1, radix:2

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:36(FLOAT_EXT_4): dtype:6 (FLOAT), prc/scl:53/0, nullbl:1, octet:160, sign:1, radix:2

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:37(FLOAT_EXT_5): dtype:6 (FLOAT), prc/scl:53/0, nullbl:1, octet:160, sign:1, radix:2

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:38(TRANS_DATE_HOUR): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:160, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      Entered hgopcda at 2013/08/15-15:42:12

      Column:39(STATUS_TEMP): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:160, sign:1, radix:10

      Exiting hgopcda, rc=0 at 2013/08/15-15:42:12

      The hoada for table ENERGY.D_TRANS follows...

      hgodtab, line 1099: Printing hoada @ 0000000005725F40

      MAX:39, ACTUAL:39, BRC:1, WHT=6 (TABLE_DESCRIBE)

      hoadaMOD bit-values found (0x20:NEGATIVE_HOADADTY,0x40:TREAT_AS_NCHAR,0x400:UNICODE_COLUMN)

      DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME

        4 INTEGER N          4          4   0/  0    0   0   0 TRANS

        4 INTEGER N          4          4   0/  0    0   0   0 UNIT_RESPONSIBLE

      -5 BIGINT  Y          8          8   0/  0    0   0  20 TRANS_ID

      91 DATE    N         16         16   0/  0    0   0   0 MODIFIED

        4 INTEGER N          4          4   0/  0    0   0   0 UNIT_IN_CHARGE

        4 INTEGER N          4          4   0/  0    0   0   0 PERSON_IN_CHARGE

        4 INTEGER N          4          4   0/  0    0   0   0 APPLICATION

        4 INTEGER N          4          4   0/  0    0   0   0 STATUS

      91 DATE    Y         16         16   0/  0    0   0   0 TRANS_DATE

      91 DATE    Y         16         16   0/  0 1000   0 440 DEADLINE

        4 INTEGER Y          4          4   0/  0    0   0   0 IMPORT_DATABASE_ID

      12 VARCHAR Y        508        508 128/254 1000   0 440 IMPORT_TRANS_ID

      91 DATE    Y         16         16   0/  0    0   0   0 PERIOD_START

      91 DATE    N         16         16   0/  0    0   0   0 CREATED

      91 DATE    Y         16         16   0/  0    0   0   0 PERIOD_END

        4 INTEGER N          4          4   0/  0    0   0   0 FLG_CONFIDENTIAL

      91 DATE    Y         16         16   0/  0 1000   0 440 DATE_EXT_1

      91 DATE    Y         16         16   0/  0    0   0   0 DATE_EXT_2

      91 DATE    Y         16         16   0/  0    0   0   0 DATE_EXT_3

      91 DATE    Y         16         16   0/  0    0   0   0 DATE_EXT_4

      91 DATE    Y         16         16   0/  0    0   0   0 DATE_EXT_5

        4 INTEGER Y          4          4   0/  0    0   0   0 FLG_REGENERATE_INDEX

        4 INTEGER Y          4          4   0/  0    0   0   0 CLOSED_IN_DAYS

        4 INTEGER N          4          4   0/  0    0   0   0 PERSON_EXT_1

        4 INTEGER N          4          4   0/  0    0   0   0 PERSON_EXT_2

        4 INTEGER N          4          4   0/  0    0   0   0 OBSERVER

        4 INTEGER N          4          4   0/  0    0   0   0 SHIFT

        4 INTEGER N          4          4   0/  0    0   0   0 CHECK_LIST_CATEGORY

        4 INTEGER Y          4          4   0/  0    0   0   0 INVOLVED_PERSONS

        4 INTEGER N          4          4   0/  0    0   0   0 FLG_ALLOW_ACCESS_PW

      12 VARCHAR Y        160        160 128/ 80 1000   0 440 CASE_PW

        4 INTEGER Y          4          4   0/  0    0   0   0 TMP_BUSINESS_TYPE

        8 DOUBLE  Y          8          8  53/  0    0   0   0 FLOAT_EXT_1

        8 DOUBLE  Y          8          8  53/  0    0   0   0 FLOAT_EXT_2

        8 DOUBLE  Y          8          8  53/  0    0   0   0 FLOAT_EXT_3

        8 DOUBLE  Y          8          8  53/  0    0   0   0 FLOAT_EXT_4

        8 DOUBLE  Y          8          8  53/  0    0   0   0 FLOAT_EXT_5

        4 INTEGER Y          4          4   0/  0    0   0   0 TRANS_DATE_HOUR

        4 INTEGER N          4          4   0/  0    0   0   0 STATUS_TEMP

      Exiting hgodtab, rc=0 at 2013/08/15-15:42:12

      Entered hgodafr, cursor id 0 at 2013/08/15-15:42:12

      Free hoada @ 0000000005725F40

      Exiting hgodafr, rc=0 at 2013/08/15-15:42:12

       

      Thanks in advance.

       

      Sébastien