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 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 TheTeradataKid
-
ROUNDUP Function
-- takes a number and rounds to the nearest .05 select (cast ( X / .5 as decimal (5,1))) * .5 X = variable- TheTeradataKid
- Post #3
- Forum: NCR: Teradata
-
Pulling Random Records
Thank You for the clarification rohitrevo.- TheTeradataKid
- Post #7
- Forum: NCR: Teradata
-
Pulling Random Records
The sample 5 example will give you the first 5 rows of the table, not the randomness that you are looking for.- TheTeradataKid
- Post #3
- Forum: NCR: Teradata
-
Multiload Error : 2554: Inconsistent situation occurs in restart...
CALL GLOBAL SUPPORT!- TheTeradataKid
- Post #5
- Forum: NCR: Teradata
-
Multiload Error : 2554: Inconsistent situation occurs in restart...
Multi load has restart capabilities and you have to go to bteq and issue the command release mload dbase.tablename; This should do it.- TheTeradataKid
- Post #4
- Forum: NCR: Teradata
-
batch scripts to run batch scripts in bteq or queryman
The only thing that I could suggest is to paste your code for both scripts into one and run it.- TheTeradataKid
- Post #8
- Forum: NCR: Teradata
-
inserting
It is faster because of the Fastload utility loading the data in blocks. The updates and inserts does the operations row at a time resulting on full htable scans if there are any conditional variables to meet. The Multiload utility is very fast also and can hande conditions and redefinitions...- TheTeradataKid
- Post #3
- Forum: NCR: Teradata
-
