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

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

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

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

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

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

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

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

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?

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

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

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

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