Search results for query: *

...confirm that the number of rows displayed in the script as loaded matches the number of rows in the TERADATA table. When I perform a SELECT COUNT(*) against my ORACLE tables everyone matches save one. It always contains less rows than the script indicates were loaded. There are no...

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

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

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

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

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

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

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

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

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

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

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.

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

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

Nope = see my reply to your other post.

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.

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

...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%'); This should give you back all...

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

...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 can use either the 'two feet' or 'four feet' buttons - execute and...