ODBC metadata Import

Azzuri · Post by **Azzuri** » Thu Sep 18, 2008 7:56 am

Hi All, I'm trying to import a table definition from SQLSERVER 2000 and it's converting smalldatetime to char(16). When I try to read the data I get the error below

Error when checking operator: When binding output interface field "DUE_DATE" to field "DUE_DATE": No default type conversion from type "timestamp" to type "string[16]".

Anyone else run into this problem?

Azzuri · Post by **Azzuri** » Thu Sep 18, 2008 11:54 am

If I manually change the data type from char(16) to Timestamp for the date columns it works fine.

The problem is I don't want to do this for each table which has date columns

chulett · Post by **chulett** » Thu Sep 18, 2008 12:47 pm

How did you import the metadata? Meaning, what tool did you use?

Azzuri · Post by **Azzuri** » Thu Sep 18, 2008 1:06 pm

Hi Craig, I used DS Manger -Table Definitions -ODBC

chulett · Post by **chulett** » Thu Sep 18, 2008 1:10 pm

From what I understand, the 'orchadmin' command does a better job with metadata for the PX product. Pretty sure that's it... orch-something-or-other.

chulett · Post by **chulett** » Thu Sep 18, 2008 1:14 pm

Ah... orchdbutil not the admin command. Or you can just go off the menu and let it run the command for you:

Import > Table Definitions > Orchestrate

Azzuri · Post by **Azzuri** » Thu Sep 18, 2008 1:15 pm

Thanks Craig, I will look it up. Never imported that way before.