Recent content by BillDHS

I am always amazed from this same type questions coming up frequently at organizations that provide software without access to tech docs that most likely is available through Vendor support links. Here is online tech docs w/search: http://www.info.ncr.com/Gen-Srch/eOnLine-Srch.cfm Here is...

Access does have a current_date function, DATE(). The following was put in the Criteria Row of the query design wizard: >=Date()-30.

Use the current date and subtract 1, you don't need a parameterized query: Select * from Tab1 Where Tab1.datecol = Current_date - 1;

This works fine for me: select 'Help me' as Column_B; RESULTS: Column_B Help me Where is your FROM clause for the source of COULMN_A? What is the error?

If you updated rather than remove/install, you may want to do try a new installation after removing the current version first.

You need to be much more specific. Always the same time? Always the same table? What else is accessing TD during the load? Empty table or append? Where is the data coming from? LAN/WAN traffic?

We are considering an Oracle 10g RAC configuration for a data warehouse. In order to determine the appropriate size, I need to know the amount of admin and temp space to reserve as system resources. For example in a 10 terabyte data warehouse, RAID 1 would take 5 TB, how much space would...

Unless something has change, ODBC does not accept format statements. If you are using ODBC connectivity you will also need to CAST the date to maintain the format: select CAST(current_date (format'yyyy-mmm-dd')as char(11));

First I want to inform you that I am the Warehouse Administrator and not the BOEXI Administrator. There are some anomolies when running reports against Teradata through ODBC and I would like to have your insite. When running a report using a web browser and BOEXI as the server, it will open a...

Your question is very vague, but if the poulation identifier is an element of the input file, I don't know why you would have to do the work over.

AMPs are a type of VPROC, the other being a PE (parsing engine). VPROCs, AMPs and PEs are all virtual, created by software. PE do the query parsing and session control, AMP perform the query steps.

You could union the values of the columns, then select the max value, then go back and retrieve the base row. Whether this is quick or easy remains to be seen. select t3.key, t3.cola, t3.colb, t3.colc,... from tablea t3, (select max(t1.value) from (Select colavalue from...

Unless Datbasename is a varchar field I don't think you need the TRIM function. If that is true removing it should help the speed.

Search the Teradata Forum at http://www.teradataforum.com/index.htm

What have you tried so far? Why isn't it just a VARCHAR attribute?