Search results for query: *

Ok here is my problem. Newlines are typically two characters, \r\n (carriage return, line feed). The problem is the VB6 XML class I'm using(MSXML2.DOMDocument40) counts \r\n as two characters, while every other XML App/parser seem to count it as one char. Is there a way to have it consider...

Hey guys, I know I can do a string search in teradata using the % wild card. But does Teradata handle regular expression searchs? Like say give me all the rows in a table that have a phone number in it matching format (###-####)

I noticed that Teradata SQL Assistant does not check the macros thoroughly enough. It doesn't check to make sure that all the variables (WHERE ID = :VariableA for example) are declared in the parameter list. This has caused several errors on attempting to run the macro. Is there some SQL...

Is there a DBC table that holds the last time statistics was collected on a given table?

For example, if this was in the where clause: TRIM(DATABASENAME) like 'test\_db\__mine' ESCAPE '\'" I'd be searching for test_db_<*>mine where <*> is any single character. What I noticed is that such a filter will significantly slow down a query. Anyone else noticing this? Makes sense though...

It is an amazing product. Frequent virus updates, takes very little resources and seems to be quite effective. So how is AVG doing it? Are they making enough sales to Corperations that they can give this product out for free to home users?

What is the escape character for wild-cards? % means 0 to many characters. _ means 1 character. What if I want to search for "_" literally?

I cant seem to find any create trigger examples. Basically for each row that gets updated, i want to see what user is making the change, and depending on the username, I want to set a column for that row. Can anyone point me in a good direction?

Anyone know of a good website explaining how Teradata User Roles work? Google isn't giving me the results I'm looking for.

lets say I have an application that accesses two databases (or schemas/regions): TEST1 TEST2 Is there a way to set the default database to BOTH of those regions? Say if I execute a macro, Teradata will automatically determine where the macro is found, and execute it: TEST1.macro1 TEST2.macro2...

so does Decimal(9,2) Mean [Up to 7 digits].[Up to 2 digits] With the negative and period being optional? Or does it mean that the number of chars in the entire thing can't be more than 9, with at most 2 to the right of the decimal so: -[5 digits].[2 digits] and [6 digits].[2 digits] and [7...

Is there anything a stored procedure can do that a macro can't?

This is especially true for System Admin jobs. Nobody will really hire you unless you have experience. And you can't get experience without actually having a job. So how do you sys admins out there actually get a job? I don't know if a B.S. in Comp Sci and some certifications is enough.

I don't get it, they work fairly well, but what is funding AVG if it is free?

Is there a document with all the Teradata SQL functions explained?

Currently the way I recompile a stored procedure is to reexecute its definition. Is there a teradata command that will recompile the procedure? Like: "recompile databasename.procedurename" and thus let me capture any errors it may return (for example: procedure can't be recompiled because a...

Hey I use dynamic SQL in my stored procedures so I can pass the database name as a parameter. Does anyone know if a regular stored procedure runs faster than a stored procedure that uses dynamic sql?

Does Teradata SQL support string parsing like a replace function? for example: select replace(<old_char>,<new_char>,<string_var>) from testdb.testtable;

TotalCPUTime col in dbc.dbqlogtbl, how is it defined? Is it milliseconds of CPU time?

Is there a replace string function in Stored Procedure? Like newstring = string_replace(oldstring, <old value>, <new value); Or bascially look for a substring = <old value> in oldstring, and replace it with <new value> and store it in newstring.