8 Replies Latest reply: Jan 14, 2013 1:37 AM by 978005 RSS

    How to deal with image type from SQL*Server2005

    978005
      when using transparent gateway between oracle 10 g and SQL*Server 2005 querying image type from SQL*Server 2005 error returned as follow:

      ORA-28500: When ORACLE connect to a non-Oracle system return this information:
      [Transparent gateway for MSSQL] (SQL State: 00000; SQL Code: 2090171257)
      ORA-02063: Followed by 2 lines (From OKFOC)

      My SQL is: select "attachment" from table@dblink where "empid"=empid

      I am using image type to store attachments.

      Regards!

      Edited by: BK_Ferdinand on 2013-1-10 下午7:09
        • 1. Re: How to deal with image type from SQL*Server2005
          978005
          Heterogeneous Agent Release
          10.2.0.1.0


          (0) hoagprd (2): ; hoagprd Entered.
          (0) HOACONN.C (244): ; [Transparent gateway for MSSQL] version:

          4.6.1.0.0070
          (0) HOACONN.C (295): ; Class version: 200
          (0) hoagprd (2): ; hoagprd Exited with retcode = 0.
          (0) hoainit (3): ; hoainit Entered.
          (0) (0): ; connect string is: defTdpName=OKFOC;SYNTAX=(ORACLE8_HOA,
          (0) BASED_ON=ORACLE8, IDENTIFIER_QUOTE_CHAR="",
          (0)

          CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=<navobj><binding><datasourc

          es><da-
          (0) tasource name='OKFOC' type='MSSQLODBC'
          (0)

          connect='SERVER=172.16.3.202;DATABASE=foc'><driverProperties/></datasour

          ce></d-
          (0) atasources><remoteMachines/><environment><optimizer

          noFlattener='true'/><misc
          (0) year2000Policy='-1' consumerApi='1'

          sessionBehavior='4'/><queryProcessor
          (0) parserDepth='2000' tokenSize='1000' noInsertParameterization='true'
          (0) noThreadedReadAhead='true'/><debug gdbTrace='true'

          bindingTrace='true'
          (0) driverTrace='true'

          generalTrace='true'/></environment></binding></navobj>
          (0) ORACLE SQL SERVER GATEWAY Log File Started at 2013-01-11T11:05:06
          (0) binding.c (515): ; Binding dump at 11-01-13 11:05:
          (0) binding.c (518): ; Last binding error: None:
          (0) <binding name='NAV'>
               <remoteMachines name='NAV'></remoteMachines>
               
               <datasources name='NAV'>
                    <datasource name='NAV_ADMIN' type='ADM'

          connect='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp' syntaxName='ADM'>
                         <objectStoreConfig></objectStoreConfig>
                    </datasource>
                    
                    <datasource name='NAV_PROC' type='PROC'

          connect='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp'

          syntaxName='PROC'>
                         <objectStoreConfig></objectStoreConfig>
                    </datasource>
                    
                    <datasource name='NAV_SYSTEM' type='SYS'

          connect='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp' syntaxName='SYS'>
                         <objectStoreConfig></objectStoreConfig>
                    </datasource>
                    
                    <datasource name='OKFOC' type='MSSQLODBC'

          syntaxName='MSSQLODBC'>
                         
                         <config

          sqlServerConnect='SERVER=172.16.3.202;DATABASE=foc'/>
                         <objectStoreConfig></objectStoreConfig>
                    </datasource>
                    
                    <datasource name='ORACLE' type='ORACLE8' connect='@main'

          syntaxName='ORACLE8'>
                         <objectStoreConfig></objectStoreConfig>
                    </datasource>
                    
                    <datasource name='sys' type=
          (0) 'dsm' syntaxName='dsm'>
                         <objectStoreConfig></objectStoreConfig>
                    </datasource>
                    
                    <datasource name='___sys' type='ADD-DISAM'

          syntaxName='dsm' objectStoreName='sys'>
                         
                         <config

          newFileLocation='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp'/>
                         <objectStoreConfig></objectStoreConfig>
                    </datasource>
               </datasources>
               
               <environment name='NAV'>
                    <misc tempDir='E:\oracle\product\10.2.0\tg_1

          \tg4msql\tmp' year2000Policy='-1' consumerApi='1'

          sessionBehavior='4'></misc>
                    
                    <debug logFile='E:\oracle\product\10.2.0\tg_1

          \tg4msql\tmp\nav.log' traceDir='E:\oracle\product\10.2.0\tg_1

          \tg4msql\tmp\' generalTrace='true' gdbTrace='true' driverTrace='true'

          apiTrace='true' bindingTrace='true'></debug>
                    
                    <queryProcessor noThreadedReadAhead='true'

          noInsertParameterization='true' parserDepth='2000'

          tokenSize='1000'></queryProcessor>
                    
                    <optimizer noFlattener='true'></optimizer>
                    
                    <transactions></transactions>
                    
                    <odbc></odbc>
                    
                    <oledb></oledb>
                    
                    <tuning></tuning>
                    
                    <comm sockT
          (0) ypeOfService='default'></comm>
                    
                    <tempFeatures></tempFeatures>
               </environment>
               
               <adapters name='NAV'></adapters>
          </binding>
          • 2. Re: How to deal with image type from SQL*Server2005
            978005
            (0) hoainit (3): ; hoainit Exited with retcode = 0.
            (0) hoalgon (7): ; hoalgon Entered. name = okfoc.
            (0) binding.c (515): ; Binding dump at 11-01-13 11:05:
            (0) binding.c (518): ; Last binding error: None:
            (0) <binding name='NAV'>
                 <remoteMachines name='NAV'></remoteMachines>
                 
                 <datasources name='NAV'>
                      <datasource name='NAV_ADMIN' type='ADM'

            connect='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp' syntaxName='ADM'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='NAV_PROC' type='PROC'

            connect='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp'

            syntaxName='PROC'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='NAV_SYSTEM' type='SYS'

            connect='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp' syntaxName='SYS'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='OKFOC' type='MSSQLODBC'

            syntaxName='MSSQLODBC'>
                           
                           <config

            sqlServerConnect='SERVER=172.16.3.202;DATABASE=foc'/>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='ORACLE' type='ORACLE8' connect='@main'

            syntaxName='ORACLE8'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='sys' type=
            (0) 'dsm' syntaxName='dsm'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='___sys' type='ADD-DISAM'

            syntaxName='dsm' objectStoreName='sys'>
                           
                           <config

            newFileLocation='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp'/>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                 </datasources>
                 
                 <environment name='NAV'>
                      <misc tempDir='E:\oracle\product\10.2.0\tg_1

            \tg4msql\tmp' year2000Policy='-1' consumerApi='1'

            sessionBehavior='4'></misc>
                      
                      <debug logFile='E:\oracle\product\10.2.0\tg_1

            \tg4msql\tmp\nav.log' traceDir='E:\oracle\product\10.2.0\tg_1

            \tg4msql\tmp\' generalTrace='true' gdbTrace='true' driverTrace='true'

            apiTrace='true' bindingTrace='true'></debug>
                      
                      <queryProcessor noThreadedReadAhead='true'

            noInsertParameterization='true' parserDepth='2000'

            tokenSize='1000'></queryProcessor>
                      
                      <optimizer noFlattener='true'></optimizer>
                      
                      <transactions></transactions>
                      
                      <odbc></odbc>
                      
                      <oledb></oledb>
                      
                      <tuning></tuning>
                      
                      <comm sockT
            (0) ypeOfService='default'></comm>
                      
                      <tempFeatures></tempFeatures>
                 </environment>
                 
                 <adapters name='NAV'></adapters>
            </binding>

            (0) XmlProto.c (5554): ; Datasource configuration for 'OKFOC' is:
            (0) <config sqlServerConnect='SERVER=172.16.3.202;DATABASE=foc'

            server='' dbName='' ansiNull='true' quoteIdentifiers='true' timeout='60'

            isolationLevel='dynamicIsolation' reportRealAsDouble='false'></config>

            (0) i: 924 0 SQLAllocConnect:- henv=1424718,phd=12E1C4
            (0) i: 938 0 SQLSetConnectOption:- hdbc=14247C0, fop=103 , vprm=0
            (0) i: 945 1 SQLDriverConnect:- hdbc=14247C0, hwnd=0, scsi=12E254,

            ccsi=-3, s
            cso=12E354, ccsom=1020, pcso=12E1CA, fdc=0,
            (0) i: 955 0 SQLGetInfo:- hdbc=14247C0, fit=18 ,rif=12e1d0, civm=130,

            piv=12E
            1CC
            (0) i: 960 0 SQLSetConnectOption:- hdbc=14247C0, fop=1217 , vprm=1
            (0) Created new MSSQLODBC connection (21120960)
            (0) i: 723 0 SQLGetInfo:- hdbc=14247C0, fit=28 ,rif=12e770, civm=2,

            piv=0
            (0) i: 733 0 SQLGetInfo:- hdbc=14247C0, fit=93 ,rif=12e770, civm=2,

            piv=0
            (0) i: 741 0 SQLGetInfo:- hdbc=14247C0, fit=72 ,rif=12e774, civm=4,

            piv=0
            (0) r:1347 0 SQLAllocStmt:- hdbc=14247C0,pst=12E624
            (0) r:1356 0 SQLBindCol:-

            hst=14254F0,icl=1,fct=1,rgv=12E650,cbvm=128,pcv=123
            8592
            (0) r:1357 0 SQLBindCol:-

            hst=14254F0,icl=2,fct=5,rgv=12E62C,cbvm=0,pcv=12385
            92
            (0) r:1358 0 SQLBindCol:-

            hst=14254F0,icl=3,fct=4,rgv=12E64C,cbvm=0,pcv=12385
            88
            (0) r:1359 0 SQLBindCol:-

            hst=14254F0,icl=6,fct=1,rgv=12E6D4,cbvm=128,pcv=123
            8584
            (0) r:1360 0 SQLBindCol:-

            hst=14254F0,icl=10,fct=5,rgv=12E62A,cbvm=0,pcv=1238
            600
            (0) r:1361 0 SQLBindCol:-

            hst=14254F0,icl=14,fct=5,rgv=12E632,cbvm=0,pcv=1238
            596
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363 0 SQLFetch:- hst=14254F0
            (0) r:1363100 SQLFetch:- hst=14254F0
            (0) r:1394 0 SQLFreeStmt:- hst=14254F0, fop=1
            (0) hoalgon (7): ; hoalgon Exited with retcode = 0.
            (0) hoaulcp (4): ; hoaulcp Entered.
            (0) hoaulcp (4): ; hoaulcp Exited with retcode = 0.
            (0) hoauldt (5): ; hoauldt Entered.
            (0) hoauldt (5): ; hoauldt Exited with retcode = 0.
            (0) hoabegn (9): ; hoabegn Entered. formatID = 306206, hoagttln = 57,

            hoagttid =
            (0) ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM.f04eafd4.10.34.17899, hoagtbln

            = 10,
            (0) hoagtbid =
            , tflag = 0, initial = 1
            (0) e:1005 0 SQLGetConnectOption:- hdbc=14247C0, fop=102 , pvprm=12EA80
            (0) e:1007 0 SQLSetConnectOption:- hdbc=14247C0, fop=108 , vprm=1
            (0) e:1012 0 SQLSetConnectOption:- hdbc=14247C0, fop=102 , vprm=0
            (0) hoabegn (9): ; hoabegn Exited with retcode = 0.
            (0) hoadtab (26): ; hoadtab Entered. count = 1
            (0) hoadtab (26): ; schema_name = , table_name = T_FLY_FLYER_REWARD
            (0) mssqlodbc_rec: Select TOP 0 * FROM "T_FLY_FLYER_REWARD"
            (0) r: 74 0 SQLAllocStmt:- hdbc=14247C0,pst=12E0C4
            (0) r: 113 0 SQLPrepare:- hst=14254F0, css=1237272
            (0) 13 0 Ssss = Select TOP 0 * FROM "T_FLY_FLYER_REWARD"
            (0) r: 863 0 SQLNumResultCols:- hst=14254F0,pcol=12
            (0) r: 886 0 SQLDescribeCol:-

            hst=14254F0,icol=1,scn=pkid,cnm=64,pcn=12DFE2,p
            st=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
            (0) r: 903 0 SQLColAttributes:-

            hst=14254F0,icol=1,fdt=10,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE4
            (0) r: 909 0 SQLColAttributes:-

            hst=14254F0,icol=1,fdt=11,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE8
            (0) r: 886 0 SQLDescribeCol:-

            hst=14254F0,icol=2,scn=empid,cnm=64,pcn=12DFE2,
            pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
            (0) r: 903 0 SQLColAttributes:-

            hst=14254F0,icol=2,fdt=10,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE4
            (0) r: 909 0 SQLColAttributes:-

            hst=14254F0,icol=2,fdt=11,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE8
            (0) r: 886 0 SQLDescribeCol:-

            hst=14254F0,icol=3,scn=startdate,cnm=64,pcn=12D
            FE2,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
            (0) r: 903 0 SQLColAttributes:-

            hst=14254F0,icol=3,fdt=10,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE4
            (0) r: 909 0 SQLColAttributes:-

            hst=14254F0,icol=3,fdt=11,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE8
            (0) r: 886 0 SQLDescribeCol:-

            hst=14254F0,icol=4,scn=enddate,cnm=64,pcn=12DFE
            2,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
            (0) r: 903 0 SQLColAttributes:-

            hst=14254F0,icol=4,fdt=10,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE4
            (0) r: 909 0 SQLColAttributes:-

            hst=14254F0,icol=4,fdt=11,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE8
            (0) r: 886 0 SQLDescribeCol:-

            hst=14254F0,icol=5,scn=recate,cnm=64,pcn=12DFE2
            ,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
            (0) r: 903 0 SQLColAttributes:-

            hst=14254F0,icol=5,fdt=10,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE4
            (0) r: 909 0 SQLColAttributes:-

            hst=14254F0,icol=5,fdt=11,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE8
            (0) r: 886 0 SQLDescribeCol:-

            hst=14254F0,icol=6,scn=retype,cnm=64,pcn=12DFE2
            ,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
            (0) r: 903 0 SQLColAttributes:-

            hst=14254F0,icol=6,fdt=10,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE4
            (0) r: 909 0 SQLColAttributes:-

            hst=14254F0,icol=6,fdt=11,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE8
            (0) r: 886 0 SQLDescribeCol:-

            hst=14254F0,icol=7,scn=rereson,cnm=64,pcn=12DFE
            2,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
            (0) r: 903 0 SQLColAttributes:-

            hst=14254F0,icol=7,fdt=10,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE4
            (0) r: 909 0 SQLColAttributes:-

            hst=14254F0,icol=7,fdt=11,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE8
            (0) r: 886 0 SQLDescribeCol:-

            hst=14254F0,icol=8,scn=remark,cnm=64,pcn=12DFE2
            ,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
            (0) r: 903 0 SQLColAttributes:-

            hst=14254F0,icol=8,fdt=10,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE4
            (0) r: 909 0 SQLColAttributes:-

            hst=14254F0,icol=8,fdt=11,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE8
            (0) r: 886 0 SQLDescribeCol:-

            hst=14254F0,icol=9,scn=lastmodifier,cnm=64,pcn=
            12DFE2,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
            (0) r: 903 0 SQLColAttributes:-

            hst=14254F0,icol=9,fdt=10,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE4
            (0) r: 909 0 SQLColAttributes:-

            hst=14254F0,icol=9,fdt=11,rgbd=0,cbdm=0,pcbd=
            0,pfd=12DFE8
            (0) r: 886 0 SQLDescribeCol:-

            hst=14254F0,icol=10,scn=lastmodifidate,cnm=64,p
            cn=12DFE2,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
            (0) r: 903 0 SQLColAttributes:-

            hst=14254F0,icol=10,fdt=10,rgbd=0,cbdm=0,pcbd
            =0,pfd=12DFE4
            (0) r: 909 0 SQLColAttributes:-

            hst=14254F0,icol=10,fdt=11,rgbd=0,cbdm=0,pcbd
            =0,pfd=12DFE8
            (0) r: 886 0 SQLDescribeCol:-

            hst=14254F0,icol=11,scn=attachment,cnm=64,pcn=1
            2DFE2,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
            (0) r: 903 0 SQLColAttributes:-

            hst=14254F0,icol=11,fdt=10,rgbd=0,cbdm=0,pcbd
            =0,pfd=12DFE4
            (0) r: 909 0 SQLColAttributes:-

            hst=14254F0,icol=11,fdt=11,rgbd=0,cbdm=0,pcbd
            =0,pfd=12DFE8
            (0) r: 886 0 SQLDescribeCol:-

            hst=14254F0,icol=12,scn=attachmentname,cnm=64,p
            cn=12DFE2,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
            (0) r: 903 0 SQLColAttributes:-

            hst=14254F0,icol=12,fdt=10,rgbd=0,cbdm=0,pcbd
            =0,pfd=12DFE4
            (0) r: 909 0 SQLColAttributes:-

            hst=14254F0,icol=12,fdt=11,rgbd=0,cbdm=0,pcbd
            =0,pfd=12DFE8
            (0) r: 147 0 SQLFreeStmt:- hst=14254F0, fop=1
            (0) r:1215 0 SQLAllocStmt:- hdbc=14247C0,pst=12DDB4
            (0) r:1222 0 SQLStatistics:-

            hst=14254F0,scn=0,ccn=0,ssn=0,csn=0,stn=12E00C,c
            tn=-3,funq=1,fcc=0
            (0) cs:- hscn=, ssn=, stn=T_FLY_FLYER_REWARD
            (0) r:1231 0 SQLBindCol:-

            hst=14254F0,icl=2,fct=1,rgv=12DF04,cbvm=129,pcv=123
            6448
            (0) r:1232 0 SQLBindCol:-

            hst=14254F0,icl=4,fct=5,rgv=12DDD4,cbvm=0,pcv=12364
            40
            (0) r:1233 0 SQLBindCol:-

            hst=14254F0,icl=6,fct=1,rgv=12DF88,cbvm=129,pcv=123
            6468
            (0) r:1234 0 SQLBindCol:-

            hst=14254F0,icl=7,fct=5,rgv=12DDC4,cbvm=0,pcv=12364
            72
            (0) r:1235 0 SQLBindCol:-

            hst=14254F0,icl=9,fct=1,rgv=12E090,cbvm=129,pcv=123
            6464
            (0) r:1236 0 SQLBindCol:-

            hst=14254F0,icl=10,fct=1,rgv=12DDCA,cbvm=2,pcv=1236
            456
            (0) r:1237 0 SQLBindCol:-

            hst=14254F0,icl=11,fct=4,rgv=12DDD0,cbvm=0,pcv=1236
            428
            (0) r:1238 0 SQLBindCol:-

            hst=14254F0,icl=12,fct=4,rgv=12DDE4,cbvm=0,pcv=1236
            444
            (0) r:1245 0 SQLFetch:- hst=14254F0
            (0) r:1267100 SQLFetch:- hst=14254F0
            (0) r:1311 0 SQLFreeStmt:- hst=14254F0, fop=1
            (0) nvOUT (F:\Work\Connect_4_6_3\src\qp\QP_SQTXT.C 55): select

            NON_UNIQUE,
            (0) INDEX_NAME, TYPE, SEQ_IN_INDEX, COLLATION, CARDINALITY, COLUMN_NAME

            from
            (0) NAV_PROC:SP_STATISTICS('OKFOC', '%', 'T_FLY_FLYER_REWARD', 1, 0, 0)

            order by
            (0) 3, 1, 2, 4
            (0) <PROC> < OK>: GDB version 400
            (0) <PROC> GDB_DB_FUNCTION INFO:
            (0) Attributes: No GST.
            (0) Bookmark Size = 0
            (0) Datasource Fns: io_get_last_error; io_connect; io_disconnect;
            (0) io_set_connect.
            (0) Metadata Fns: io_get_item_list; io_describe_table;

            io_describe_sp.
            (0) Data Retrieval Fns: io_open; io_set_buffer; io_set_index;

            io_set_params;
            (0) io_fetch; io_close; io_rewind.
            (0) Update Fns: <None>.
            (0) Transaction Fns: <None>.
            (0) Data Definition Fns: <None>.
            (0) Blob Fns: <None>.
            (0) SQL Fns: <None>.
            (0) Chapter Fns: <None>.
            (0) Foreign keys Fns: <None>.
            (0) <PROC> : -->>>> CONNECT
            (0) <PROC> < OK>: CONNECT NAV_PROC ''
            (0) nvRETURN (F:\Work\Connect_4_6_3\src\qp\qpsynon.c 1140): -1
            (0) <PROC> : -->>>> DESCRIBE_SP
            (0) <PROC> < OK>: DESCRIBE_SP @SP_STATISTICS
            (0) <<<<<<<<<<<<<<<<<<< Execution Strategy Begin
            • 3. Re: How to deal with image type from SQL*Server2005
              978005
              (0) Original SQL:
              (0) select NON_UNIQUE , INDEX_NAME , TYPE , SEQ_IN_INDEX , COLLATION ,

              CARDINALITY , COLUMN_NAME from NAV_PROC : SP_STATISTICS ( 'OKFOC' , '%'

              , 'T_FLY_FLYER_REWARD' , 1 , 0 , 0 ) order by 3 , 1 , 2 , 4
              (0)


              (0)
              (0) Accessing saved query spec SP_STATISTICS()
              (0) from NAV_PROC DB
              (0)
              Execution Strategy End >>>>>>>>>>>>>>>>>>>>>>>>>>>>
              (0) <PROC> : -->>>> OPEN
              (0) <PROC> < OK>: OPEN SP_STATISTICS(0)
              (0) <PROC> : -->>>> SET_BUFFER
              (0) <PROC> < OK>: SET_BUFFER SP_STATISTICS(0)
              (0) <PROC> : -->>>> SET_PARAMS
              (0) <PROC> < OK>: SET_PARAMS SP_STATISTICS(0)
              (0) <PROC> : -->>>> FETCH
              (0) <PROC> < OK>: FETCH SP_STATISTICS(0)
              (0) <PROC> : -->>>> FETCH
              (0) <PROC> < EOS>: FETCH SP_STATISTICS(0)
              (0) <PROC> : -->>>> CLOSE
              (0) <PROC> < OK>: CLOSE SP_STATISTICS(0)
              (0) HOAUTIL.C (1259): ; ------ hoadtab (hoat) -------:
              (0) HOAUTIL.C (1262): ; hoatnam: T_FLY_FLYER_REWARD, hoatnml: 18,

              hoatnrw: 3,
              (0) hoatarl: 1881
              (0) HOAUTIL.C (1273): ; ------ hoadtab (hoai) -------:
              (0) HOAUTIL.C (1274): ; n_index_stat: 0
              (0) HOAUTIL.C (1224): ; -------- hoadtab for table T_FLY_FLYER_REWARD--

              -------:
              (0) HOAUTIL.C (1225): ; hoadamsz: 12, hoadasiz: 12, hoadambr: 1,

              hoadabrc: 0
              (0) HOAUTIL.C (1228): ; row 0 - hoadambl: 4, hoadadty: 8, hoadaprc: 10,

              hoadacst: 0
              (0) HOAUTIL.C (1232): ; row 0 - hoadascl: 0, hoadanul: 1, hoadanml: 4,

              hoadanam:
              (0) pkid, hoadabfl: 4, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 1 - hoadambl: 4, hoadadty: 8, hoadaprc: 10,

              hoadacst: 0
              (0) HOAUTIL.C (1232): ; row 1 - hoadascl: 0, hoadanul: 1, hoadanml: 5,

              hoadanam:
              (0) empid, hoadabfl: 4, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 2 - hoadambl: 7, hoadadty: 167, hoadaprc: 0,

              hoadacst:
              (0) 0
              (0) HOAUTIL.C (1232): ; row 2 - hoadascl: 0, hoadanul: 1, hoadanml: 9,

              hoadanam:
              (0) startdate, hoadabfl: 7, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 3 - hoadambl: 7, hoadadty: 167, hoadaprc: 0,

              hoadacst:
              (0) 0
              (0) HOAUTIL.C (1232): ; row 3 - hoadascl: 0, hoadanul: 1, hoadanml: 7,

              hoadanam:
              (0) enddate, hoadabfl: 7, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 4 - hoadambl: 8, hoadadty: 14, hoadaprc: 8,

              hoadacst:
              (0) 1000
              (0) HOAUTIL.C (1232): ; row 4 - hoadascl: 0, hoadanul: 1, hoadanml: 6,

              hoadanam:
              (0) recate, hoadabfl: 8, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 5 - hoadambl: 100, hoadadty: 14, hoadaprc:

              100,
              (0) hoadacst: 1000
              (0) HOAUTIL.C (1232): ; row 5 - hoadascl: 0, hoadanul: 1, hoadanml: 6,

              hoadanam:
              (0) retype, hoadabfl: 100, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 6 - hoadambl: 400, hoadadty: 14, hoadaprc:

              400,
              (0) hoadacst: 1000
              (0) HOAUTIL.C (1232): ; row 6 - hoadascl: 0, hoadanul: 1, hoadanml: 7,

              hoadanam:
              (0) rereson, hoadabfl: 400, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 7 - hoadambl: 1000, hoadadty: 14, hoadaprc:

              1000,
              (0) hoadacst: 1000
              (0) HOAUTIL.C (1232): ; row 7 - hoadascl: 0, hoadanul: 1, hoadanml: 6,

              hoadanam:
              (0) remark, hoadabfl: 1000, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 8 - hoadambl: 40, hoadadty: 14, hoadaprc:

              40,
              (0) hoadacst: 1000
              (0) HOAUTIL.C (1232): ; row 8 - hoadascl: 0, hoadanul: 1, hoadanml: 12,

              hoadanam:
              (0) lastmodifier, hoadabfl: 40, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 9 - hoadambl: 7, hoadadty: 167, hoadaprc: 0,

              hoadacst:
              (0) 0
              (0) HOAUTIL.C (1232): ; row 9 - hoadascl: 0, hoadanul: 1, hoadanml: 14,

              hoadanam:
              (0) lastmodifidate, hoadabfl: 7, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 10 - hoadambl: 2147483647, hoadadty: 166,

              hoadaprc:
              (0) 2147483647, hoadacst: 0
              (0) HOAUTIL.C (1232): ; row 10 - hoadascl: 0, hoadanul: 1, hoadanml: 10,

              hoadanam:
              (0) attachment, hoadabfl: 2147483647, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 11 - hoadambl: 200, hoadadty: 14, hoadaprc:

              200,
              (0) hoadacst: 1000
              (0) HOAUTIL.C (1232): ; row 11 - hoadascl: 0, hoadanul: 1, hoadanml: 14,

              hoadanam:
              (0) attachmentname, hoadabfl: 200, hoadamod: 0
              (0) hoadtab (26): ; hoadtab Exited with retcode = 0.
              (0) hoadafr (23): ; hoadafr Entered. id = 0.
              (0) hoadafr (23): ; hoadafr Exited with retcode = 0.
              (0) hoapars (15): ; hoapars Entered. stmtType = 0, id = 1.
              (0) nvOUT (F:\Work\Connect_4_6_3\src\qp\QP_SQTXT.C 55): SELECT

              A1."attachment"
              (0) FROM "T_FLY_FLYER_REWARD" A1 WHERE A1."empid"=10004036
              (0) nvRETURN (F:\Work\Connect_4_6_3\src\qp\qpsynon.c 1140): -1
              (0) SELECT "A1"."attachmentname" AS c001, "A1"."lastmodifidate" AS

              c002, "A1"."lastmodifier" AS c003, "A1"."remark" AS c004, "A1"."rereson"

              AS c005, "A1"."retype" AS c006, "A1"."recate" AS c007, "A1"."enddate" AS

              c008, "A1"."startdate" AS c009, "A1"."empid" AS c010, "A1"."pkid" AS

              c011 FROM "T_FLY_FLYER_REWARD" "A1" WHERE ("A1"."empid" = 10004036)
              (0)

              (0) r: 74 0 SQLAllocStmt:- hdbc=14247C0,pst=12E7C0
              (0) r: 113 0 SQLPrepare:- hst=14254F0, css=14785772
              (0) Ssss = SELECT "A1"."attachmentname" AS c001,

              "A1"."lastmodifid
              ate" AS c002, "A1"."lastmodifier" AS c003, "A1"."remark"

              AS c0
              04, "A1"."rereson" AS c005, "A1"."retype" AS c006,

              "A1"."recat
              e" AS c007, "A1"."enddate" AS c008, "A1"."startdate" AS

              c009,
              "A1"."empid" AS c010, "A1"."pkid" AS c011 FROM

              "T_FLY_FLYER_RE
              WARD" "A1" WHERE ("A1"."empid" = 10004036)
              (0) r: 863 0 SQLNumResultCols:- hst=14254F0,pcol=11
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=1,scn=c001,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=1,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=1,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=2,scn=c002,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=2,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=2,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=3,scn=c003,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=3,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=3,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=4,scn=c004,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=4,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=4,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=5,scn=c005,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=5,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=5,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=6,scn=c006,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=6,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=6,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=7,scn=c007,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=7,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=7,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=8,scn=c008,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=8,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=8,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=9,scn=c009,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=9,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=9,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=10,scn=c010,cnm=64,pcn=12E6DE,
              pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=10,fdt=10,rgbd=0,cbdm=0,pcbd
              =0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=10,fdt=11,rgbd=0,cbdm=0,pcbd
              =0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=11,scn=c011,cnm=64,pcn=12E6DE,
              pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=11,fdt=10,rgbd=0,cbdm=0,pcbd
              =0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=11,fdt=11,rgbd=0,cbdm=0,pcbd
              =0,pfd=12E6E4
              (0) r: 147 0 SQLFreeStmt:- hst=14254F0, fop=1
              (0) <<<<<<<<<<<<<<<<<<< Execution Strategy Begin

              <<<<<<<<<<<<<<<<<<<<<<<<<<<<
              (0) Original SQL:
              (0) SELECT A1 . "attachment" FROM "T_FLY_FLYER_REWARD" A1 WHERE A1 .

              "empid" = 10004036
              (0)


              (0)
              (0) Accessing Database 'OKFOC' with SQL:
              (0) SELECT "A1"."attachmentname" AS c001, "A1"."lastmodifidate" AS

              c002, "A1"."lastmodifier" AS c003, "A1"."remark" AS c004, "A1"."rereson"

              AS c005, "A1"."retype" AS c006, "A1"."recate" AS c007, "A1"."enddate" AS

              c008, "A1"."startdate" AS c009, "A1"."empid" AS c010, "A1"."pkid" AS

              c011 FROM "T_FLY_FLYER_REWARD" "A1" WHERE ("A1"."empid" = 10004036)
              (0)

              (0)
              Execution Strategy End >>>>>>>>>>>>>>>>>>>>>>>>>>>>
              (0) hoapars (15): ; hoapars Exited with retcode = 0.
              (0) hoaopen (19): ; hoaopen Entered. id = 1.
              (0) hoaopen (19): ; hoaopen Exited with retcode = 0.
              (0) hoadscr (16): ; hoadscr Entered. id = 1.
              (0) hoastmt.c (304): ; Array fetch size is: 1.
              (0) HOAUTIL.C (1224): ; ------ hoadscr() -------:
              (0) HOAUTIL.C (1225): ; hoadamsz: 1, hoadasiz: 1, hoadambr: 1, hoadabrc:

              1
              (0) HOAUTIL.C (1228): ; row 0 - hoadambl: 2147483647, hoadadty: 166,

              hoadaprc:
              (0) 2147483647, hoadacst: 0
              (0) HOAUTIL.C (1232): ; row 0 - hoadascl: 0, hoadanul: 1, hoadanml: 13,

              hoadanam:
              (0) A1.attachment, hoadabfl: 2147483647, hoadamod: 0
              (0) hoadscr (16): ; hoadscr Exited with retcode = 0.
              (0) hoaftch (21): ; hoaftch Entered. id = 1.
              (0) apiutil.c (0): ; hoaftch()::
              (0) apiutil.c (0): ; Column 0 - pszName: A1.attachment, size: 1827, id:

              0, width:
              (0) 1827, scale: 0, flags: 68.
              (0) SELECT "A1"."attachmentname" AS c001, "A1"."lastmodifidate" AS

              c002, "A1"."lastmodifier" AS c003, "A1"."remark" AS c004, "A1"."rereson"

              AS c005, "A1"."retype" AS c006, "A1"."recate" AS c007, "A1"."enddate" AS

              c008, "A1"."startdate" AS c009, "A1"."empid" AS c010, "A1"."pkid" AS

              c011 FROM "T_FLY_FLYER_REWARD" "A1" WHERE ("A1"."empid" = 10004036)
              (0)

              (0) r: 74 0 SQLAllocStmt:- hdbc=14247C0,pst=12EBBC
              (0) r: 113 0 SQLPrepare:- hst=14254F0, css=14635668
              (0) Ssss = SELECT "A1"."attachmentname" AS c001,

              "A1"."lastmodifid
              ate" AS c002, "A1"."lastmodifier" AS c003, "A1"."remark"

              AS c0
              04, "A1"."rereson" AS c005, "A1"."retype" AS c006,

              "A1"."recat
              e" AS c007, "A1"."enddate" AS c008, "A1"."startdate" AS

              c009,
              "A1"."empid" AS c010, "A1"."pkid" AS c011 FROM

              "T_FLY_FLYER_RE
              WARD" "A1" WHERE ("A1"."empid" = 10004036)
              (0) r: 863 0 SQLNumResultCols:- hst=14254F0,pcol=11
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=1,scn=c001,cnm=64,pcn=12EADA,p
              st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=1,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EADC
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=1,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EAE0
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=2,scn=c002,cnm=64,pcn=12EADA,p
              st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=2,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EADC
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=2,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EAE0
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=3,scn=c003,cnm=64,pcn=12EADA,p
              st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=3,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EADC
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=3,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EAE0
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=4,scn=c004,cnm=64,pcn=12EADA,p
              st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=4,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EADC
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=4,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EAE0
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=5,scn=c005,cnm=64,pcn=12EADA,p
              st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=5,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EADC
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=5,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EAE0
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=6,scn=c006,cnm=64,pcn=12EADA,p
              st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=6,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EADC
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=6,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EAE0
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=7,scn=c007,cnm=64,pcn=12EADA,p
              st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=7,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EADC
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=7,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EAE0
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=8,scn=c008,cnm=64,pcn=12EADA,p
              st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=8,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EADC
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=8,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EAE0
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=9,scn=c009,cnm=64,pcn=12EADA,p
              st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=9,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EADC
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=9,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12EAE0
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=10,scn=c010,cnm=64,pcn=12EADA,
              pst=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=10,fdt=10,rgbd=0,cbdm=0,pcbd
              =0,pfd=12EADC
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=10,fdt=11,rgbd=0,cbdm=0,pcbd
              =0,pfd=12EAE0
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=11,scn=c011,cnm=64,pcn=12EADA,
              pst=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=11,fdt=10,rgbd=0,cbdm=0,pcbd
              =0,pfd=12EADC
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=11,fdt=11,rgbd=0,cbdm=0,pcbd
              =0,pfd=12EAE0
              (0) r: 147 0 SQLFreeStmt:- hst=14254F0, fop=1
              (0) e: 744 0 SQLAllocStmt:- hdbc=14247C0,pst=DF7A98
              (0) e: 760 0 SQLPrepare:- hst=14254F0, css=14646584
              (0) Ssss = SELECT "A1"."attachmentname" AS c001,

              "A1"."lastmodifid
              ate" AS c002, "A1"."lastmodifier" AS c003, "A1"."remark"

              AS c0
              04, "A1"."rereson" AS c005, "A1"."retype" AS c006,

              "A1"."recat
              e" AS c007, "A1"."enddate" AS c008, "A1"."startdate" AS

              c009,
              "A1"."empid" AS c010, "A1"."pkid" AS c011 FROM

              "T_FLY_FLYER_RE
              WARD" "A1" WHERE ("A1"."empid" = 10004036)
              (0) e: 765 0 SQLNumResultCols:- hst=14254F0,pcol=11
              (0) e: 782 0 SQLDescribeCol:-

              hst=14254F0,icol=1,scn=c001,cnm=128,pcn=DFE17A,
              pst=DFE17C,pcd=DFE180,psc=DFE184,pnul=DFE186
              (0) e: 782 0 SQLDescribeCol:-

              hst=14254F0,icol=2,scn=c002,cnm=128,pcn=DFE22A,
              pst=DFE22C,pcd=DFE230,psc=DFE234,pnul=DFE236
              (0) e: 782 0 SQLDescribeCol:-

              hst=14254F0,icol=3,scn=c003,cnm=128,pcn=DFE2DA,
              pst=DFE2DC,pcd=DFE2E0,psc=DFE2E4,pnul=DFE2E6
              (0) e: 782 0 SQLDescribeCol:-

              hst=14254F0,icol=4,scn=c004,cnm=128,pcn=DFE38A,
              pst=DFE38C,pcd=DFE390,psc=DFE394,pnul=DFE396
              (0) e: 782 0 SQLDescribeCol:-

              hst=14254F0,icol=5,scn=c005,cnm=128,pcn=DFE43A,
              pst=DFE43C,pcd=DFE440,psc=DFE444,pnul=DFE446
              (0) e: 782 0 SQLDescribeCol:-

              hst=14254F0,icol=6,scn=c006,cnm=128,pcn=DFE52A,
              pst=DFE52C,pcd=DFE530,psc=DFE534,pnul=DFE536
              (0) e: 782 0 SQLDescribeCol:-

              hst=14254F0,icol=7,scn=c007,cnm=128,pcn=DFE5DA,
              pst=DFE5DC,pcd=DFE5E0,psc=DFE5E4,pnul=DFE5E6
              (0) e: 782 0 SQLDescribeCol:-

              hst=14254F0,icol=8,scn=c008,cnm=128,pcn=DFE68A,
              pst=DFE68C,pcd=DFE690,psc=DFE694,pnul=DFE696
              (0) e: 782 0 SQLDescribeCol:-

              hst=14254F0,icol=9,scn=c009,cnm=128,pcn=DFE73A,
              pst=DFE73C,pcd=DFE740,psc=DFE744,pnul=DFE746
              (0) e: 782 0 SQLDescribeCol:-

              hst=14254F0,icol=10,scn=c010,cnm=128,pcn=DFE7EA
              ,pst=DFE7EC,pcd=DFE7F0,psc=DFE7F4,pnul=DFE7F6
              (0) e: 782 0 SQLDescribeCol:-

              hst=14254F0,icol=11,scn=c011,cnm=128,pcn=DFE8EA
              ,pst=DFE8EC,pcd=DFE8F0,psc=DFE8F4,pnul=DFE8F6
              (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=1,fct=-

              8,rgv=DFF114,cbvm=202,pcv=14
              674388
              (0) e: 502 0 SQLBindCol:-

              hst=14254F0,icl=2,fct=99,rgv=E04024,cbvm=16,pcv=146
              98084
              (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=3,fct=-

              8,rgv=E0504C,cbvm=42,pcv=146
              98484
              (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=4,fct=-

              8,rgv=E2B004,cbvm=1002,pcv=1
              4698884
              (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=5,fct=-

              8,rgv=E060DC,cbvm=402,pcv=14
              699284
              (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=6,fct=-

              8,rgv=E43794,cbvm=102,pcv=14
              699684
              (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=7,fct=-

              8,rgv=E0FE0C,cbvm=10,pcv=147
              46100
              (0) e: 502 0 SQLBindCol:-

              hst=14254F0,icl=8,fct=99,rgv=E10384,cbvm=16,pcv=147
              48100
              (0) e: 502 0 SQLBindCol:-

              hst=14254F0,icl=9,fct=99,rgv=E10E34,cbvm=16,pcv=147
              50836
              (0) e: 502 0 SQLBindCol:-

              hst=14254F0,icl=10,fct=99,rgv=E11604,cbvm=4,pcv=147
              51636
              (0) e: 502 0 SQLBindCol:-

              hst=14254F0,icl=11,fct=99,rgv=E11924,cbvm=4,pcv=147
              52436
              (0) e: 359 0 SQLSetStmtOption:- hst=14254F0, fop=0 , vprm=0
              (0) e: 365 0 SQLExecute:- hst=14254F0
              (0) e: 396 0 SQLSetStmtOption:- hst=14254F0, fop=9 , vprm=100
              (0) e: 400 0 SQLExtendedFetch:- hstm=14254F0, fft=1, irow=0,

              pcrw=DF7AC8, rgr
              s=DFE90C
              (0) hoautil.c (561): ; Requested chunk length: 65536
              (0) SELECT "attachment" FROM "T_FLY_FLYER_REWARD" WHERE "pkid"=3 AND
              (0) "empid"=10004036 AND "startdate"={ts '2012-12-28 00:00:00.000'} AND
              (0) "enddate"={ts '2012-12-28 00:00:00.000'} AND "recate"='0' AND

              "retype"='0' AND
              (0) "rereson"='5858' AND "remark"='' AND "lastmodifier"='7' AND
              (0) "lastmodifidate"={ts '2012-12-28 10:41:03.070'} AND
              (0) "attachmentname"='飞行准备网一期演示沟通会议.doc
              (0) '
              (0) UPDATE "T_FLY_FLYER_REWARD" SET "attachment" = ? WHERE "pkid"=3 AND
              (0) "empid"=10004036 AND "startdate"={ts '2012-12-28 00:00:00.000'} AND
              (0) "enddate"={ts '2012-12-28 00:00:00.000'} AND "recate"='0' AND

              "retype"='0' AND
              (0) "rereson"='5858' AND "remark"='' AND "lastmodifier"='7' AND
              (0) "lastmodifidate"={ts '2012-12-28 10:41:03.070'} AND
              (0) "attachmentname"='飞行准备网一期演示沟通会议.doc
              (0) '
              (0) i: 924 0 SQLAllocConnect:- henv=1424718,phd=12E834
              (0) i: 931 0 SQLSetConnectOption:- hdbc=1424C30, fop=1218 , vprm=1
              (0) i: 938 0 SQLSetConnectOption:- hdbc=1424C30, fop=103 , vprm=0
              (0) i: 945 1 SQLDriverConnect:- hdbc=1424C30, hwnd=0, scsi=12E8C4,

              ccsi=-3, s
              cso=12E9C4, ccsom=1020, pcso=12E83A, fdc=0,
              (0) i: 955 0 SQLGetInfo:- hdbc=1424C30, fit=18 ,rif=12e840, civm=130,

              piv=12E
              83C
              (0) i: 960 0 SQLSetConnectOption:- hdbc=1424C30, fop=1217 , vprm=1
              (0) Created new MSSQLODBC connection (21122096)
              (0) e:1881 0 SQLAllocStmt:- hdbc=1424C30,pst=E1C678
              (0) e:1890 0 SQLSetStmtOption:- hst=14270A0, fop=0 , vprm=0
              (0) e:1896 0 SQLExecDirect:- hst=14270A0, css=-3
              (0) 6sss = SELECT "attachment" FROM "T_FLY_FLYER_REWARD"

              WHERE "pk
              id"=3 AND "empid"=10004036 AND "startdate"={ts '2012-12

              -28 00:
                              00:00.000'} AND "enddate"={ts '2012-12-28 00:00:00.000'}

              AND "
              recate"='0' AND "retype"='0' AND "rereson"='5858' AND

              "remark"
              ='' AND "lastmodifier"='7' AND "lastmodifidate"={ts

              '2012-12-2
                              8 10:41:03.070'} AND "attachmentname"='飞行准备网一期演

              示沟通? 嵋?doc '
              (0) e:1905 0 SQLDescribeCol:- hst=14270A0,icol=1,scn=

              (null),cnm=0,pcn=0,pst=1
              2EDDC,pcd=0,psc=0,pnul=0
              (0) e:1914100 SQLFetch:- hst=14270A0
              (0) i: 591100 SQLError:-

              hnv=1424718,hdbc=21122096,hst=14270a0,sss=00000,pne=
              12EB20,cemm=1239988,pem=1FF
              (0) =14247sem =
              (0) DB_MSSQLODBC_ENGINE (1916): ; (SQL State: 00000; SQL Code: 16)
              (0) DRV_BlobRead: (SQL State: 00000; SQL Code: 16)
              (0)
              (0) nvRETURN (F:\Work\Connect_4_6_3\src\drv\DRV_BLOB.C 249): -1
              (0) hoaftch (21): ; hoaftch Exited with retcode = 28500, hoadabrc = 1.
              (0) hoaclse (22): ; hoaclse Entered. id = 1.
              (0) e: 442 0 SQLFreeStmt:- hst=14254F0, fop=1
              (0) hoaclse (22): ; hoaclse Exited with retcode = 0.
              (0) hoadafr (23): ; hoadafr Entered. id = 1.
              (0) hoadafr (23): ; hoadafr Exited with retcode = 0.
              (0) hoaroll (12): ; hoaroll Entered. tflag = 1.
              (0) e:1353 0 SQLTransact:- henv=0,hdbc=14247C0, ftp=1
              (0) e:1359 0 SQLSetConnectOption:- hdbc=14247C0, fop=102 , vprm=1
              (0) hoaroll (12): ; hoaroll Exited with retcode = 0.
              (0) hoabegn (9): ; hoabegn Entered. formatID = 306206, hoagttln = 55,

              hoagttid =
              (0) ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM.f04eafd4.17.20.497, hoagtbln =

              10,
              (0) hoagtbid = , tflag = 0, initial = 0
              (0) e:1005 0 SQLGetConnectOption:- hdbc=14247C0, fop=102 , pvprm=12EA80
              (0) e:1007 0 SQLSetConnectOption:- hdbc=14247C0, fop=108 , vprm=1
              (0) e:1012 0 SQLSetConnectOption:- hdbc=14247C0, fop=102 , vprm=0
              (0) hoabegn (9): ; hoabegn Exited with retcode = 0.
              (0) hoapars (15): ; hoapars Entered. stmtType = 0, id = 1.
              (0) nvOUT (F:\Work\Connect_4_6_3\src\qp\QP_SQTXT.C 55): SELECT

              A1."attachment"
              (0) FROM "T_FLY_FLYER_REWARD" A1 WHERE A1."empid"=10000535
              (0) SELECT "A1"."attachmentname" AS c001, "A1"."lastmodifidate" AS

              c002, "A1"."lastmodifier" AS c003, "A1"."remark" AS c004, "A1"."rereson"

              AS c005, "A1"."retype" AS c006, "A1"."recate" AS c007, "A1"."enddate" AS

              c008, "A1"."startdate" AS c009, "A1"."empid" AS c010, "A1"."pkid" AS

              c011 FROM "T_FLY_FLYER_REWARD" "A1" WHERE ("A1"."empid" = 10000535)
              (0)

              (0) r: 74 0 SQLAllocStmt:- hdbc=14247C0,pst=12E7C0
              (0) r: 113 0 SQLPrepare:- hst=14254F0, css=14606780
              (0) Ssss = SELECT "A1"."attachmentname" AS c001,

              "A1"."lastmodifid
              ate" AS c002, "A1"."lastmodifier" AS c003, "A1"."remark"

              AS c0
              04, "A1"."rereson" AS c005, "A1"."retype" AS c006,

              "A1"."recat
              e" AS c007, "A1"."enddate" AS c008, "A1"."startdate" AS

              c009,
              "A1"."empid" AS c010, "A1"."pkid" AS c011 FROM

              "T_FLY_FLYER_RE
              WARD" "A1" WHERE ("A1"."empid" = 10000535)
              (0) r: 863 0 SQLNumResultCols:- hst=14254F0,pcol=11
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=1,scn=c001,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=1,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=1,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=2,scn=c002,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=2,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=2,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=3,scn=c003,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=3,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=3,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=4,scn=c004,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=4,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=4,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=5,scn=c005,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=5,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=5,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=6,scn=c006,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=6,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=6,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=7,scn=c007,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=7,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=7,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=8,scn=c008,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=8,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=8,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=9,scn=c009,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=9,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=9,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=10,scn=c010,cnm=64,pcn=12E6DE,
              pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=10,fdt=10,rgbd=0,cbdm=0,pcbd
              =0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=10,fdt=11,rgbd=0,cbdm=0,pcbd
              =0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:-

              hst=14254F0,icol=11,scn=c011,cnm=64,pcn=12E6DE,
              pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:-

              hst=14254F0,icol=11,fdt=10,rgbd=0,cbdm=0,pcbd
              =0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:-

              hst=14254F0,icol=11,fdt=11,rgbd=0,cbdm=0,pcbd
              =0,pfd=12E6E4
              (0) r: 147 0 SQLFreeStmt:- hst=14254F0, fop=1
              (0) <<<<<<<<<<<<<<<<<<< Execution Strategy Begin

              <<<<<<<<<<<<<<<<<<<<<<<<<<<<
              (0) Original SQL:
              (0) SELECT A1 . "attachment" FROM "T_FLY_FLYER_REWARD" A1 WHERE A1 .

              "empid" = 10000535
              (0)
              • 4. Re: How to deal with image type from SQL*Server2005
                978005
                (0)
                (0) Accessing Database 'OKFOC' with SQL:
                (0) SELECT "A1"."attachmentname" AS c001, "A1"."lastmodifidate" AS

                c002, "A1"."lastmodifier" AS c003, "A1"."remark" AS c004, "A1"."rereson"

                AS c005, "A1"."retype" AS c006, "A1"."recate" AS c007, "A1"."enddate" AS

                c008, "A1"."startdate" AS c009, "A1"."empid" AS c010, "A1"."pkid" AS

                c011 FROM "T_FLY_FLYER_REWARD" "A1" WHERE ("A1"."empid" = 10000535)
                (0)

                (0)
                Execution Strategy End >>>>>>>>>>>>>>>>>>>>>>>>>>>>
                (0) hoapars (15): ; hoapars Exited with retcode = 0.
                (0) hoaopen (19): ; hoaopen Entered. id = 1.
                (0) hoaopen (19): ; hoaopen Exited with retcode = 0.
                (0) hoadscr (16): ; hoadscr Entered. id = 1.
                (0) hoastmt.c (304): ; Array fetch size is: 1.
                (0) HOAUTIL.C (1224): ; ------ hoadscr() -------:
                (0) HOAUTIL.C (1225): ; hoadamsz: 1, hoadasiz: 1, hoadambr: 1, hoadabrc:

                1
                (0) HOAUTIL.C (1228): ; row 0 - hoadambl: 2147483647, hoadadty: 166,

                hoadaprc:
                (0) 2147483647, hoadacst: 0
                (0) HOAUTIL.C (1232): ; row 0 - hoadascl: 0, hoadanul: 1, hoadanml: 13,

                hoadanam:
                (0) A1.attachment, hoadabfl: 2147483647, hoadamod: 0
                (0) hoadscr (16): ; hoadscr Exited with retcode = 0.
                (0) hoaftch (21): ; hoaftch Entered. id = 1.
                (0) apiutil.c (0): ; hoaftch()::
                (0) apiutil.c (0): ; Column 0 - pszName: A1.attachment, size: 1827, id:

                0, width:
                (0) 1827, scale: 0, flags: 68.
                (0) SELECT "A1"."attachmentname" AS c001, "A1"."lastmodifidate" AS

                c002, "A1"."lastmodifier" AS c003, "A1"."remark" AS c004, "A1"."rereson"

                AS c005, "A1"."retype" AS c006, "A1"."recate" AS c007, "A1"."enddate" AS

                c008, "A1"."startdate" AS c009, "A1"."empid" AS c010, "A1"."pkid" AS

                c011 FROM "T_FLY_FLYER_REWARD" "A1" WHERE ("A1"."empid" = 10000535)
                (0)

                (0) r: 74 0 SQLAllocStmt:- hdbc=14247C0,pst=12EBBC
                (0) r: 113 0 SQLPrepare:- hst=14254F0, css=14469492
                (0) Ssss = SELECT "A1"."attachmentname" AS c001,

                "A1"."lastmodifid
                ate" AS c002, "A1"."lastmodifier" AS c003, "A1"."remark"

                AS c0
                04, "A1"."rereson" AS c005, "A1"."retype" AS c006,

                "A1"."recat
                e" AS c007, "A1"."enddate" AS c008, "A1"."startdate" AS

                c009,
                "A1"."empid" AS c010, "A1"."pkid" AS c011 FROM

                "T_FLY_FLYER_RE
                WARD" "A1" WHERE ("A1"."empid" = 10000535)
                (0) r: 863 0 SQLNumResultCols:- hst=14254F0,pcol=11
                (0) r: 886 0 SQLDescribeCol:-

                hst=14254F0,icol=1,scn=c001,cnm=64,pcn=12EADA,p
                st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                (0) r: 903 0 SQLColAttributes:-

                hst=14254F0,icol=1,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EADC
                (0) r: 909 0 SQLColAttributes:-

                hst=14254F0,icol=1,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAE0
                (0) r: 886 0 SQLDescribeCol:-

                hst=14254F0,icol=2,scn=c002,cnm=64,pcn=12EADA,p
                st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                (0) r: 903 0 SQLColAttributes:-

                hst=14254F0,icol=2,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EADC
                (0) r: 909 0 SQLColAttributes:-

                hst=14254F0,icol=2,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAE0
                (0) r: 886 0 SQLDescribeCol:-

                hst=14254F0,icol=3,scn=c003,cnm=64,pcn=12EADA,p
                st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                (0) r: 903 0 SQLColAttributes:-

                hst=14254F0,icol=3,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EADC
                (0) r: 909 0 SQLColAttributes:-

                hst=14254F0,icol=3,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAE0
                (0) r: 886 0 SQLDescribeCol:-

                hst=14254F0,icol=4,scn=c004,cnm=64,pcn=12EADA,p
                st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                (0) r: 903 0 SQLColAttributes:-

                hst=14254F0,icol=4,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EADC
                (0) r: 909 0 SQLColAttributes:-

                hst=14254F0,icol=4,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAE0
                (0) r: 886 0 SQLDescribeCol:-

                hst=14254F0,icol=5,scn=c005,cnm=64,pcn=12EADA,p
                st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                (0) r: 903 0 SQLColAttributes:-

                hst=14254F0,icol=5,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EADC
                (0) r: 909 0 SQLColAttributes:-

                hst=14254F0,icol=5,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAE0
                (0) r: 886 0 SQLDescribeCol:-

                hst=14254F0,icol=6,scn=c006,cnm=64,pcn=12EADA,p
                st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                (0) r: 903 0 SQLColAttributes:-

                hst=14254F0,icol=6,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EADC
                (0) r: 909 0 SQLColAttributes:-

                hst=14254F0,icol=6,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAE0
                (0) r: 886 0 SQLDescribeCol:-

                hst=14254F0,icol=7,scn=c007,cnm=64,pcn=12EADA,p
                st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                (0) r: 903 0 SQLColAttributes:-

                hst=14254F0,icol=7,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EADC
                (0) r: 909 0 SQLColAttributes:-

                hst=14254F0,icol=7,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAE0
                (0) r: 886 0 SQLDescribeCol:-

                hst=14254F0,icol=8,scn=c008,cnm=64,pcn=12EADA,p
                st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                (0) r: 903 0 SQLColAttributes:-

                hst=14254F0,icol=8,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EADC
                (0) r: 909 0 SQLColAttributes:-

                hst=14254F0,icol=8,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAE0
                (0) r: 886 0 SQLDescribeCol:-

                hst=14254F0,icol=9,scn=c009,cnm=64,pcn=12EADA,p
                st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                (0) r: 903 0 SQLColAttributes:-

                hst=14254F0,icol=9,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EADC
                (0) r: 909 0 SQLColAttributes:-

                hst=14254F0,icol=9,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAE0
                (0) r: 886 0 SQLDescribeCol:-

                hst=14254F0,icol=10,scn=c010,cnm=64,pcn=12EADA,
                pst=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                (0) r: 903 0 SQLColAttributes:-

                hst=14254F0,icol=10,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12EADC
                (0) r: 909 0 SQLColAttributes:-

                hst=14254F0,icol=10,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12EAE0
                (0) r: 886 0 SQLDescribeCol:-

                hst=14254F0,icol=11,scn=c011,cnm=64,pcn=12EADA,
                pst=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                (0) r: 903 0 SQLColAttributes:-

                hst=14254F0,icol=11,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12EADC
                (0) r: 909 0 SQLColAttributes:-

                hst=14254F0,icol=11,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12EAE0
                (0) r: 147 0 SQLFreeStmt:- hst=14254F0, fop=1
                (0) e: 744 0 SQLAllocStmt:- hdbc=14247C0,pst=DCF178
                (0) e: 760 0 SQLPrepare:- hst=14254F0, css=14480408
                (0) Ssss = SELECT "A1"."attachmentname" AS c001,

                "A1"."lastmodifid
                ate" AS c002, "A1"."lastmodifier" AS c003, "A1"."remark"

                AS c0
                04, "A1"."rereson" AS c005, "A1"."retype" AS c006,

                "A1"."recat
                e" AS c007, "A1"."enddate" AS c008, "A1"."startdate" AS

                c009,
                "A1"."empid" AS c010, "A1"."pkid" AS c011 FROM

                "T_FLY_FLYER_RE
                WARD" "A1" WHERE ("A1"."empid" = 10000535)
                (0) e: 765 0 SQLNumResultCols:- hst=14254F0,pcol=11
                (0) e: 782 0 SQLDescribeCol:-

                hst=14254F0,icol=1,scn=c001,cnm=128,pcn=DD585A,
                pst=DD585C,pcd=DD5860,psc=DD5864,pnul=DD5866
                (0) e: 782 0 SQLDescribeCol:-

                hst=14254F0,icol=2,scn=c002,cnm=128,pcn=DD590A,
                pst=DD590C,pcd=DD5910,psc=DD5914,pnul=DD5916
                (0) e: 782 0 SQLDescribeCol:-

                hst=14254F0,icol=3,scn=c003,cnm=128,pcn=DD59BA,
                pst=DD59BC,pcd=DD59C0,psc=DD59C4,pnul=DD59C6
                (0) e: 782 0 SQLDescribeCol:-

                hst=14254F0,icol=4,scn=c004,cnm=128,pcn=DD5A6A,
                pst=DD5A6C,pcd=DD5A70,psc=DD5A74,pnul=DD5A76
                (0) e: 782 0 SQLDescribeCol:-

                hst=14254F0,icol=5,scn=c005,cnm=128,pcn=DD5B1A,
                pst=DD5B1C,pcd=DD5B20,psc=DD5B24,pnul=DD5B26
                (0) e: 782 0 SQLDescribeCol:-

                hst=14254F0,icol=6,scn=c006,cnm=128,pcn=DD5C0A,
                pst=DD5C0C,pcd=DD5C10,psc=DD5C14,pnul=DD5C16
                (0) e: 782 0 SQLDescribeCol:-

                hst=14254F0,icol=7,scn=c007,cnm=128,pcn=DD5CBA,
                pst=DD5CBC,pcd=DD5CC0,psc=DD5CC4,pnul=DD5CC6
                (0) e: 782 0 SQLDescribeCol:-

                hst=14254F0,icol=8,scn=c008,cnm=128,pcn=DD5D6A,
                pst=DD5D6C,pcd=DD5D70,psc=DD5D74,pnul=DD5D76
                (0) e: 782 0 SQLDescribeCol:-

                hst=14254F0,icol=9,scn=c009,cnm=128,pcn=DD5E1A,
                pst=DD5E1C,pcd=DD5E20,psc=DD5E24,pnul=DD5E26
                (0) e: 782 0 SQLDescribeCol:-

                hst=14254F0,icol=10,scn=c010,cnm=128,pcn=DD5ECA
                ,pst=DD5ECC,pcd=DD5ED0,psc=DD5ED4,pnul=DD5ED6
                (0) e: 782 0 SQLDescribeCol:-

                hst=14254F0,icol=11,scn=c011,cnm=128,pcn=DD5FCA
                ,pst=DD5FCC,pcd=DD5FD0,psc=DD5FD4,pnul=DD5FD6
                (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=1,fct=-

                8,rgv=DD67F4,cbvm=202,pcv=14
                508212
                (0) e: 502 0 SQLBindCol:-

                hst=14254F0,icl=2,fct=99,rgv=DDB704,cbvm=16,pcv=145
                31908
                (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=3,fct=-

                8,rgv=DDC72C,cbvm=42,pcv=145
                32308
                (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=4,fct=-

                8,rgv=DF0FD4,cbvm=1002,pcv=1
                4532708
                (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=5,fct=-

                8,rgv=DDD7BC,cbvm=402,pcv=14
                533108
                (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=6,fct=-

                8,rgv=DE74EC,cbvm=102,pcv=14
                533508
                (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=7,fct=-

                8,rgv=DE9CEC,cbvm=10,pcv=145
                90164
                (0) e: 502 0 SQLBindCol:-

                hst=14254F0,icl=8,fct=99,rgv=DEA264,cbvm=16,pcv=145
                92164
                (0) e: 502 0 SQLBindCol:-

                hst=14254F0,icl=9,fct=99,rgv=DEAD14,cbvm=16,pcv=145
                94900
                (0) e: 502 0 SQLBindCol:-

                hst=14254F0,icl=10,fct=99,rgv=DEB4E4,cbvm=4,pcv=145
                95700
                (0) e: 502 0 SQLBindCol:-

                hst=14254F0,icl=11,fct=99,rgv=DEB804,cbvm=4,pcv=145
                96500
                (0) e: 359 0 SQLSetStmtOption:- hst=14254F0, fop=0 , vprm=0
                (0) e: 365 0 SQLExecute:- hst=14254F0
                (0) e: 396 0 SQLSetStmtOption:- hst=14254F0, fop=9 , vprm=100
                (0) e: 400 0 SQLExtendedFetch:- hstm=14254F0, fft=1, irow=0,

                pcrw=DCF1A8, rgr
                s=DD5FEC
                (0) hoautil.c (561): ; Requested chunk length: 65536
                (0) SELECT "attachment" FROM "T_FLY_FLYER_REWARD" WHERE "pkid"=1 AND
                (0) "empid"=10000535 AND "startdate"={ts '2012-08-17 00:00:00.000'} AND
                (0) "enddate"={ts '2012-08-17 00:00:00.000'} AND "recate"='0' AND

                "retype"='1' AND
                (0) "rereson"='lll' AND "remark"='' AND "lastmodifier"='25' AND
                (0) "lastmodifidate"={ts '2012-08-17 15:29:18.340'} AND
                (0) "attachmentname"='(副驾驶cp签注)飞行员信息登记表.doc
                (0) '
                (0) UPDATE "T_FLY_FLYER_REWARD" SET "attachment" = ? WHERE "pkid"=1 AND
                (0) "empid"=10000535 AND "startdate"={ts '2012-08-17 00:00:00.000'} AND
                (0) "enddate"={ts '2012-08-17 00:00:00.000'} AND "recate"='0' AND

                "retype"='1' AND
                (0) "rereson"='lll' AND "remark"='' AND "lastmodifier"='25' AND
                (0) "lastmodifidate"={ts '2012-08-17 15:29:18.340'} AND
                (0) "attachmentname"='(副驾驶cp签注)飞行员信息登记表.doc
                (0) '
                (0) i: 924 0 SQLAllocConnect:- henv=1424718,phd=12E834
                (0) i: 931 0 SQLSetConnectOption:- hdbc=1426A30, fop=1218 , vprm=1
                (0) i: 938 0 SQLSetConnectOption:- hdbc=1426A30, fop=103 , vprm=0
                (0) i: 945 1 SQLDriverConnect:- hdbc=1426A30, hwnd=0, scsi=12E8C4,

                ccsi=-3, s
                cso=12E9C4, ccsom=1020, pcso=12E83A, fdc=0,
                (0) i: 955 0 SQLGetInfo:- hdbc=1426A30, fit=18 ,rif=12e840, civm=130,

                piv=12E
                83C
                (0) i: 960 0 SQLSetConnectOption:- hdbc=1426A30, fop=1217 , vprm=1
                (0) Created new MSSQLODBC connection (21129776)
                (0) e:1881 0 SQLAllocStmt:- hdbc=1426A30,pst=DF09E8
                (0) e:1890 0 SQLSetStmtOption:- hst=1427538, fop=0 , vprm=0
                (0) e:1896 0 SQLExecDirect:- hst=1427538, css=-3
                (0) 6sss = SELECT "attachment" FROM "T_FLY_FLYER_REWARD"

                WHERE "pk
                id"=1 AND "empid"=10000535 AND "startdate"={ts '2012-08

                -17 00:
                                00:00.000'} AND "enddate"={ts '2012-08-17 00:00:00.000'}

                AND "
                recate"='0' AND "retype"='1' AND "rereson"='lll' AND

                "remark"=
                '' AND "lastmodifier"='25' AND "lastmodifidate"={ts

                '2012-08-1
                                7 15:29:18.340'} AND "attachmentname"='(副驾驶cp签注)

                飞行员? 畔⒌羌潜?doc '
                (0) e:1905 0 SQLDescribeCol:- hst=1427538,icol=1,scn=

                (null),cnm=0,pcn=0,pst=1
                2EDDC,pcd=0,psc=0,pnul=0
                (0) e:1914 0 SQLFetch:- hst=1427538
                (0) e:1928 0 SQLGetData:- hst=1427538,icol=1,fct=-

                2,rgbv=E2B004,cvm=65536,psv
                =1240544
                (0) hoautil.c (578): ; Returned chunk length: 33280
                (0) hoautil.c (585): ; Piece-wise protocol requested
                (0) hoaftch (21): ; hoaftch Exited with retcode = 0, hoadabrc = 1.
                (0) hoadtab (26): ; hoadtab Entered. count = 1
                (0) hoadtab (26): ; schema_name = , table_name = T_FLY_FLYER_REWARD
                (0) nvOUT (F:\Work\Connect_4_6_3\src\qp\QP_SQTXT.C 55): select

                NON_UNIQUE,
                (0) INDEX_NAME, TYPE, SEQ_IN_INDEX, COLLATION, CARDINALITY, COLUMN_NAME

                from
                (0) NAV_PROC:SP_STATISTICS('OKFOC', '%', 'T_FLY_FLYER_REWARD', 1, 0, 0)

                order by
                (0) 3, 1, 2, 4
                (0) <<<<<<<<<<<<<<<<<<< Execution Strategy Begin

                <<<<<<<<<<<<<<<<<<<<<<<<<<<<
                (0) Original SQL:
                (0) select NON_UNIQUE , INDEX_NAME , TYPE , SEQ_IN_INDEX , COLLATION ,

                CARDINALITY , COLUMN_NAME from NAV_PROC : SP_STATISTICS ( 'OKFOC' , '%'

                , 'T_FLY_FLYER_REWARD' , 1 , 0 , 0 ) order by 3 , 1 , 2 , 4
                (0)


                (0)
                (0) Accessing saved query spec SP_STATISTICS()
                (0) from NAV_PROC DB
                (0)
                Execution Strategy End >>>>>>>>>>>>>>>>>>>>>>>>>>>>
                (0) <PROC> : -->>>> OPEN
                (0) <PROC> < OK>: OPEN SP_STATISTICS(1)
                (0) <PROC> : -->>>> SET_BUFFER
                (0) <PROC> < OK>: SET_BUFFER SP_STATISTICS(1)
                (0) <PROC> : -->>>> SET_PARAMS
                (0) <PROC> < OK>: SET_PARAMS SP_STATISTICS(1)
                (0) <PROC> : -->>>> FETCH
                (0) <PROC> < OK>: FETCH SP_STATISTICS(1)
                (0) <PROC> : -->>>> FETCH
                (0) <PROC> < EOS>: FETCH SP_STATISTICS(1)
                (0) <PROC> : -->>>> CLOSE
                (0) <PROC> < OK>: CLOSE SP_STATISTICS(1)
                (0) HOAUTIL.C (1259): ; ------ hoadtab (hoat) -------:
                (0) HOAUTIL.C (1262): ; hoatnam: T_FLY_FLYER_REWARD, hoatnml: 18,

                hoatnrw: 3,
                (0) hoatarl: 1881
                (0) HOAUTIL.C (1273): ; ------ hoadtab (hoai) -------:
                (0) HOAUTIL.C (1274): ; n_index_stat: 0
                (0) HOAUTIL.C (1224): ; -------- hoadtab for table T_FLY_FLYER_REWARD--

                -------:
                (0) HOAUTIL.C (1225): ; hoadamsz: 12, hoadasiz: 12, hoadambr: 1,

                hoadabrc: 0
                (0) HOAUTIL.C (1228): ; row 0 - hoadambl: 4, hoadadty: 8, hoadaprc: 10,

                hoadacst: 0
                (0) HOAUTIL.C (1232): ; row 0 - hoadascl: 0, hoadanul: 1, hoadanml: 4,

                hoadanam:
                (0) pkid, hoadabfl: 4, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 1 - hoadambl: 4, hoadadty: 8, hoadaprc: 10,

                hoadacst: 0
                (0) HOAUTIL.C (1232): ; row 1 - hoadascl: 0, hoadanul: 1, hoadanml: 5,

                hoadanam:
                (0) empid, hoadabfl: 4, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 2 - hoadambl: 7, hoadadty: 167, hoadaprc: 0,

                hoadacst:
                (0) 0
                (0) HOAUTIL.C (1232): ; row 2 - hoadascl: 0, hoadanul: 1, hoadanml: 9,

                hoadanam:
                (0) startdate, hoadabfl: 7, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 3 - hoadambl: 7, hoadadty: 167, hoadaprc: 0,

                hoadacst:
                (0) 0
                (0) HOAUTIL.C (1232): ; row 3 - hoadascl: 0, hoadanul: 1, hoadanml: 7,

                hoadanam:
                (0) enddate, hoadabfl: 7, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 4 - hoadambl: 8, hoadadty: 14, hoadaprc: 8,

                hoadacst:
                (0) 1000
                (0) HOAUTIL.C (1232): ; row 4 - hoadascl: 0, hoadanul: 1, hoadanml: 6,

                hoadanam:
                (0) recate, hoadabfl: 8, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 5 - hoadambl: 100, hoadadty: 14, hoadaprc:

                100,
                (0) hoadacst: 1000
                (0) HOAUTIL.C (1232): ; row 5 - hoadascl: 0, hoadanul: 1, hoadanml: 6,

                hoadanam:
                (0) retype, hoadabfl: 100, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 6 - hoadambl: 400, hoadadty: 14, hoadaprc:

                400,
                (0) hoadacst: 1000
                (0) HOAUTIL.C (1232): ; row 6 - hoadascl: 0, hoadanul: 1, hoadanml: 7,

                hoadanam:
                (0) rereson, hoadabfl: 400, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 7 - hoadambl: 1000, hoadadty: 14, hoadaprc:

                1000,
                (0) hoadacst: 1000
                (0) HOAUTIL.C (1232): ; row 7 - hoadascl: 0, hoadanul: 1, hoadanml: 6,

                hoadanam:
                (0) remark, hoadabfl: 1000, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 8 - hoadambl: 40, hoadadty: 14, hoadaprc:

                40,
                (0) hoadacst: 1000
                (0) HOAUTIL.C (1232): ; row 8 - hoadascl: 0, hoadanul: 1, hoadanml: 12,

                hoadanam:
                (0) lastmodifier, hoadabfl: 40, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 9 - hoadambl: 7, hoadadty: 167, hoadaprc: 0,

                hoadacst:
                (0) 0
                (0) HOAUTIL.C (1232): ; row 9 - hoadascl: 0, hoadanul: 1, hoadanml: 14,

                hoadanam:
                (0) lastmodifidate, hoadabfl: 7, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 10 - hoadambl: 2147483647, hoadadty: 166,

                hoadaprc:
                (0) 2147483647, hoadacst: 0
                (0) HOAUTIL.C (1232): ; row 10 - hoadascl: 0, hoadanul: 1, hoadanml: 10,

                hoadanam:
                (0) attachment, hoadabfl: 2147483647, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 11 - hoadambl: 200, hoadadty: 14, hoadaprc:

                200,
                (0) hoadacst: 1000
                (0) HOAUTIL.C (1232): ; row 11 - hoadascl: 0, hoadanul: 1, hoadanml: 14,

                hoadanam:
                (0) attachmentname, hoadabfl: 200, hoadamod: 0
                (0) hoadtab (26): ; hoadtab Exited with retcode = 0.
                (0) hoadafr (23): ; hoadafr Entered. id = 0.
                (0) hoadafr (23): ; hoadafr Exited with retcode = 0.
                (0) hoapars (15): ; hoapars Entered. stmtType = 0, id = 2.
                (0) nvOUT (F:\Work\Connect_4_6_3\src\qp\QP_SQTXT.C 55): SELECT
                (0)

                A1."pkid",A1."empid",A1."startdate",A1."enddate",A1."recate",A1."retype"

                ,A1."r-
                (0)

                ereson",A1."remark",A1."lastmodifier",A1."lastmodifidate",A1."attachment

                name",-
                (0) A1."attachment" FROM "T_FLY_FLYER_REWARD" A1
                (0) SELECT "A1"."pkid" AS c000, "A1"."empid" AS c001, "A1"."startdate"

                AS c002, "A1"."enddate" AS c003, "A1"."recate" AS c004, "A1"."retype" AS

                c005, "A1"."rereson" AS c006, "A1"."remark" AS c007, "A1"."lastmodifier"

                AS c008, "A1"."lastmodifidate" AS c009, "A1"."attachmentname" AS c010,

                "A1"."attachmentname" AS c012, "A1"."lastmodifidate" AS c013,

                "A1"."lastmodifier" AS c014, "A1"."remark" AS c015, "A1"."rereson" AS

                c016, "A1"."retype" AS c017, "A1"."recate" AS c018, "A1"."enddate" AS

                c019, "A1"."startdate" AS c020, "A1"."empid" AS c021, "A1"."pkid" AS

                c022 FROM "T_FLY_FLYER_REWARD" "A1"
                (0)

                (0) i: 924 0 SQLAllocConnect:- henv=1424718,phd=12E218
                (0) i: 931 0 SQLSetConnectOption:- hdbc=1426D30, fop=1218 , vprm=1
                (0) i: 938 0 SQLSetConnectOption:- hdbc=1426D30, fop=103 , vprm=0
                (0) i: 945 1 SQLDriverConnect:- hdbc=1426D30, hwnd=0, scsi=12E2A8,

                ccsi=-3, s
                cso=12E3A8, ccsom=1020, pcso=12E21E, fdc=0,
                (0) i: 955 0 SQLGetInfo:- hdbc=1426D30, fit=18 ,rif=12e224, civm=130,

                piv=12E
                220
                (0) i: 960 0 SQLSetConnectOption:- hdbc=1426D30, fop=1217 , vprm=1
                (0) Created new MSSQLODBC connection (21130544)
                (0) r: 74 0 SQLAllocStmt:- hdbc=1426D30,pst=12E7C0
                (0) r: 113 0 SQLPrepare:- hst=1427A10, css=31506132
                (0) Ssss = SELECT "A1"."pkid" AS c000, "A1"."empid" AS c001,

                "A1".
                "startdate" AS c002, "A1"."enddate" AS c003,

                "A1"."recate" AS
                c004, "A1"."retype" AS c005, "A1"."rereson" AS c006,

                "A1"."rem
                ark" AS c007, "A1"."lastmodifier" AS c008,

                "A1"."lastmodifidat
                e" AS c009, "A1"."attachmentname" AS c010,

                "A1"."attachmentnam
                e" AS c012, "A1"."lastmodifidate" AS c013,

                "A1"."lastmodifier"
                AS c014, "A1"."remark" AS c015, "A1"."rereson" AS c016,

                "A1".
                "retype" AS c017, "A1"."recate
                (0) r: 863 0 SQLNumResultCols:- hst=1427A10,pcol=22
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=1,scn=c000,cnm=64,pcn=12E6DE,p
                st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=1,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=1,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=2,scn=c001,cnm=64,pcn=12E6DE,p
                st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=2,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=2,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=3,scn=c002,cnm=64,pcn=12E6DE,p
                st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=3,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=3,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=4,scn=c003,cnm=64,pcn=12E6DE,p
                st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=4,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=4,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=5,scn=c004,cnm=64,pcn=12E6DE,p
                st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=5,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=5,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=6,scn=c005,cnm=64,pcn=12E6DE,p
                st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=6,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=6,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=7,scn=c006,cnm=64,pcn=12E6DE,p
                st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=7,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=7,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=8,scn=c007,cnm=64,pcn=12E6DE,p
                st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=8,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=8,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=9,scn=c008,cnm=64,pcn=12E6DE,p
                st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=9,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=9,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=10,scn=c009,cnm=64,pcn=12E6DE,
                pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=10,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=10,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=11,scn=c010,cnm=64,pcn=12E6DE,
                pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=11,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=11,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=12,scn=c012,cnm=64,pcn=12E6DE,
                pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=12,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=12,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=13,scn=c013,cnm=64,pcn=12E6DE,
                pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=13,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=13,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=14,scn=c014,cnm=64,pcn=12E6DE,
                pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=14,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=14,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=15,scn=c015,cnm=64,pcn=12E6DE,
                pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=15,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=15,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=16,scn=c016,cnm=64,pcn=12E6DE,
                pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=16,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=16,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=17,scn=c017,cnm=64,pcn=12E6DE,
                pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=17,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=17,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=18,scn=c018,cnm=64,pcn=12E6DE,
                pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=18,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=18,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=19,scn=c019,cnm=64,pcn=12E6DE,
                pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=19,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=19,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=20,scn=c020,cnm=64,pcn=12E6DE,
                pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=20,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=20,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=21,scn=c021,cnm=64,pcn=12E6DE,
                pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=21,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=21,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E4
                (0) r: 886 0 SQLDescribeCol:-

                hst=1427A10,icol=22,scn=c022,cnm=64,pcn=12E6DE,
                pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                (0) r: 903 0 SQLColAttributes:-

                hst=1427A10,icol=22,fdt=10,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E0
                (0) r: 909 0 SQLColAttributes:-

                hst=1427A10,icol=22,fdt=11,rgbd=0,cbdm=0,pcbd
                =0,pfd=12E6E4
                (0) r: 147 0 SQLFreeStmt:- hst=1427A10, fop=1
                (0) r: 149 0 SQLDisconnect:- hdbc=1426D30
                (0) r: 150 0 SQLFreeConnect:- hdbc=1426D30
                (0) <<<<<<<<<<<<<<<<<<< Execution Strategy Begin

                <<<<<<<<<<<<<<<<<<<<<<<<<<<<
                (0) Original SQL:
                (0) SELECT A1 . "pkid" , A1 . "empid" , A1 . "startdate" , A1 .

                "enddate" , A1 . "recate" , A1 . "retype" , A1 . "rereson" , A1 .

                "remark" , A1 . "lastmodifier" , A1 . "lastmodifidate" , A1 .

                "attachmentname" , A1 . "attachment" FROM "T_FLY_FLYER_REWARD" A1
                (0)
                • 5. Re: How to deal with image type from SQL*Server2005
                  978005
                  (0)
                  (0) Accessing Database 'OKFOC' with SQL:
                  (0) SELECT "A1"."pkid" AS c000, "A1"."empid" AS c001, "A1"."startdate"

                  AS c002, "A1"."enddate" AS c003, "A1"."recate" AS c004, "A1"."retype" AS

                  c005, "A1"."rereson" AS c006, "A1"."remark" AS c007, "A1"."lastmodifier"

                  AS c008, "A1"."lastmodifidate" AS c009, "A1"."attachmentname" AS c010,

                  "A1"."attachmentname" AS c012, "A1"."lastmodifidate" AS c013,

                  "A1"."lastmodifier" AS c014, "A1"."remark" AS c015, "A1"."rereson" AS

                  c016, "A1"."retype" AS c017, "A1"."recate" AS c018, "A1"."enddate" AS

                  c019, "A1"."startdate" AS c020, "A1"."empid" AS c021, "A1"."pkid" AS

                  c022 FROM "T_FLY_FLYER_REWARD" "A1"
                  (0)

                  (0)
                  Execution Strategy End >>>>>>>>>>>>>>>>>>>>>>>>>>>>
                  (0) hoapars (15): ; hoapars Exited with retcode = 0.
                  (0) hoaopen (19): ; hoaopen Entered. id = 2.
                  (0) hoaopen (19): ; hoaopen Exited with retcode = 0.
                  (0) hoadscr (16): ; hoadscr Entered. id = 2.
                  (0) hoastmt.c (304): ; Array fetch size is: 1.
                  (0) HOAUTIL.C (1224): ; ------ hoadscr() -------:
                  (0) HOAUTIL.C (1225): ; hoadamsz: 12, hoadasiz: 12, hoadambr: 1,

                  hoadabrc: 1
                  (0) HOAUTIL.C (1228): ; row 0 - hoadambl: 4, hoadadty: 8, hoadaprc: 10,

                  hoadacst: 0
                  (0) HOAUTIL.C (1232): ; row 0 - hoadascl: 0, hoadanul: 1, hoadanml: 7,

                  hoadanam:
                  (0) A1.pkid, hoadabfl: 4, hoadamod: 0
                  (0) HOAUTIL.C (1228): ; row 1 - hoadambl: 4, hoadadty: 8, hoadaprc: 10,

                  hoadacst: 0
                  (0) HOAUTIL.C (1232): ; row 1 - hoadascl: 0, hoadanul: 1, hoadanml: 8,

                  hoadanam:
                  (0) A1.empid, hoadabfl: 4, hoadamod: 0
                  (0) HOAUTIL.C (1228): ; row 2 - hoadambl: 7, hoadadty: 167, hoadaprc: 0,

                  hoadacst:
                  (0) 0
                  (0) HOAUTIL.C (1232): ; row 2 - hoadascl: 0, hoadanul: 1, hoadanml: 12,

                  hoadanam:
                  (0) A1.startdate, hoadabfl: 7, hoadamod: 0
                  (0) HOAUTIL.C (1228): ; row 3 - hoadambl: 7, hoadadty: 167, hoadaprc: 0,

                  hoadacst:
                  (0) 0
                  (0) HOAUTIL.C (1232): ; row 3 - hoadascl: 0, hoadanul: 1, hoadanml: 10,

                  hoadanam:
                  (0) A1.enddate, hoadabfl: 7, hoadamod: 0
                  (0) HOAUTIL.C (1228): ; row 4 - hoadambl: 8, hoadadty: 14, hoadaprc: 8,

                  hoadacst:
                  (0) 1000
                  (0) HOAUTIL.C (1232): ; row 4 - hoadascl: 0, hoadanul: 1, hoadanml: 9,

                  hoadanam:
                  (0) A1.recate, hoadabfl: 8, hoadamod: 0
                  (0) HOAUTIL.C (1228): ; row 5 - hoadambl: 100, hoadadty: 14, hoadaprc:

                  100,
                  (0) hoadacst: 1000
                  (0) HOAUTIL.C (1232): ; row 5 - hoadascl: 0, hoadanul: 1, hoadanml: 9,

                  hoadanam:
                  (0) A1.retype, hoadabfl: 100, hoadamod: 0
                  (0) HOAUTIL.C (1228): ; row 6 - hoadambl: 400, hoadadty: 14, hoadaprc:

                  400,
                  (0) hoadacst: 1000
                  (0) HOAUTIL.C (1232): ; row 6 - hoadascl: 0, hoadanul: 1, hoadanml: 10,

                  hoadanam:
                  (0) A1.rereson, hoadabfl: 400, hoadamod: 0
                  (0) HOAUTIL.C (1228): ; row 7 - hoadambl: 1000, hoadadty: 14, hoadaprc:

                  1000,
                  (0) hoadacst: 1000
                  (0) HOAUTIL.C (1232): ; row 7 - hoadascl: 0, hoadanul: 1, hoadanml: 9,

                  hoadanam:
                  (0) A1.remark, hoadabfl: 1000, hoadamod: 0
                  (0) HOAUTIL.C (1228): ; row 8 - hoadambl: 40, hoadadty: 14, hoadaprc:

                  40,
                  (0) hoadacst: 1000
                  (0) HOAUTIL.C (1232): ; row 8 - hoadascl: 0, hoadanul: 1, hoadanml: 15,

                  hoadanam:
                  (0) A1.lastmodifier, hoadabfl: 40, hoadamod: 0
                  (0) HOAUTIL.C (1228): ; row 9 - hoadambl: 7, hoadadty: 167, hoadaprc: 0,

                  hoadacst:
                  (0) 0
                  (0) HOAUTIL.C (1232): ; row 9 - hoadascl: 0, hoadanul: 1, hoadanml: 17,

                  hoadanam:
                  (0) A1.lastmodifidate, hoadabfl: 7, hoadamod: 0
                  (0) HOAUTIL.C (1228): ; row 10 - hoadambl: 200, hoadadty: 14, hoadaprc:

                  200,
                  (0) hoadacst: 1000
                  (0) HOAUTIL.C (1232): ; row 10 - hoadascl: 0, hoadanul: 1, hoadanml: 17,

                  hoadanam:
                  (0) A1.attachmentname, hoadabfl: 200, hoadamod: 0
                  (0) HOAUTIL.C (1228): ; row 11 - hoadambl: 2147483647, hoadadty: 166,

                  hoadaprc:
                  (0) 2147483647, hoadacst: 0
                  (0) HOAUTIL.C (1232): ; row 11 - hoadascl: 0, hoadanul: 1, hoadanml: 13,

                  hoadanam:
                  (0) A1.attachment, hoadabfl: 2147483647, hoadamod: 0
                  (0) hoadscr (16): ; hoadscr Exited with retcode = 0.
                  (0) hoaftch (21): ; hoaftch Entered. id = 1.
                  (0) e: 396 0 SQLSetStmtOption:- hst=14254F0, fop=9 , vprm=100
                  (0) e: 400100 SQLExtendedFetch:- hstm=14254F0, fft=1, irow=0,

                  pcrw=DCF1A8, rg
                  rs=DD5FEC
                  (0) hoaftch (21): ; hoaftch Exited with retcode = 1403, hoadabrc = 0.
                  (0) hoaclse (22): ; hoaclse Entered. id = 2.
                  (0) hoaclse (22): ; hoaclse Exited with retcode = 0.
                  (0) hoadafr (23): ; hoadafr Entered. id = 2.
                  (0) hoadafr (23): ; hoadafr Exited with retcode = 0.
                  (0) hoaclse (22): ; hoaclse Entered. id = 1.
                  (0) e: 442 0 SQLFreeStmt:- hst=14254F0, fop=1
                  (0) hoaclse (22): ; hoaclse Exited with retcode = 0.
                  (0) hoadafr (23): ; hoadafr Entered. id = 1.
                  (0) hoadafr (23): ; hoadafr Exited with retcode = 0.
                  (0) hoaroll (12): ; hoaroll Entered. tflag = 1.
                  (0) e:1353 0 SQLTransact:- henv=0,hdbc=14247C0, ftp=1
                  (0) e:1359 0 SQLSetConnectOption:- hdbc=14247C0, fop=102 , vprm=1
                  (0) hoaroll (12): ; hoaroll Exited with retcode = 0.
                  (0) hoabegn (9): ; hoabegn Entered. formatID = 306206, hoagttln = 54,

                  hoagttid =
                  (0) ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM.f04eafd4.15.7.518, hoagtbln =

                  10,
                  (0) hoagtbid = , tflag = 0, initial = 0
                  (0) e:1005 0 SQLGetConnectOption:- hdbc=14247C0, fop=102 , pvprm=12EA80
                  (0) e:1007 0 SQLSetConnectOption:- hdbc=14247C0, fop=108 , vprm=1
                  (0) e:1012 0 SQLSetConnectOption:- hdbc=14247C0, fop=102 , vprm=0
                  (0) hoabegn (9): ; hoabegn Exited with retcode = 0.
                  (0) hoapars (15): ; hoapars Entered. stmtType = 0, id = 1.
                  (0) nvOUT (F:\Work\Connect_4_6_3\src\qp\QP_SQTXT.C 55): SELECT

                  A1."attachment"
                  (0) FROM "T_FLY_FLYER_REWARD" A1 WHERE A1."empid"=10004036
                  (0) SELECT "A1"."attachmentname" AS c001, "A1"."lastmodifidate" AS

                  c002, "A1"."lastmodifier" AS c003, "A1"."remark" AS c004, "A1"."rereson"

                  AS c005, "A1"."retype" AS c006, "A1"."recate" AS c007, "A1"."enddate" AS

                  c008, "A1"."startdate" AS c009, "A1"."empid" AS c010, "A1"."pkid" AS

                  c011 FROM "T_FLY_FLYER_REWARD" "A1" WHERE ("A1"."empid" = 10004036)
                  (0)

                  (0) r: 74 0 SQLAllocStmt:- hdbc=14247C0,pst=12E7C0
                  (0) r: 113 0 SQLPrepare:- hst=1427A10, css=14798420
                  (0) Ssss = SELECT "A1"."attachmentname" AS c001,

                  "A1"."lastmodifid
                  ate" AS c002, "A1"."lastmodifier" AS c003, "A1"."remark"

                  AS c0
                  04, "A1"."rereson" AS c005, "A1"."retype" AS c006,

                  "A1"."recat
                  e" AS c007, "A1"."enddate" AS c008, "A1"."startdate" AS

                  c009,
                  "A1"."empid" AS c010, "A1"."pkid" AS c011 FROM

                  "T_FLY_FLYER_RE
                  WARD" "A1" WHERE ("A1"."empid" = 10004036)
                  (0) r: 863 0 SQLNumResultCols:- hst=1427A10,pcol=11
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=1,scn=c001,cnm=64,pcn=12E6DE,p
                  st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=1,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E0
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=1,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E4
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=2,scn=c002,cnm=64,pcn=12E6DE,p
                  st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=2,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E0
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=2,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E4
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=3,scn=c003,cnm=64,pcn=12E6DE,p
                  st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=3,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E0
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=3,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E4
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=4,scn=c004,cnm=64,pcn=12E6DE,p
                  st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=4,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E0
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=4,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E4
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=5,scn=c005,cnm=64,pcn=12E6DE,p
                  st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=5,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E0
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=5,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E4
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=6,scn=c006,cnm=64,pcn=12E6DE,p
                  st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=6,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E0
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=6,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E4
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=7,scn=c007,cnm=64,pcn=12E6DE,p
                  st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=7,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E0
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=7,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E4
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=8,scn=c008,cnm=64,pcn=12E6DE,p
                  st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=8,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E0
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=8,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E4
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=9,scn=c009,cnm=64,pcn=12E6DE,p
                  st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=9,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E0
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=9,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12E6E4
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=10,scn=c010,cnm=64,pcn=12E6DE,
                  pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=10,fdt=10,rgbd=0,cbdm=0,pcbd
                  =0,pfd=12E6E0
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=10,fdt=11,rgbd=0,cbdm=0,pcbd
                  =0,pfd=12E6E4
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=11,scn=c011,cnm=64,pcn=12E6DE,
                  pst=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=11,fdt=10,rgbd=0,cbdm=0,pcbd
                  =0,pfd=12E6E0
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=11,fdt=11,rgbd=0,cbdm=0,pcbd
                  =0,pfd=12E6E4
                  (0) r: 147 0 SQLFreeStmt:- hst=1427A10, fop=1
                  (0) <<<<<<<<<<<<<<<<<<< Execution Strategy Begin

                  <<<<<<<<<<<<<<<<<<<<<<<<<<<<
                  (0) Original SQL:
                  (0) SELECT A1 . "attachment" FROM "T_FLY_FLYER_REWARD" A1 WHERE A1 .

                  "empid" = 10004036
                  (0)


                  (0)
                  (0) Accessing Database 'OKFOC' with SQL:
                  (0) SELECT "A1"."attachmentname" AS c001, "A1"."lastmodifidate" AS

                  c002, "A1"."lastmodifier" AS c003, "A1"."remark" AS c004, "A1"."rereson"

                  AS c005, "A1"."retype" AS c006, "A1"."recate" AS c007, "A1"."enddate" AS

                  c008, "A1"."startdate" AS c009, "A1"."empid" AS c010, "A1"."pkid" AS

                  c011 FROM "T_FLY_FLYER_REWARD" "A1" WHERE ("A1"."empid" = 10004036)
                  (0)

                  (0)
                  Execution Strategy End >>>>>>>>>>>>>>>>>>>>>>>>>>>>
                  (0) hoapars (15): ; hoapars Exited with retcode = 0.
                  (0) hoaopen (19): ; hoaopen Entered. id = 1.
                  (0) hoaopen (19): ; hoaopen Exited with retcode = 0.
                  (0) hoadscr (16): ; hoadscr Entered. id = 1.
                  (0) hoastmt.c (304): ; Array fetch size is: 1.
                  (0) HOAUTIL.C (1224): ; ------ hoadscr() -------:
                  (0) HOAUTIL.C (1225): ; hoadamsz: 1, hoadasiz: 1, hoadambr: 1, hoadabrc:

                  1
                  (0) HOAUTIL.C (1228): ; row 0 - hoadambl: 2147483647, hoadadty: 166,

                  hoadaprc:
                  (0) 2147483647, hoadacst: 0
                  (0) HOAUTIL.C (1232): ; row 0 - hoadascl: 0, hoadanul: 1, hoadanml: 13,

                  hoadanam:
                  (0) A1.attachment, hoadabfl: 2147483647, hoadamod: 0
                  (0) hoadscr (16): ; hoadscr Exited with retcode = 0.
                  (0) hoaftch (21): ; hoaftch Entered. id = 1.
                  (0) apiutil.c (0): ; hoaftch()::
                  (0) apiutil.c (0): ; Column 0 - pszName: A1.attachment, size: 1827, id:

                  0, width:
                  (0) 1827, scale: 0, flags: 68.
                  (0) SELECT "A1"."attachmentname" AS c001, "A1"."lastmodifidate" AS

                  c002, "A1"."lastmodifier" AS c003, "A1"."remark" AS c004, "A1"."rereson"

                  AS c005, "A1"."retype" AS c006, "A1"."recate" AS c007, "A1"."enddate" AS

                  c008, "A1"."startdate" AS c009, "A1"."empid" AS c010, "A1"."pkid" AS

                  c011 FROM "T_FLY_FLYER_REWARD" "A1" WHERE ("A1"."empid" = 10004036)
                  (0)

                  (0) r: 74 0 SQLAllocStmt:- hdbc=14247C0,pst=12EBBC
                  (0) r: 113 0 SQLPrepare:- hst=1427A10, css=14806628
                  (0) Ssss = SELECT "A1"."attachmentname" AS c001,

                  "A1"."lastmodifid
                  ate" AS c002, "A1"."lastmodifier" AS c003, "A1"."remark"

                  AS c0
                  04, "A1"."rereson" AS c005, "A1"."retype" AS c006,

                  "A1"."recat
                  e" AS c007, "A1"."enddate" AS c008, "A1"."startdate" AS

                  c009,
                  "A1"."empid" AS c010, "A1"."pkid" AS c011 FROM

                  "T_FLY_FLYER_RE
                  WARD" "A1" WHERE ("A1"."empid" = 10004036)
                  (0) r: 863 0 SQLNumResultCols:- hst=1427A10,pcol=11
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=1,scn=c001,cnm=64,pcn=12EADA,p
                  st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=1,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EADC
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=1,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EAE0
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=2,scn=c002,cnm=64,pcn=12EADA,p
                  st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=2,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EADC
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=2,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EAE0
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=3,scn=c003,cnm=64,pcn=12EADA,p
                  st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=3,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EADC
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=3,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EAE0
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=4,scn=c004,cnm=64,pcn=12EADA,p
                  st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=4,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EADC
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=4,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EAE0
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=5,scn=c005,cnm=64,pcn=12EADA,p
                  st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=5,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EADC
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=5,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EAE0
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=6,scn=c006,cnm=64,pcn=12EADA,p
                  st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=6,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EADC
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=6,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EAE0
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=7,scn=c007,cnm=64,pcn=12EADA,p
                  st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=7,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EADC
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=7,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EAE0
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=8,scn=c008,cnm=64,pcn=12EADA,p
                  st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=8,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EADC
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=8,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EAE0
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=9,scn=c009,cnm=64,pcn=12EADA,p
                  st=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=9,fdt=10,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EADC
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=9,fdt=11,rgbd=0,cbdm=0,pcbd=
                  0,pfd=12EAE0
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=10,scn=c010,cnm=64,pcn=12EADA,
                  pst=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=10,fdt=10,rgbd=0,cbdm=0,pcbd
                  =0,pfd=12EADC
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=10,fdt=11,rgbd=0,cbdm=0,pcbd
                  =0,pfd=12EAE0
                  (0) r: 886 0 SQLDescribeCol:-

                  hst=1427A10,icol=11,scn=c011,cnm=64,pcn=12EADA,
                  pst=12EAF0,pcd=12EAE8,psc=12EAEC,pnul=12EAE4
                  (0) r: 903 0 SQLColAttributes:-

                  hst=1427A10,icol=11,fdt=10,rgbd=0,cbdm=0,pcbd
                  =0,pfd=12EADC
                  (0) r: 909 0 SQLColAttributes:-

                  hst=1427A10,icol=11,fdt=11,rgbd=0,cbdm=0,pcbd
                  =0,pfd=12EAE0
                  (0) r: 147 0 SQLFreeStmt:- hst=1427A10, fop=1
                  (0) e: 744 0 SQLAllocStmt:- hdbc=14247C0,pst=DEF978
                  (0) e: 760 0 SQLPrepare:- hst=1427A10, css=14613528
                  (0) Ssss = SELECT "A1"."attachmentname" AS c001,

                  "A1"."lastmodifid
                  ate" AS c002, "A1"."lastmodifier" AS c003, "A1"."remark"

                  AS c0
                  04, "A1"."rereson" AS c005, "A1"."retype" AS c006,

                  "A1"."recat
                  e" AS c007, "A1"."enddate" AS c008, "A1"."startdate" AS

                  c009,
                  "A1"."empid" AS c010, "A1"."pkid" AS c011 FROM

                  "T_FLY_FLYER_RE
                  WARD" "A1" WHERE ("A1"."empid" = 10004036)
                  (0) e: 765 0 SQLNumResultCols:- hst=1427A10,pcol=11
                  (0) e: 782 0 SQLDescribeCol:-

                  hst=1427A10,icol=1,scn=c001,cnm=128,pcn=DF7122,
                  pst=DF7124,pcd=DF7128,psc=DF712C,pnul=DF712E
                  (0) e: 782 0 SQLDescribeCol:-

                  hst=1427A10,icol=2,scn=c002,cnm=128,pcn=DF71D2,
                  pst=DF71D4,pcd=DF71D8,psc=DF71DC,pnul=DF71DE
                  (0) e: 782 0 SQLDescribeCol:-

                  hst=1427A10,icol=3,scn=c003,cnm=128,pcn=DF7282,
                  pst=DF7284,pcd=DF7288,psc=DF728C,pnul=DF728E
                  (0) e: 782 0 SQLDescribeCol:-

                  hst=1427A10,icol=4,scn=c004,cnm=128,pcn=DF7332,
                  pst=DF7334,pcd=DF7338,psc=DF733C,pnul=DF733E
                  (0) e: 782 0 SQLDescribeCol:-

                  hst=1427A10,icol=5,scn=c005,cnm=128,pcn=DF73E2,
                  pst=DF73E4,pcd=DF73E8,psc=DF73EC,pnul=DF73EE
                  (0) e: 782 0 SQLDescribeCol:-

                  hst=1427A10,icol=6,scn=c006,cnm=128,pcn=DF74D2,
                  pst=DF74D4,pcd=DF74D8,psc=DF74DC,pnul=DF74DE
                  (0) e: 782 0 SQLDescribeCol:-

                  hst=1427A10,icol=7,scn=c007,cnm=128,pcn=DF7582,
                  pst=DF7584,pcd=DF7588,psc=DF758C,pnul=DF758E
                  (0) e: 782 0 SQLDescribeCol:-

                  hst=1427A10,icol=8,scn=c008,cnm=128,pcn=DF7632,
                  pst=DF7634,pcd=DF7638,psc=DF763C,pnul=DF763E
                  (0) e: 782 0 SQLDescribeCol:-

                  hst=1427A10,icol=9,scn=c009,cnm=128,pcn=DF76E2,
                  pst=DF76E4,pcd=DF76E8,psc=DF76EC,pnul=DF76EE
                  (0) e: 782 0 SQLDescribeCol:-

                  hst=1427A10,icol=10,scn=c010,cnm=128,pcn=DF7792
                  ,pst=DF7794,pcd=DF7798,psc=DF779C,pnul=DF779E
                  (0) e: 782 0 SQLDescribeCol:-

                  hst=1427A10,icol=11,scn=c011,cnm=128,pcn=DF7892
                  ,pst=DF7894,pcd=DF7898,psc=DF789C,pnul=DF789E
                  (0) e: 502 0 SQLBindCol:- hst=1427A10,icl=1,fct=-

                  8,rgv=1E3600C,cbvm=202,pcv=1
                  4645628
                  (0) e: 502 0 SQLBindCol:-

                  hst=1427A10,icl=2,fct=99,rgv=1E3AF1C,cbvm=16,pcv=31
                  700316
                  (0) e: 502 0 SQLBindCol:- hst=1427A10,icl=3,fct=-

                  8,rgv=1E3BF44,cbvm=42,pcv=31
                  700716
                  (0) e: 502 0 SQLBindCol:- hst=1427A10,icl=4,fct=-

                  8,rgv=DF80BC,cbvm=1002,pcv=3
                  1701116
                  (0) e: 502 0 SQLBindCol:- hst=1427A10,icl=5,fct=-

                  8,rgv=E2B004,cbvm=402,pcv=31
                  701516
                  (0) e: 502 0 SQLBindCol:- hst=1427A10,icl=6,fct=-

                  8,rgv=E1084C,cbvm=102,pcv=31
                  701916
                  (0) e: 502 0 SQLBindCol:- hst=1427A10,icl=7,fct=-

                  8,rgv=1E3CFD4,cbvm=10,pcv=31
                  708092
                  (0) e: 502 0 SQLBindCol:-

                  hst=1427A10,icl=8,fct=99,rgv=1E3D54C,cbvm=16,pcv=31
                  710092
                  (0) e: 502 0 SQLBindCol:-

                  hst=1427A10,icl=9,fct=99,rgv=E1304C,cbvm=16,pcv=147
                  59564
                  (0) e: 502 0 SQLBindCol:-

                  hst=1427A10,icl=10,fct=99,rgv=E1381C,cbvm=4,pcv=147
                  60364
                  (0) e: 502 0 SQLBindCol:-

                  hst=1427A10,icl=11,fct=99,rgv=E13B3C,cbvm=4,pcv=147
                  61164
                  (0) e: 359 0 SQLSetStmtOption:- hst=1427A10, fop=0 , vprm=0
                  (0) e: 365 0 SQLExecute:- hst=1427A10
                  (0) e: 396 0 SQLSetStmtOption:- hst=1427A10, fop=9 , vprm=100
                  (0) e: 400 0 SQLExtendedFetch:- hstm=1427A10, fft=1, irow=0,

                  pcrw=DEF9A8, rgr
                  s=DF78B4
                  (0) hoautil.c (561): ; Requested chunk length: 65536
                  (0) SELECT "attachment" FROM "T_FLY_FLYER_REWARD" WHERE "pkid"=3 AND
                  (0) "empid"=10004036 AND "startdate"={ts '2012-12-28 00:00:00.000'} AND
                  (0) "enddate"={ts '2012-12-28 00:00:00.000'} AND "recate"='0' AND

                  "retype"='0' AND
                  (0) "rereson"='5858' AND "remark"='' AND "lastmodifier"='7' AND
                  (0) "lastmodifidate"={ts '2012-12-28 10:41:03.070'} AND
                  (0) "attachmentname"='飞行准备网一期演示沟通会议.doc
                  (0) '
                  (0) UPDATE "T_FLY_FLYER_REWARD" SET "attachment" = ? WHERE "pkid"=3 AND
                  (0) "empid"=10004036 AND "startdate"={ts '2012-12-28 00:00:00.000'} AND
                  (0) "enddate"={ts '2012-12-28 00:00:00.000'} AND "recate"='0' AND

                  "retype"='0' AND
                  (0) "rereson"='5858' AND "remark"='' AND "lastmodifier"='7' AND
                  (0) "lastmodifidate"={ts '2012-12-28 10:41:03.070'} AND
                  (0) "attachmentname"='飞行准备网一期演示沟通会议.doc
                  (0) '
                  (0) i: 924 0 SQLAllocConnect:- henv=1424718,phd=12E834
                  (0) i: 931 0 SQLSetConnectOption:- hdbc=1426D30, fop=1218 , vprm=1
                  (0) i: 938 0 SQLSetConnectOption:- hdbc=1426D30, fop=103 , vprm=0
                  (0) i: 945 1 SQLDriverConnect:- hdbc=1426D30, hwnd=0, scsi=12E8C4,

                  ccsi=-3, s
                  cso=12E9C4, ccsom=1020, pcso=12E83A, fdc=0,
                  (0) i: 955 0 SQLGetInfo:- hdbc=1426D30, fit=18 ,rif=12e840, civm=130,

                  piv=12E
                  83C
                  (0) i: 960 0 SQLSetConnectOption:- hdbc=1426D30, fop=1217 , vprm=1
                  (0) Created new MSSQLODBC connection (21130544)
                  (0) e:1881 0 SQLAllocStmt:- hdbc=1426D30,pst=E22848
                  (0) e:1890 0 SQLSetStmtOption:- hst=1427F40, fop=0 , vprm=0
                  (0) e:1896 0 SQLExecDirect:- hst=1427F40, css=-3
                  (0) 6sss = SELECT "attachment" FROM "T_FLY_FLYER_REWARD"

                  WHERE "pk
                  id"=3 AND "empid"=10004036 AND "startdate"={ts '2012-12

                  -28 00:
                                  00:00.000'} AND "enddate"={ts '2012-12-28 00:00:00.000'}

                  AND "
                  recate"='0' AND "retype"='0' AND "rereson"='5858' AND

                  "remark"
                  ='' AND "lastmodifier"='7' AND "lastmodifidate"={ts

                  '2012-12-2
                                  8 10:41:03.070'} AND "attachmentname"='飞行准备网一期演

                  示沟通? 嵋?doc '
                  (0) e:1905 0 SQLDescribeCol:- hst=1427F40,icol=1,scn=

                  (null),cnm=0,pcn=0,pst=1
                  2EDDC,pcd=0,psc=0,pnul=0
                  (0) e:1914100 SQLFetch:- hst=1427F40
                  (0) i: 591100 SQLError:-

                  hnv=1424718,hdbc=21130544,hst=1427f40,sss=00000,pne=
                  12EB20,cemm=1239988,pem=1FF
                  (0) =14247sem =
                  (0) DB_MSSQLODBC_ENGINE (1916): ; (SQL State: 00000; SQL Code: 16)
                  (0) DRV_BlobRead: (SQL State: 00000; SQL Code: 16)
                  • 6. Re: How to deal with image type from SQL*Server2005
                    Kgronau-Oracle
                    First of all the environment you're using is not the best one. Even TG 10.2 is not longer supported there are some patch sets I would strongly recommend you to apply 10.2.0.4 or even better 10.2.0.5.
                    Another issue is the data type mapping of the image data type to long. There are a couple of restrictions using long data types. For example you need a PK on the source table and when the gateway tries to load the long data it automatically opens an implicit second connection that just fetches the data from the long. Most of the restrictions are documented in the manual and a better way to simply select * from the table is to fetch a single row instead of all (locking) or use PL/SQL and get through the cursor.
                    • 7. Re: How to deal with image type from SQL*Server2005
                      Mkirtley-Oracle
                      Hi,
                      The main restrictions in the documentation for IMAGE data -

                      Server
                      Administrator’s Guide
                      10g Release 2 (10.2) for Microsoft Windows (32-bit)

                      are this -

                      You cannot use SQL*Plus to select data from a column defined as Microsoft SQL
                      Server data type IMAGE, TEXT or NTEXT when the data is greater than 80
                      characters in length. Oracle recommends using Pro*C or Oracle Call Interface to
                      access such data in a Microsoft SQL Server database.

                      and also -

                      If a SQL statement is accessing a table including an IMAGE, TEXT or NTEXT
                      column, the statement will be sent to Microsoft SQL Server as two separate
                      statements. One statement to access the IMAGE, TEXT or NTEXT column, and a
                      second statement for the other columns in the original statement. This will result
                      in two connections to Microsoft SQL Server due to a limitation in the Microsoft
                      ODBC driver which only allows one statement for each connection, which can
                      cause a hang depending on the sequence of SQL statements. If this happens, try
                      issuing a commit and separating the statements in different transactions.

                      The trace you have sent shows the 28500 error is returned for this select -

                      (0) 6sss = SELECT "attachment" FROM "T_FLY_FLYER_REWARD"

                      WHERE "pk
                      id"=3 AND "empid"=10004036 AND "startdate"={ts '2012-12

                      -28 00:
                      00:00.000'} AND "enddate"={ts '2012-12-28 00:00:00.000'}

                      AND "
                      recate"='0' AND "retype"='0' AND "rereson"='5858' AND

                      "remark"
                      ='' AND "lastmodifier"='7' AND "lastmodifidate"={ts

                      '2012-12-2
                      8 10:41:03.070'} AND "attachmentname"='飞行准备网一期演

                      示沟通? 嵋?doc '

                      which gives this error -

                      (0) DB_MSSQLODBC_ENGINE (1916): ; (SQL State: 00000; SQL Code: 16)
                      (0) DRV_BlobRead: (SQL State: 00000; SQL Code: 16)
                      (0)
                      (0) nvRETURN (F:\Work\Connect_4_6_3\src\drv\DRV_BLOB.C 249): -1
                      (0) hoaftch (21): ; hoaftch Exited with retcode = 28500, hoadabrc = 1.

                      What happens if you run a similar select directly in SQL*Server ?

                      Regards,
                      Mike
                      • 8. Re: How to deal with image type from SQL*Server2005
                        978005
                        I see it. Thanks for your respones!