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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BillDHS

  1. BillDHS

    Rank command

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

    Date Format for Import to Access

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

    Date Format for Import to Access

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

    Creating a column in a view

    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?
  5. BillDHS

    Teradata OLEDB 1.2.04 failure

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

    Performance

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

    Available User Space

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

    date runction

    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));
  9. BillDHS

    BOEXI Session Management

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

    Loading flat files to Teradata

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

    Amps and Vprocs

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

    Need to find a maximum or minimum value?

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

    Reg Expr searches is really slow!

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

    how to insert a text file or a picture in a cloumn

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

    how to insert a text file or a picture in a cloumn

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

Part and Inventory Search

Back
Top