This discussion is archived
8 Replies Latest reply: Jan 14, 2013 7:37 AM by 978005 RSS

How to deal with image type from SQL*Server2005

978005 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    (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 Newbie
    Currently Being Moderated
    (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 Newbie
    Currently Being Moderated
    (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 Newbie
    Currently Being Moderated
    (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 Guru
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    I see it. Thanks for your respones!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points