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!
-
Congratulations SkipVought 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: teradataman
- Order by date
-
Microsoft Access to Teradata via ODBC
Are you linking to the table or using a passthrough query as the data source? The message you see is a common Access 'feature' and has nothing to do with the ODBC/DBMS version. It ususally occurs when the virtual copy in memory is out of sync with the physical table, whether it be local or...- teradataman
- Post #3
- Forum: NCR: Teradata
-
Limit no. of rows returned...
There is no such thing as 'first' in the Teradata world. You can limit the result set to 100 rows by using 'SAMPLE 100' at the end of your SELECT. It's up to you what these 100 rows are based on the conditions that you specify.- teradataman
- Post #2
- Forum: NCR: Teradata
-
How to get first rows
Or even: SELECT 'ERROR - NO ROWS IN TAB1' WHERE 0 = (SELECT COUNT(*) FROM TAB1) ; .IF ACTIVITYCOUNT = 1 THEN .QUIT 16- teradataman
- Post #3
- Forum: NCR: Teradata
-
Phantom Spool
Good answer - it seems that there is no known recurring cause, but that it does happen quite a lot. We run the utility that sorts it out.- teradataman
- Post #12
- Forum: NCR: Teradata
-
Select First N rows
"SAMPLE XXX" (rows) or "SAMPLE 0.1" (= 10%) after the normal SELECT statement is the way to go. Using a RETLIMIT value in BTEQ simply truncates the result set, and it can't be used in Queryman anyway. To see the effect of SAMPLE, or any other technique, on the parser simply...- teradataman
- Post #8
- Forum: NCR: Teradata
