Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 27 Nov 2001 @ 19:27:06 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Queryman and ODBC escape clause syntax
From:   Dara Tressler

It also seems to work with Queryman version 5.2.0 and driver

Have you checked the actual format of the table? I ran into trouble with Queryman 5.2.0 and creating ANSI formatted tables when I did not set the Date/Time format to be AAA (all ANSI). It was defined with III (??) and this created Integer rather than Time fields within the table. This caused a problem when setting these fields to ANSI compatible time constants.

I checked and when created with III it created the timestamp as character rather than timestamp type. I could not even insert the values indicated in your statement into the table. I modified the driver entry again to be AAA and then it created the table correctly and allowed the insert to work.

Just something to check.

Dara Tressler
Speedway SuperAmerica LLC

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020