# | Date | Forum | Type | Thread | Post |
5 | 31 Mar 2011 @ 06:48 PDT | Database | Reply | Table metadata inspection | for primary key is it recommended to use the select version shown above or the jdbc getPrimaryKey method? They both seem to work to me. |
4 | 29 Mar 2011 @ 11:22 PDT | Database | Topic | Table metadata inspection | Hi,
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... |
3 | 29 Mar 2011 @ 04:54 PDT | Database | Topic | Calculating 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... |
2 | 29 Mar 2011 @ 03:20 PDT | Database | Reply | Is a strict mode for inserting strings possible | Some 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... |
1 | 29 Mar 2011 @ 03:16 PDT | Database | Topic | Is a strict mode for inserting strings possible | I 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 ... |
|
|