#DateForumTypeThreadPost
2224 Jul 2014 @ 03:43 PDTConnectivityTopicSQLPrepare error when NoScan enabledHi guys. I have some troubles with ODBC driver. I'm facing error HY092 Invalid attribute when try to run SQLPrepare function. My connection sting to Teradata: DRIVER={Teradata};DBCName=1...
2116 Jun 2014 @ 10:59 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverThank you :-) But unfortunately, our application should work with 13.10 Teradata with 13.10 odbc drivers, 14.00 Teradata with 14.00 drivers etc.
2016 Jun 2014 @ 06:46 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverI'm reading "ODBC Driver for Teradata User Guide Release 03.05.00 B035-2509-115A November 2005". Chapter 2 in "Table 13: Options Configurable in the .odbc.ini File" Why it...
1916 Jun 2014 @ 06:14 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverSorry about that=) I'm trying to connect to Teradata via connection string on Windows platform. I should do cross-platform but I've started my testing from Windows). I'm looking in ODB...
1816 Jun 2014 @ 12:44 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverIn SQL Assistant it's OK. I think there is some bug in Teradata ODBC driver. Because When I open connection from my application, I'm connecting to Teradata via connection string: DRIVER=Te...
1715 Jun 2014 @ 10:35 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverI have tried to run this query in Teradata Administrator 13.10.0.02. Unfortunately I must test my queries in 13.10+ versions for customers. So I can't move to newer versions without support for...
1614 Jun 2014 @ 01:49 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverAlso I have small update. I've ran WireShark and saw that ODBC driver has changed TIME(3) to INTEGER FORMAT '99:99:99', but I have checked 'Disable Parsing' option, but ODBC dr...
1514 Jun 2014 @ 01:38 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driver Otherwise it's probably not related to ODBC, it might be due to an implicit typecast on TIME in SUBSTR or ||, which is not supported. TIME and TIMESTAMP must be explicitly cas...
1414 Jun 2014 @ 01:35 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverUnfortunately adding format string when casting to varchar doesn't help. Can you please try on your Teradata? I'm running scripts on Teradata 13.10. DDLs: CREATE MULTISET TABLE aidar....
1314 Jun 2014 @ 01:19 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverThank you. Target column COL_1 is also in ANSI TIME(3). I will try to correct cast time to varchar.
1214 Jun 2014 @ 01:09 PDTConnectivityTopicProblem with ANSI TIME type and ODBC driverHi guys, I have a problem with TIME datatype and my ODBC drivers. In ODBC driver I have DateTimeFormat=III and enabled DisableParsing. When I try to run this query: INSERT INTO  aidar.t...
1113 Jun 2014 @ 01:42 PDTDatabaseReplyHelp with error Syntax error: expected something between the beginning of the request and the 'DECLARE' keyword"You can't write scripts with variables outside of stored procedures in Teradata. Please read some forum posts and rewrite your script. https://forums.teradata.com/forum/database/user-defined-...
1013 Jun 2014 @ 01:19 PDTDatabaseReplyHelp with error Syntax error: expected something between the beginning of the request and the 'DECLARE' keyword"Hi, Your script is looking as Ms SQL Server script. Teradata has another SQL syntax. For example, Teradata hasn't SmallDateTime type. You can use Timestamp instead of it. Teradata has CAST f...
913 Jun 2014 @ 01:05 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverMaybe Teradata remembers DateTimeFormat for each connection and treat CAST AS TIME(3) as CAST AS INTEGER... . I don't know where is the problem: in ODBC drivers parsing or in Teradata and conne...
813 Jun 2014 @ 01:01 PDTDatabaseTopicProblem with ANSI TIME type and ODBC driverHi guys, I have a problem with TIME datatype and my ODBC drivers. In ODBC driver I have DateTimeFormat=III and enabled DisableParsing. When I try to run this query: INSERT INTO  aidar.t...
713 Jun 2014 @ 11:58 PDTDatabaseReplyProblems with NoScan parameterSorry guys. I've read again ODBC driver manual and see that NoScna is only for UNIX, in Windows I should use DisableParsing parameter. Problem has been resolved.
613 Jun 2014 @ 11:54 PDTDatabaseReplyProblems with NoScan parameterForgot to mention. I'm running my application in Windows.   DDLs of tables are: CREATE MULTISET TABLE aidar.time_ansi ,NO FALLBACK ,      NO BEFORE JOURNAL, &n...
513 Jun 2014 @ 11:49 PDTDatabaseTopicProblems with NoScan parameterHi,   I'm facing SQL error "Syntax error, expected something like an 'IN' keyword or a 'CONTAINS' keyword between ')' and '|'." when run stateme...
404 Apr 2014 @ 01:41 PDTToolsReplyTPT load to table which contains special characters in name and column namesI've solved issue. I have incorrect placed quotes in error table names. Thank you very much. Now all is working good.
331 Mar 2014 @ 12:10 PDTToolsReplyTPT load to table which contains special characters in name and column namesThank you very much. I'll try to go deeper in what happens investigating.
228 Mar 2014 @ 02:27 PDTToolsReplyTPT load to table which contains special characters in name and column namesIt's a full script. I'm using TPT API im my source code, and I'm sending only this statement to Teradata. Could you say please can I use names with spcial characters in TPT? If yes, wh...
127 Mar 2014 @ 04:41 PDTToolsTopicTPT load to table which contains special characters in name and column namesHi to all, I want to load data using TPT utilities into table which has special characters in table name and column names. In my code I build dml statement: `INSERT INTO "aidar"."A...