#DateForumTypeThreadPost
1219 Mar 2014 @ 01:54 PDTDatabaseTopicSELECT statement in FUNCTIONSHi Guys,   I need to create a function that reads its result from a table, so I need to use a SELECT statement to read the output. Something like that: CREATE FUNCTION mydb.rate(a CHAR(3)...
1104 Jul 2013 @ 07:12 PDTDatabaseTopicUsing QUALIFY and GROUP BY together ?!Can someone throw some light how can QUALIFY,GROUP BY and HAVING be used together? Any link to docs or simple example will be usefull. Also which one takes precedence, when used together and what...
1016 Apr 2013 @ 07:22 PDTDatabaseReplyCast CHAR/VARCHAR to VARBYTEDieter, those two statements are not mutually exclusive. Thanks, I'll do it on my own.
916 Apr 2013 @ 04:53 PDTDatabaseReplyCast CHAR/VARCHAR to VARBYTEThanks Dieter, but I want to apply a mask to the string, not just one ascii code.
815 Apr 2013 @ 05:22 PDTDatabaseReplyCast CHAR/VARCHAR to VARBYTEThe data is already stored as string. I want to search it, checking if it contains given ASCII code or not.
712 Apr 2013 @ 01:30 PDTDatabaseReplyCast CHAR/VARCHAR to VARBYTEAnyone? Please don't tell me that Teradata is missing this functionality, even MySQL has a cast from string to binary: CAST(str AS BINARY)  
611 Apr 2013 @ 09:04 PDTDatabaseTopicCast CHAR/VARCHAR to VARBYTEIs there a way to convert string data into varbinary data type. I want to use the BYTE/BIT manipulation functions on a string column, but they can recieve only BYTEINT,INT, BIGINT and VARBYTE data ...
520 Feb 2013 @ 03:33 PSTDatabaseReplyAdd comment on a COLUMN or TABLEI've just realized that adding regular comments will do the trick. CREATE TABLE test( id INT /* This is the ID! */ )  
420 Feb 2013 @ 02:29 PSTDatabaseTopicAdd comment on a COLUMN or TABLEHi, I'm trying to add a comment whithin the CREATE TABLE ddl. I've check that Teradata supports comments  via statements of the type: COMMENT ON COLUMN table.col 'A comment!...
315 Feb 2013 @ 05:56 PSTDatabaseReplyHow to parametrize WHERE IN clause in stored procedure?Hi Dieter, I understant that 'US,GE' <> 'US','GE' , the question is how to get the second from first? I alreary tried what you suggest and it doesn't work. SE...
215 Feb 2013 @ 01:57 PSTDatabaseTopicHow to parametrize WHERE IN clause in stored procedure?I'm trying to parametrize a stored procedure, which takes one input string parameter and use it in the where clause in dynamic cursor. The following snippet works with one parameter but when t...
116 Oct 2012 @ 11:38 PDTToolsTopicFastload issueI'm trying to load a table dump exported with fastexport, but i get the following error: The length of: PREFIX in row: 1 was greater than defined. Defined: 3, Received: 3072 ...