Error "The parameter 'type' cannot be null" returned on executing "create table" statement via ODBC

[Sergey Smagin]

Hi,

I am a developer of the ODBC SQL query tool (FlySpeed SQL Query).

One of my customers sent me the ODBC trace indicating the "The parameter 'type' cannot be null." error.

According to the trace, this error comes right on executing the following "create table" statement:

create table temp1 as select * from TestSch.Table1

You can see that there is no "type" parameter involved, so I suspect this might be an uninitialized ODBC attribute or something like that.

According to the log, the driver is "TIBCO® Data Virtualization ODBC Driver", version: 07.00.06.00

The trace indicates some "Log ID" identified by GUID. Maybe this log contains the necessary information to solve the problem, but I don't know How can I request this log.

Can somebody give some clues how to solve this problem

Additional info: The tool is written in Delphi, so I use FireDAC library to work with ODBC.

Below is a piece of the ODBC Trace:

SQLSetStmtAttrW(0x000000000b8a3f30, SQL_ATTR_CURSOR_TYPE, 0x0000000000000002, -5)

Status=0

SQLSetStmtAttrW(0x000000000b8a3f30, SQL_ATTR_CONCURRENCY, 0x0000000000000001, -5)

Status=0

SQLPrepareW(0x000000000b8a3f30, "create table temp1 as select * from TestSch.Table1", -3)

Status=0

SQLExecute(0x000000000b8a3f30)

Statement: incoming sql=`create table temp1 as select * from TestSch.Table1`

> execplan 11 713

> autocommit=true

> maxrows=0

> (end of command)

> ROW

> ZSTRING create table temp1 as select * from TestSch.Table1

> ROW

> END

====

Channel writes 107 bytes, errno 0

Channel reads 101 bytes, errno 0

< error 11 713

< field zstring The parameter 'type' cannot be null. [Log ID: bb222c62-9e93-49a3-a08b-768dea8418a7]

< END

====

[Deepak Kuletha]

How and what  query is being run ,what is the  data flow and how TDV is being used here

[Sergey Smagin]

Hello.

The user connects to TDV via ODBC using our SQL query tool, types a query (it is written in the original request) by clicking the Execute button.

[Jolanda van Gilst 2]

You can receive this error if one of the columns in your source table is definied without a data type.