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

    Position in Integer

    Why does the following statement return 3 instead of 1? select index(123456,1);
  5. 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...
  6. 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...
  7. 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...
  8. 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) =...
  9. WILLIEWANKA

    Load two files to two different tables in one FL script

    Is it possible? And if so, how? Here is my code, and my log file sessions 1; errlimit 25; logon duh; DATABASE ud107; DROP TABLE ERROR_1; DROP TABLE ERROR_2; DROP TABLE ERROR_3; DROP TABLE ERROR_4; DROP TABLE hist_offer; CREATE TABLE hist_offer( CALL_ID INTEGER, OFR_TYPE_CD CHAR(1)...
  10. WILLIEWANKA

    Table size, database space and archiving

    I am currently part of a group of users within a database. We have a limited amount of space in which to create and store our tables. Is there any way we can archive or compress an entire table to save some space? I have evaluated using COMPRESS on columns with only a couple of distinct values...
  11. WILLIEWANKA

    Channel Attached or Network Attached

    1. What is the difference between channel attached systems and network attached systems? I work on an XP workstation using Queryman and BTEQWin. I also connect to a unix box using Attachmate and run bteq in a unix environment. Would Queryman and BTEQWin be considered Network attached, and unix...
  12. WILLIEWANKA

    Reportwide

    I know there had been mention of this feature for BTEQ a couple of years ago, but I have not seen it in any of the documentation yet for V2R5. Has it been implemented, and if so, is there any resource available for syntax and details?
  13. WILLIEWANKA

    Single ODBC connection with multiple pass throughs

    I'm trying to create a GUI for business users to create reports using Teradata as the database. It will use a series of pass through queries to create the tables need for the final report. I've gotten the interface set up to select the required tables and create the pass through queries. The...
  14. WILLIEWANKA

    Update subquery problem

    Hello all, i'm trying to update a table using a case statement from another table. Table A (the table being updated) contains four columns - act_nbr, tran_date, tran_amount, and cycle_month. This is a SET table, so there are no duplicate rows. The primary key is act_nbr, tran_date, tran_amount...
  15. WILLIEWANKA

    Teradata user platforms

    I'm about to take a class on Unix, and I had some questions relating to teradata. I'm not very familiar with Unix, but I do know that our TD runs on MP-RAS. Are there advantages to using Unix over Windows to run queries through the database? Is there a way for a user to log into the TD Unix...
  16. WILLIEWANKA

    Fastload date format/default problem

    I've got a delimited text file with some fields being 8 character date fields (mm/dd/yy). I've set the create table statement to DATE FORMAT 'MM/DD/YY' and it loads fine. The problem is that it dafaults the century to 1900 instead of 2000. So if I have a date of 09/10/03, it will load it as...

Part and Inventory Search

Back
Top