Recent content by CapsuleCorpJX

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...

Hmm, but that doesn't specify integers only at those positions. So ABC-DEFG will also work.

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?

Well if you don't care if the 10 rows you get are random, then you can use "RANK". Basically sort a result and take the top or last x rows. For example : top 10 sales select CUST_ID, CUST_SALE from SALES qualify rank() over (order by CUST_SALE desc) <= 10

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...

Found the answer: ... TRIM(TESTFIELD) like 'Testing_me'c || '_Y' ... the c char means anything before this is a literal. So here are examples that will match the condition above: Testing_mexY Testing_me4Y Testing_me_Y Those that will not match: TestingXme_Y Testing_meXXY

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?

NvM, I found a really good manual: http://www.teradata.com/t/pdf.aspx?a=83673&b=125778

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?

Its better to just do it software side (lock table, get highest number, insert new record with highest number + 1, unlock table). I don't know if Teradata has autoincrement.

Is NCR considering adding Regular Expressions as a functionality in future releases? UDF's are fine, but I'd rather not use anything from third parties in querying Teradata. I think it would definately be helpful.

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