Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. WILLIEWANKA

    ODBC Parser problems....

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

    Running application as another user

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

    Line Comment

    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)...
  4. WILLIEWANKA

    Disk Space by Table

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

    Position in Integer

    Thanks, the logic makes sense now.
  6. WILLIEWANKA

    Position in Integer

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

    Position in Integer

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

    Fast Export (fexport) performance

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

    Load two files to two different tables in one FL script

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

    Preventing Tables from being dropped

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

    Maintain 1 session/connection with ADO

    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?
  12. WILLIEWANKA

    Maintain 1 session/connection with ADO

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

    Maintain 1 session/connection with ADO

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

    Maintain 1 session/connection with ADO

    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;
  15. WILLIEWANKA

    Maintain 1 session/connection with ADO

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

    Maintain 1 session/connection with ADO

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

    Maintain 1 session/connection with ADO

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

    How to compare if two sets are equal.

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

    Using index and not full table scan

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

    Using index and not full table scan

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

Part and Inventory Search

Back
Top