× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2009-08-15T20:43:21Z  · last modified 2009-08-18T16:31:47Z

Script Object to Window --Insert Teradata


Dev
Fun Fun
funfun
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Trivial
Component App - Visual Editing
Version 08.0

ADS build 7.9.82

Teradata Server

Database fcy_test_db
T_ZONE

Select table T_ZONE

Right Click and Script Object to Window --> Insert

ADS gives the below SQL which is never executed. The format of Time is incorrect

INSERT INTO T_ZONE(T1, T2, T3, T4)
    VALUES('1:39:43.0', '2009-8-15 1:39:43.0', '1:39:43.0', '2009-8-15 1:39:43.0')
GO

>[Error] Script lines: 1-4 --------------------------
 [Teradata Database] [TeraJDBC 13.00.00.06] [Error 6758] [SQLState HY000] Invalid time.

The below format works

INSERT INTO T_ZONE(T1, T2, T3, T4)
    VALUES('02:36:24.011', null, '03:36:24.011', null)
GO

INSERT INTO fcy_test_db.T_ZONE(T1, T2, T3, T4)
VALUES('13:48:08', '2009-08-15 13:48:13.421', '13:48:14', '2009-08-15 13:48:15.718')
GO

Issue #3003

Closed
Fixed
Resolved 2009-08-18T16:31:47Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017