#DateForumTypeThreadPost
531 Mar 2011 @ 06:48 PDTDatabaseReplyTable metadata inspectionfor primary key is it recommended to use the select version shown above or the jdbc getPrimaryKey method? They both seem to work to me.
429 Mar 2011 @ 11:22 PDTDatabaseTopicTable metadata inspectionHi, I need to find a few key pieces of metadata about a table's columns. I am using JDBC so the information can be obtained using SQL or jdbc methods like getPrimaryKey etc... Information ne...
329 Mar 2011 @ 04:54 PDTDatabaseTopicCalculating the bounding box of several geometries.I am trying to find out how to get the bounding box of several geometries in teradata. I am currently working with 13.00 and have tried the following: select SYSSPATIAL.AggGeomUnion(cast(geom...
229 Mar 2011 @ 03:20 PDTDatabaseReplyIs a strict mode for inserting strings possibleSome sql to demonstrate the issue: create table ft3 (string varchar(5)); insert into ft3 ('hello'); insert into ft3 ('1234567'); select * from ft3; the last select results in: 1234...
129 Mar 2011 @ 03:16 PDTDatabaseTopicIs a strict mode for inserting strings possibleI have created a table with a column that is varchar(5). When I insert a string of 6 characters the string is truncated to 5 characters rather than throwing an exception. Is there a way to force ...