Re: [Firebird-odbc-devel] selecting from Oracle 11g to firebird

[Hauser, K. <Kar...@ib...>]

Here's the one without join:

dg4odbcFORMICA  f08-d50	ENTER SQLPrepare 
		HSTMT               01B51960
		UCHAR *             0x01E9C698 [      40] "SELECT "NR" FROM "PERSONAL" WHERE ?="NR""
		SDWORD                    40

dg4odbcFORMICA  f08-d50	EXIT  SQLPrepare  with return code 0 (SQL_SUCCESS)
		HSTMT               01B51960
		UCHAR *             0x01E9C698 [      40] "SELECT "NR" FROM "PERSONAL" WHERE ?="NR""
		SDWORD                    40

dg4odbcFORMICA  f08-d50	ENTER SQLNumResultCols 
		HSTMT               01B51960
		SWORD *             0x01E11638

dg4odbcFORMICA  f08-d50	EXIT  SQLNumResultCols  with return code 0 (SQL_SUCCESS)
		HSTMT               01B51960
		SWORD *             0x01E11638 (1)

dg4odbcFORMICA  f08-d50	ENTER SQLBindParameter 
		HSTMT               01B51960
		UWORD                        1 
		SWORD                        1 <SQL_PARAM_INPUT>
		SWORD                        1 <SQL_C_CHAR>
		SWORD                        3 <SQL_DECIMAL>
		SQLULEN                    1
		SWORD                        0 
		PTR                0x01EAE5F4
		SQLLEN                    65
		SQLLEN *            0x01E1D5E4

dg4odbcFORMICA  f08-d50	EXIT  SQLBindParameter  with return code 0 (SQL_SUCCESS)
		HSTMT               01B51960
		UWORD                        1 
		SWORD                        1 <SQL_PARAM_INPUT>
		SWORD                        1 <SQL_C_CHAR>
		SWORD                        3 <SQL_DECIMAL>
		SQLULEN                    1
		SWORD                        0 
		PTR                0x01EAE5F4
		SQLLEN                    65
		SQLLEN *            0x01E1D5E4 (65)

dg4odbcFORMICA  f08-d50	ENTER SQLExecute 
		HSTMT               01B51960

dg4odbcFORMICA  f08-d50	EXIT  SQLExecute  with return code -1 (SQL_ERROR)
		HSTMT               01B51960

		DIAG [01004] [ODBC Firebird Driver]Data truncated (0) 

		DIAG [HY000] [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -303
conversion error from string "           " (-303)
----------------------------
And here with trim:

dg4odbcFORMICA  e44-194	ENTER SQLPrepare 
		HSTMT               01B51960
		UCHAR *             0x01E9C6B4 [      27] "SELECT "NR" FROM "PERSONAL""
		SDWORD                    27

dg4odbcFORMICA  e44-194	EXIT  SQLPrepare  with return code 0 (SQL_SUCCESS)
		HSTMT               01B51960
		UCHAR *             0x01E9C6B4 [      27] "SELECT "NR" FROM "PERSONAL""
		SDWORD                    27

dg4odbcFORMICA  e44-194	ENTER SQLNumResultCols 
		HSTMT               01B51960
		SWORD *             0x01E11638

dg4odbcFORMICA  e44-194	EXIT  SQLNumResultCols  with return code 0 (SQL_SUCCESS)
		HSTMT               01B51960
		SWORD *             0x01E11638 (1)

dg4odbcFORMICA  e44-194	ENTER SQLExecute 
		HSTMT               01B51960

dg4odbcFORMICA  e44-194	EXIT  SQLExecute  with return code 0 (SQL_SUCCESS)
		HSTMT               01B51960


So it seems that the problem is related to the binding during execution.

-----Ursprüngliche Nachricht-----
Von: Alexander Potapchenko [mailto:ale...@re...] 
Gesendet: Dienstag, 13. Januar 2009 16:54
An: fir...@li...
Betreff: Re: [Firebird-odbc-devel] selecting from Oracle 11g to firebird

Hauser, Karsten wrote:
> I've created the issue. I don't know how to trace the execution of the statement in Firebird. Maybe you can give me an manual for doing this?
>
> I have only one further statement which works:
> SELECT pe.NR, us.USER_LOGIN
> FROM IBKPVS_SYS_USER us
> LEFT JOIN PERSONAL@formica pe ON us.USER_PERS_ID_FK = pe.NR
> where TRIM(us.USER_LOGIN) = 'ADMIN'
>
> But inserting a trim should not be the solution..
>
>   
No, I have said about ODBC trace file.
I want to look at the first query (without TRIM in the SQLPrepare) and 
the second query with TRIM at ODBC level.

Regards,
Alexander
-- 
Alexander Potapchenko
Senior developer

------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

------------------------------------------------------------------------------------------------------------
IBYKUS AG für Informationstechnologie, Erfurt / HRB 108616 - D-Jena / Vorstand: Helmut C. Henkel, Dr. Lutz Richter /
Vorsitzender des Aufsichtsrates: Dr. Frieder Schäuble