0 - 14 of 14 tags for columns

Hi,
I have 100+ columns. I need to retreive columns having a specific value [Say 'ABC'] in any of the rows. 
Please help. 

Hi,
I have a table that looks like this:

Column1 Column2 Column3
800 900 200
500 300 40
100 600 150

and I would like to concatenate Column1, Column2, Column3 in a list that is order by the values of three columns:

Result
200,800,900
40,300,500
100,150,600

Hi,

I have a table that looks like this:

 

Column1 Column2 Column3

800        900        200

500        300        40

100        600        150

 

and I would like to concatenate Column1, Column2, Column3 in a list that is order by the values of three columns:

 

Result

Hi,

I have a table that looks like this:

 

Column1 Column2 Column3

800        900        200

500        300        40

100        600        150

 

and I would like to concatenate Column1, Column2, Column3 in a list that is order by the values of three columns:

 

Result

 

Greetings All,

 

When comparing 2 different char/varchar datatypes in TD , the comparison is returning undesired results as the hexadecimal representation of the data in columns is different eventhough the data is visibly same.  Not sure what the "00" in the 

hexadecimal notation represents. 

 

Hi all,
I'm writing here because I didn't find any previous entry that solve my strange problem.

1) I define a table that has a column with COMPRESS clause

Hi everyone,
I'm tryng to build a set of queries with the objective of getting the DDL of tables only from the info inside the dbc tables (columns, tvm, dbase, tableconstraints...).
I started from the table dbc.columns to get all the info about every field of a table.
Below you can find the work in progress query.

Hi Guys

 

I'm facing a difficulty in achieving the below scenario

 

Scenario :

Table A is the table i'm having

( The column ID2 has only 4 distinct values -- A,B,C,D )

 

Good Day Folks...
3 Q's bunched up on stats ...
<> When should you collect Index stats  and column stats for the component columns , both as against just Index stats. How does index stats help and how does stats on component columns that make up the Ix help 

I'm still new to TeraData, so most of my issues and inquiries are probably simple.  I've done a few searches, and can't seem to find much...

If I have 5 columns, itm_cd1 thru itm_cd5, is there an easy way to select the highest value of the 5?

Hi all

I have a record with several fields, and the las one has a large text. 

This text has a separator ; so what i would like to do is go from 1 large field with separators to various columns.

This applies to many files ( > 5000) and lots of records (aprox 200 mill) so i dont think something like awk would be efficient. 

In the past I have used Recursive and Rank Partition By to convert rows to columns. Now I have a new situation. I have data:
AccT_id Cust_id
10XXXXX1 85314587
10XXXXX1 92458714
5XX0XXX5 2587452
5XX0XXX5 4258702
5XX0XXX5 54782142
5XX0XXX5 67842521
5XX0XXX5 85745872

I need to place the cust_id into a colmun as:
Acct_id Cust_id1 Cust_id2 Cust_id3 Cust_id4 Cust_id5 Cust_id(N)
10XXXXX1 85314587 92458714
5XX0XXX5 2587452 4258702 54782142 67842521 85745872

Hi ALL,
I need to calculate the number of columns of specific tables in Teradata indeed. I searched & tried but none of my solutions work. is there a way to do so. any suggestion will be appreciated.

Thank you,