Search results for query: *

Hey everyone, we're experiencing some strange behavior between an application and Teradata. Essentially, we are submitting a query, but the query is being rewritten. We have run some checks to see if the query is being rewritten by the application, or by Teradata. This is what we are...

Hey everyone, I am using a software package that cannot run under a limited account and must be run as an administrator. Currently I have all of my users set as administrators to allow them access. I want to put them back on limited accounts, but still allow them to run the required software as...

I'm running into unexpected results when I use a line comment at the end of a line sel trim('a') || trim(' ') || trim('b') || ' ' || substr('0000000000', 1,4) Will give me expected results, but sel trim('a') || trim(' ') || trim('b') || ' ' || substr('0000000000', 1,4)...

You might also want to keep in mind the amount of skew for a table. If any skew exists, the effective size of the table is much larger than the above query will show. If one AMP is full, it doesn't matter how much space is available on the others.

Thanks, the logic makes sense now.

Yeah, I thought the same, but try select index(123456,3); It returns 0...an even weirder result.

Why does the following statement return 3 instead of 1? select index(123456,1);

I think (s)he's trying to say that if fastload can load the table in , say, 5 minutes.... why is fastexport taking 25 minutes to export the table.

No I did not. I ended up just using two scripts.

Is there any way to prevent a user from dropping one of his own tables? We're basically trying to find a way to revoke all but select on a table from public, but still have the ability to grant all access back if needed. If you revoke all on a table from a user, is there any way to grant it...

The system is very stable. It was my understanding that Global Temp Tables will still exist after a session has closed. Is that not correct? Are they similar to volatile tables, except other users can see and use them too?

The connection object does not close until the end of the sub. I'm thinking connection pooling will open a different session within the connection....meaning the volatile table is not usable by any session other than the one that created the table.

Okay, I lied...that doesn't work. Still getting the same error.

I doubt it, the only way I can do it is through ODBC. I checked and there seems to be a way to set pooling to false. When making the connection string, just add "Pooling=False;

Thanks, i can't make changes, so just use it as an example of the logic.

Hey everyone, i'm currently working on an application for Teradata that will enable business users to reduce the size of their tables. The problem is i'm using volatile tables, and ADO.net does not use the same connection for each statement I execute. A volatile table is dropped by the system...

Hey everyone, i'm currently working on an application that will enable business users to reduce the size of their tables. It a two step process, the 1st step evaluates the data types, and the ranges within each data type and reccomends a new datatype (which the user can change if they don't want...

if this has to be done outside of bteq, you can use something like the following select case when b.cnt = 0 then 'Identical' else 'Different' end as yayornay from ( select count (*) from (select * from table1 minus all select * from table2 union all select * from table2...

Basically, we have a table that has monthly statement data. It is partitioned on statement date. I was trying to find this month's statement, as well as last month's statement. We were trying to avoid hard coding a date because we are automating a weekly process and don't want to have to change...

I have a date column that is indexed, and I want to query a range of dates. Which will use the index and which will use a full table scan? 1. select * from table where column_date between '2004-06-01' and '2004-06-30'; 2. select * from table where substr(column_date,1,7) =...