Recent content by WILLIEWANKA

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.