teradata_开发者

Problem reading special characters from teradata - JDBC

I use teradata and the below query outputs \"Altlüd\" when run using a teradata client. select name as namefrom MYTABLE where selector=?[详细]

2023-01-13 09:24 分类：问答

how do i filter out non-numeric values in a text field in teradata?

oI have a teradata table with about 10 million records in it, that stores a numeric id field as a varchar.i need to transfer the values in this field to a bigint column in another table, but i can\'t[详细]

2023-01-12 18:35 分类：问答

how to update rows by a range of dates in teradata

I have two tables in a teradata database that look like this accounts account_number integer date_updated_last datetime[详细]

2023-01-04 20:03 分类：问答

Using TeraData for not so big applications

Few months back I saw TeraData Express Edition. I have no idea of this beast. I want to know whether it still comes with Express Edition and whether it is a good idea to use this database for Windows[详细]

2023-01-04 14:57 分类：问答

Teradata SQL: select a literal

I want to use a list of arbitrary numbers as a sort of input to a select.Option A, of course, is to create a temporary table that contains just the values (e.g., 1,2,3).[详细]

2023-01-04 10:28 分类：问答

Teradata Change data capture

My team is thinking about developing a real time application (a bunch of charts, gauges etc) reading from the database. At the backend we have a high volume Teradata database. We expect some other app[详细]

2022-12-28 23:39 分类：问答

How to use variables in Teradata SQL Macros

I\'m wanting to use variables inside my macro SQL on Teradata. I thought I could do something like the following:[详细]

2022-12-27 22:41 分类：问答

Early (or re-ordered) re-use of derived columns in a query - is this valid ANSI SQL?

Is this valid ANSI SQL?: SELECT 1 AS X ,2 * X AS Y ,3 * Y AS Z Because Teradata (12) can do this, as well as this (yes, crazy isn\'t it):[详细]

2022-12-23 07:18 分类：问答

Best way to compare contents of two tables in Teradata?

When you need to compare two tables to see what the differences are, are there any tools or shortcuts you use, or do you handcode the SQL to compare the two tables?[详细]

2022-12-23 03:35 分类：问答

Best way to produce automated exports in tab-delimited form from Teradata?

I would like to be able to produce a file by running a command or batch which basica开发者_如何学Clly exports a table or view (SELECT * FROM tbl), in text form (default conversions to text for dates,[详细]

2022-12-23 03:34 分类：问答