12 | 19 Mar 2014 @ 01:54 PDT | Database | Topic | SELECT statement in FUNCTIONS | Hi 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)... |
11 | 04 Jul 2013 @ 07:12 PDT | Database | Topic | Using 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... |
10 | 16 Apr 2013 @ 07:22 PDT | Database | Reply | Cast CHAR/VARCHAR to VARBYTE | Dieter, those two statements are not mutually exclusive.
Thanks, I'll do it on my own.
|
9 | 16 Apr 2013 @ 04:53 PDT | Database | Reply | Cast CHAR/VARCHAR to VARBYTE | Thanks Dieter,
but I want to apply a mask to the string, not just one ascii code.
|
8 | 15 Apr 2013 @ 05:22 PDT | Database | Reply | Cast CHAR/VARCHAR to VARBYTE | The data is already stored as string. I want to search it, checking if it contains given ASCII code or not.
|
7 | 12 Apr 2013 @ 01:30 PDT | Database | Reply | Cast CHAR/VARCHAR to VARBYTE | Anyone?
Please don't tell me that Teradata is missing this functionality, even MySQL has a cast from string to binary:
CAST(str AS BINARY)
|
6 | 11 Apr 2013 @ 09:04 PDT | Database | Topic | Cast CHAR/VARCHAR to VARBYTE | Is 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 ... |
5 | 20 Feb 2013 @ 03:33 PST | Database | Reply | Add comment on a COLUMN or TABLE | I've just realized that adding regular comments will do the trick.
CREATE TABLE test(
id INT /* This is the ID! */
)
|
4 | 20 Feb 2013 @ 02:29 PST | Database | Topic | Add comment on a COLUMN or TABLE | Hi,
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!... |
3 | 15 Feb 2013 @ 05:56 PST | Database | Reply | How 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... |
2 | 15 Feb 2013 @ 01:57 PST | Database | Topic | How 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... |
1 | 16 Oct 2012 @ 11:38 PDT | Tools | Topic | Fastload issue | I'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
... |