|625||03 Oct 2013 @ 05:56 PDT||Tools||Reply||Converting Binary extracted file using TPT to ASCII?||you are right ;-)
try google and search binary to ascii linux
I saw some possible solutions there.
How big was the difference (binary compared to ascii) on your system?
|624||03 Oct 2013 @ 04:13 PDT||Database||Reply||CASE statement in SQL||try to avoid implicit conversions.
If you compare with a char constant on the righ side make sure the left side is also char.
something like coalesce(trim(cast(id as varchar(11))),&... |
|623||23 Sep 2013 @ 11:53 PDT||General||Reply||how to select multiple variables with same prefix||no, it's not possible to specify something like select v_1--v_100
you can generate the columnlist with SQL and copy paste the needed columns into your statement
select case ... |
|622||20 Sep 2013 @ 07:35 PDT||Database||Reply||Please help me on BT/ET and ROLLBACK/ABORT||Hm,
what you do is
1. Begin a transaction
2. Ins/select - at the end of the Ins/Select the transaction is still open.
3. End the transaction (Insert / Select is commited)
4. Rollback - What do... |
|621||20 Aug 2013 @ 11:26 PDT||Database||Reply||Like Operator in Teradata||Hi,
databasename has length 30 so like'H%DB' will only work for databasenames which are actually 30 characters long.
an so use trim(databasename) like 'H%DB'
|620||20 Aug 2013 @ 03:59 PDT||Aster||Reply||Aster_function load_from_teradata||Most likely to be a network issue where is can be very ugly to track this down as the issue can be on every layer (VM, host, firewall...).
Are you sure that your Aster as access to your TD b... |
|619||19 Aug 2013 @ 12:16 PDT||Aster||Reply||Aster_function load_from_teradata||Hi,
the my_driver table is some kind of dummy and should be exactly defined as in the example.
The code below works for me
CREATE TABLE mr_driver( c1 INT)
DISTRIBUTE BY HASH (c1) ;
|618||13 Aug 2013 @ 08:27 PDT||Database||Reply||Row limit in 13.0 and higher||looks like - FTFM (release 14.0) -
"Keep in mind that the Teradata Database row size is approximately 64KB, so the spool file for the output must be chunked into sequences that are no l... |
|617||05 Aug 2013 @ 07:12 PDT||Database||Reply||For joins NUPI can be a better choice than a UPI||you don't give any context for "For join performance, a NUPI can be a better choice than a UPI." so it would require again the crystal ball to come up with a reply...
|616||02 Aug 2013 @ 02:27 PDT||Database||Reply||Search for first substring in string with condition||I agree with Dieter. But I also don't think this will work within the DB - at least not for the big SQL's which spann multiple lines in qrylogSQL.
I use a java programm to do this which pa... |
|615||01 Aug 2013 @ 12:43 PDT||Database||Reply||Selecting groups whose member belongs to multiple groups||
select group_id, member_id
qualify count(group_id) over (partition by member_id) > 1
|614||31 Jul 2013 @ 07:14 PDT||Database||Reply||Search for first substring in string with condition||performance depend on your data volumes but at least this does the trick with your data ;-)
I used the volatile table to make it a bit more clearer
First splitt your data into chars and kee... |
|613||31 Jul 2013 @ 06:27 PDT||Database||Reply||Search for first substring in string with condition||which version are you on?
|612||24 Jul 2013 @ 06:45 PDT||Connectivity||Reply||Login OK with teradata Assistant, KO with BTEQ||the message is indicating that BTEQ reached the server but either user or password is wrong.
Are you 100% sure of not having a typo?
|611||24 Jul 2013 @ 06:42 PDT||Database||Reply||Untranslatable character at any position in a field.||did you check the TRANSLATE function and checked the WITH ERROR option?
|610||24 Jul 2013 @ 06:38 PDT||Database||Reply||Can I do select from fallback table?||system will read the fallback data if a node or diskarray is going down but you can't influence this with a SQL.
What would be the benifit if direct accessing it?
|609||24 Jul 2013 @ 06:36 PDT||Database||Reply||Unicode vs Latin||latin is just the system default at your system if you are not specifing something in your ddl.
space savings - an unicode varchar/char will use 2 times the space.
|608||12 Jun 2013 @ 05:55 PDT||Data Modeling||Reply||Effect of reversing the order of columns in mutli-column stats||at least up to 13.10 - I am not 100% sure about 14.0.
Only the 16 bytes of the conc... |
|607||04 Jun 2013 @ 06:00 PDT||Database||Reply||Is there any way to handle single digit's in date?||Try SEL TO_TIMESTAMP('May 10 2013 10:58:04:3934PM', 'Month dd yyyy hh:mi:ss:ssssAM')
|606||04 Jun 2013 @ 04:37 PDT||General||Reply||Same hash for different values||The hashrow has to few bits, so hash collissions are common. It doesn't have the same properties as a SHA1 hash.
|605||30 May 2013 @ 10:59 PDT||Database||Reply||Transposing the data - QUERY||you could do the same with min and the change_log_from column
build two derived tables (one with the max one with the min)
and join the results together and coalesce the max, min... |
|604||30 May 2013 @ 10:58 PDT||Analytics||Reply||teradataR package and R 3.0.0||I know - but why doesn't TD release a new version?
Or release the source code as open source and someone could move this forward?
|603||30 May 2013 @ 08:42 PDT||Database||Reply||Transposing the data - QUERY||Are you looking for something like
substr(max(case when columnname = 'change_col_1' then cast(update_time as char(30)) ... |
|602||30 May 2013 @ 07:11 PDT||Database||Reply||View validity check||its not possible to get this info out of dbc
it can change any time and maybe in 5 min the view is valid again.
try the following bteq script
.set width 500;
|601||29 May 2013 @ 03:36 PDT||Tools||Reply||Unable to open Teradata SQL assistant||Teradata SQL assistant on Mac OS? At least I never saw a Mac version
Teradata SQL assistant is a windows program. Or do you mean Teradata Studio (Express)?