#DateForumTypeThreadPost
12109 Feb 2007 @ 06:00 PSTToolsReplyFastload - cannot open fileAn unqualified filename should look in current working directory, or you can supply the full pathname. Use "" around the name if it contains blanks or special characters:DEFINE FILE="C:\Documents a...
12009 Feb 2007 @ 05:09 PSTConnectivityReplySetting up linked server: SQL Server 2005 > Teradata via OLEDBDisclaimer: I haven't tried linking with SQL Server 2005 so I could be off base here, but...Can the driver resolve the name you put in the Data Source field to one of the Teradata system's IP addre...
11928 Jan 2007 @ 01:09 PSTTrainingReplyNumber Data TypeTeradata V2R6.2 (not 6.1.x) supports BIGINT and DECIMAL(38,x) datatypes. Never use FLOAT unless approximate values are acceptable.In earlier releases, possible workarounds include using a smaller f...
11827 Jan 2007 @ 10:10 PSTToolsReplyMissing rows from file using Fast ExportMost likely one or more columns in the "missing" rows is NULL. Anything concatenated with NULL is also NULL; if you want NULLs translated to "empty string" you have to say so, e.g.... COALESCE(TRIM...
11723 Jan 2007 @ 10:22 PSTConnectivityReply.Net Data Provider for TearadataOn this site (Teradata.com) under Resources, Drivershttp://www.teradata.com/t/page/130536
11623 Jan 2007 @ 12:15 PSTToolsReplyLoading space into a Decimal(15,2) columnYou can't use NULLIF function in SQL because that won't be evaluated until after the bad data has been sent to Teradata. Did you try using MLOAD NULLIF processing on the client side, something like...
11512 Jan 2007 @ 01:15 PSTConnectivityReplyCLI Connect TypeConnect Type should be 'C'.Perhaps you need to download a newer version of the manual; the TTU8.1 version mentions this several places.
11410 Jan 2007 @ 12:25 PSTConnectivityReply.Net Data Provider for Tearadata connection problemIs the working ODBC application getting User ID and Password from the DSN, or is it actually in the connection string and just not shown here for security reasons?If the Password (or User ID) conta...
11310 Jan 2007 @ 11:53 PSTUDAReplyUntranslatable Text in column will not work with aggregate functions within case statementPerhaps add a condition using TRANSLATE_CHK function, such asSelect CASE WHEN PH_AREA_CD IS NULL THEN '?' WHEN TRANSLATE_CHK(PH_AREA_CD USING LATIN_TO_UNICODE) = 0 THEN TRIM(PH_AREA_CD) ELSE...
11207 Jan 2007 @ 09:34 PSTConnectivityReplyCLI access to TeraData from MVSFrom the Teradata Messages manual:CLI0157 CLI2 Parameter module HSHSPB unavailableExplanation: This error indicates that the CLI2 parameter block module was not link-edited into the application and...
11103 Jan 2007 @ 08:21 PSTTrainingReplyTeradata BASICS examination..!!Teradata Certified Professional Program's stated policy remains to develop exams for "every other" major release. There were no V2R4 exams and there are no plans for V2R6 exams.New exams won't be a...
11002 Jan 2007 @ 11:08 PSTDatabaseReplyUnicode set at server levelAs far as internal server representation: Teradata LATIN always occupies one byte per character; Teradata UNICODE two bytes per character.
10902 Jan 2007 @ 10:52 PSTDatabaseReplyEXTRACT FunctionAdding an integer to a Timestamp is not supported. Use an "interval" data type, e.g. current_time + interval '10' second
10820 Dec 2006 @ 12:32 PSTDatabaseReplyTransfer a table to a different databaseNote that "Copy Objects" in Teradata Administrator only copies the definition (in effect does SHOW on one system and submits the resulting DDL on the other). It does not copy the data. There are ma...
10720 Dec 2006 @ 12:26 PSTConnectivityReplyTable Functions and other RDBMSAt least in principle, yes, it could be done. If your Teradata nodes are running MP-RAS UNIX, though, it may be difficult to obtain suitable drivers or connection libraries for the other DBMS.
10613 Dec 2006 @ 05:54 PSTToolsReplyBTEQ: Conditional Execution of SQL StatementsBTEQ does not permit you to reference the COUNT(*) value in your script. But you could use .IF ACTIVITYCOUNT test if you modify the query: SELECT COUNT(*) FROM MyTable HAVING COUNT(*) > 0;That way...
10512 Dec 2006 @ 11:14 PSTConnectivityReplyODBC connection ErrorPerhaps uninstall did not fully remove the old version. There is a Teradata @ Your Service / SupportLink knowledge article detailing manual uninstall (too long to quote here).Also be sure you have ...
10412 Dec 2006 @ 11:08 PSTToolsReplyuty4015 error encountered - uploading text file thru multiloadThe delimiter must be a single character. And since you are on Windows, each record (including the last) must end with CR/LF combination.
10311 Dec 2006 @ 10:46 PSTToolsReplyMload error in mainframeWell, as the message says: There is a syntax error in the SQL statement. (The error occurs prior to the portion of the text you pasted into your original post.)
10211 Dec 2006 @ 12:35 PSTDatabaseReplyDBC.Software_Event_LogTeradata for Windows (including the demo), logs messages such as these in the Windows Event Log rather than DBC.Software_Event_Log. Use the Windows Event Viewer to see them.
10111 Dec 2006 @ 12:19 PSTDatabaseReplyData type for Number(22)Large Decimal is only available in V2R6.2 or later.In earlier releases you cannot have more than 18 digits precision in numeric fields. FLOAT has much larger range, but less precision.
10011 Dec 2006 @ 12:15 PSTDatabaseReplyFloating Point RepresentationFLOAT has the advantage of being able to represent a very wide range of values; the disadvantage is that the precision is limited. Always consider FLOAT to be an approximation.Approximation is typi...
9909 Dec 2006 @ 04:20 PSTToolsReplyViewing Fastload ErrorsThere should not be a "dummy field" in the USING, just the VARCHAR fields you had in your FastLoad DEFINEs. (Anything BTEQ adds to the records in EXPORT will be handled automatically on IMPORT.)
9809 Dec 2006 @ 04:07 PSTAnalyticsReplyinformation regarding Soft RIThe optimizer will assume RI constraints have been enforced. Pro: You may get join elimination or other query plan improvements. Con: If data does not actually conform to the declared constraints, ...
9708 Dec 2006 @ 12:13 PSTToolsReplyCLI error in mainframe Mload jobIt appears you said ".LOGON LOGON TDP1/,"?Use either .LOGON or LOGON but not both ;-) Logging on from a mainframe without a username and password requires that your TDP have appropriate user exit(...

Pages