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: *

  • Users: RanD
  • Order by date
  1. RanD

    insert / select not getting all the rows

    I'm hoping someone more familiar with ORACLE than I am (noob) can tell me what might be going wrong here. The setup: I'm trying to bring data from a TERADATA system to an ORACLE system via SQL Server's DTS data pump scripts. There are 8 tables that I'm loading on the ORACLE system. There are 8...
  2. RanD

    problems converting teradata to ORACLE tbls

    Hello - I'm trying to take some information from TERADATA to ORACLE. The TERADATA data type I'm trying to take to ORACLE is as follows: IndexStatistics VARBYTE(16383) FORMAT 'X(255)', I put this into a staging table in ORACLE as follows: IndexStatistics LONG RAW, while this...
  3. RanD

    Help moving forward with demo please

    As a matter of fact, I can login using BTEQ/BTEQWin. Can't get in using ODBC connect and either QMan or WinDDI. I have 'do not try to resolve IP address' checked in the ODBC configuration for dbc and for demo1099. IP address is 127.0.0.1 (localhost) The error I get when trying to connect...
  4. RanD

    Help moving forward with demo please

    Thanks for the help on the previous thread about getting the demo working on WindowsXP. I took the advice after a de-install and cleaner install. I'm able to get the database working, but cannot get Qman or WinDDI to connect. Here is what I have accomplished so far... Start Teradata 'net...
  5. RanD

    Anyone know how to get the demo working??

    Here's a new error message - I get this after net start recond, which starts the initiator successfully, 0 WSA E Unknown socket error. I got this from QMan Oh well, back to the drawing board
  6. RanD

    Anyone know how to get the demo working??

    Yes - I did all the things in the instructions, including copying PDELIB.DLL into tdat\Lpde\bin\pdelib.dll - effectively overwriting the file.
  7. RanD

    Anyone know how to get the demo working??

    Hello all - I have the 4.1 demo cd. I want to install it on a laptop running WindowsXP Pro, to use in teaching, etc. I followed the FAQ directions from NCR's website for installing this demo on this type of machine. The installation went fine - no errors reported at all. However, the...
  8. RanD

    SQL query optimization

    As you can deduce from the responses, depending on your table structure (specifically the indices on the tables and the implicit relations between the tables) and you query, the optimizer develops the most efficient plan. If you structure the tables properly and the relationship properly the...
  9. RanD

    Specify default values for NULL values in target fields..

    To amplify on COALESCE - Where I'm currently contracting the customer has multiple strings from various sources that represent NULLs of different data types. We can get NULLs, or strings for VARCHAR fields for example. The direct example that answers your question would be COALESCE(column...
  10. RanD

    11001 HOST NOT FOUND ERROR

    Are you certain that your hosts file is properly configured? It sounds to me like the error message is pointing you to the hosts file to resolve the problem. I won't ask you to post the IP address and/or your hosts file for obvious reasons though ;-) Regards Randy Volters Certified Teradata...
  11. RanD

    query teradata and oracle DB with queryman at the same time

    I'm sure (almost) some QMan developer will come along behind me and negate what I'm going to say here... Answer is 'no'. Reason. You connect to one machine (data source) at a time with QMan. I cannot even make simultaneous connections to 2 Teradata machines with QMan, let alone an ORACLE...
  12. RanD

    Teradata slows down at end of load ??!!

    Thanks, that was not the problem. . . We determined that the problem was the indexing strategy. Knew it was dicey, did the best we could, that wasn't good enough apparently.
  13. RanD

    Teradata slows down at end of load ??!!

    We are restating a moderately large table (250 M rows). Plan has been optimized. Insert/Selecting into empty table, matching index(es). We were loading about 10M rows every 5 minutes up to the last 45M rows, then the system started slowing down remarkably. Last count showed only 2M rows loaded...
  14. RanD

    Teradata Demo On XP / W2K Service pack 3

    Yes, I am running the client software on the same machine (laptop) as the database. Yes, I absolutely agree with you that the documentation is poor. (Pretty much the standard with vendors these days ) Thanks for these instructions, much clearer. I will give this a try tonight, let you know...
  15. RanD

    Teradata Demo on WindowsXP. . . anyone know how to do it?

    Nope = see my reply to your other post.
  16. RanD

    Teradata Demo On XP / W2K Service pack 3

    Nope - I have the current WXP Pro all patched and updated from MSFT. Loaded the files from this link and did the workaround. It does not solve the problem.
  17. RanD

    SQL insert long time!!!!!

    what is the ddl of the tables involved? What is the SQL you ar using to do the insert? have you collected stats? give us more info and we can be more helpful ;-)
  18. RanD

    NUMERIC - sql equivalent?

    I've given it further thought... I'm assuming from your original question you don't have goofy alphanumerics in your rows. You might try this on the CHAR column... SELECT * FROM TABLENAME WHERE COLUMNNAME LIKE ALL ('%0%', '%1%', '%2%', '%3%', '%4%', '%5%', '%6%', '%7%', '%8%', '%9%', '%0%')...
  19. RanD

    NUMERIC - sql equivalent?

    By definition, if the attribute is defined as CHAR or VARCHAR, all data in all rows in that column are that datatype. There is no easy function that I am aware of that would scan all the characters in a column and return a count (or the actual column value(s) ) for non-numeric values. You...
  20. RanD

    Multi Statement Request

    Yes. QMan uses ODBC. As stated previously in this thread, (but clarified here with example), finish the first statement with a ';' on the next line immediately followed by the second statement, for example... sel count(*) from tableA ; sel count(*) from tableB ; sel count(*) from tableC ; You...

Part and Inventory Search

Back
Top