Parameter Query in Excel ODBC

General
Enthusiast

Re: Parameter Query in Excel ODBC

HI Dave,

 

Here is the return form trace, the first one is with single UPC and the 2nd one is form multiple UPCs everything looks very similar up to this point

 

EXCEL           1bc4-25b4ENTER SQLBindParameter  
  HSTMT               0x0D8F97F0
  UWORD                        1 
  SWORD                        1 <SQL_PARAM_INPUT>
  SWORD                        8 <SQL_C_DOUBLE>
  SWORD                        3 <SQL_DECIMAL>
  SQLULEN                   14
  SWORD                        0 
  PTR                0x28F27FD0
  SQLLEN                     8
  SQLLEN *            0x28CF4B30
   
EXCEL           1bc4-25b4EXIT  SQLBindParameter  with return code 0 (SQL_SUCCESS) 
  HSTMT               0x0D8F97F0
  UWORD                        1 
  SWORD                        1 <SQL_PARAM_INPUT>
  SWORD                        8 <SQL_C_DOUBLE>
  SWORD                        3 <SQL_DECIMAL>
  SQLULEN                   14
  SWORD                        0 
  PTR                0x28F27FD0
  SQLLEN                     8
  SQLLEN *            0x28CF4B30 (8)

 

 

Multiple UPC'c

EXCEL           1bc4-25b4ENTER SQLFreeStmt  
  HSTMT               0x0D8AA648
  UWORD                        1 <SQL_DROP>
   
EXCEL           1bc4-25b4EXIT  SQLFreeStmt  with return code 0 (SQL_SUCCESS) 
  HSTMT               0x0D8AA648
  UWORD                        1 <SQL_DROP>
   

 

 

Thanks Z

Highlighted
Apprentice

Re: Parameter Query in Excel ODBC

Hi,

When I use the trace facility I get the SQL text written to the file, I also get a lot more entries than just these few. I'm assuming that you've sent me the entire file (sorry but I need to check).

 

If that is all the info in that file then you might need to go via the Teradata Query log route. Can you arrange that?

 

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com