#DateForumTypeThreadPost
22123 Nov 2007 @ 09:50 PSTUDAReplyExecute Teradata Stored Procedure From MS-AccessCreate a "SQL-Specific" passthru query containing the CALL statement. Remember to set the ReturnsRecords property to No (unless you are running TD12.0 or later).
22023 Nov 2007 @ 09:40 PSTConnectivityReplyError In Connecting Teradata Pmon8071 Deprecated logons are not allowed by administrator. Upgrade client software to latest version.Your TeraGSS and/or CLIv2 components are back-level. And possibly PMON as well. Uninstall the old ...
21920 Nov 2007 @ 10:30 PSTDatabaseReplyHow to cast the timestampOn second thought, comparing TIME fields can be tricky if the current "session time zone offset" is nonzero. In general, you are probably more likely to get the results you expect if you CAST to CH...
21820 Nov 2007 @ 10:04 PSTDatabaseReplyHow to cast the timestampwhere cast(start_tmstp as time(0)) between time'00:00:00' and time'04:59:59'
21720 Nov 2007 @ 10:25 PSTAnalyticsReplyRegarding Space Management In TeradataNo. As Dieter indicated, you get the "No more room in database" error when the database CurrentPerm on any AMP reaches the MaxPerm for that AMP. None of your three queries is testing that condition...
21620 Nov 2007 @ 09:58 PSTAnalyticsReplyAmp SharingWithin a single Teradata system, all database nodes have the same OS. And all user tables are hash-distributed across all the AMPs. Teradata does not directly support a query running on one system ...
21519 Nov 2007 @ 06:13 PSTDatabaseReplyInserting current_timestamp value into timestamp(0) columnCURRENT_TIMESTAMP has datatype "TIMESTAMP(6) WITH TIME ZONE".Teradata is willing to ignore the timezone offset in an assignment, but not to truncate nonzero fractional seconds. So just use CURRENT_...
21417 Nov 2007 @ 12:07 PSTToolsReplyBTEQThe above explanation is backwards.Single-statement request means each SQL statement is submitted to the DBMS as an independent statement (and processed in sequence). Multi-statement request submit...
21313 Nov 2007 @ 11:59 PSTToolsReplyFastExport - Unloading and matching with Cobol datatypesSMALLINT will be exported as two-byte binary - COBOL S9(4) COMP - by default.If you want it to be packed decimal in the file, you can CAST to DECIMAL in the FastExport.
21206 Nov 2007 @ 01:49 PSTToolsReplyOLEDB utilityIn addition to the Teradata OLEDB Provider, there is an "OLEDB Access Module" that interfaces the Teradata utilities like FastExport and FastLoad with an OLEDB application. See the Access Module Re...
21103 Nov 2007 @ 08:10 PDTDatabaseReplyNeed PPBMAIN Precompiler HelpYou don't need to have a Teradata system connected to the mainframe where you do the compile, but you do have to start a TDP on that system. The TDP does not need to ATTACH or START any IFPs, it ju...
21003 Nov 2007 @ 07:22 PDTAnalyticsReplyspool variation questionMy guess: Query B benefits from use of the aggregate cache. The degree of benefit can depend on how much memory is available for this query and in what order the rows are aggregated. Other queries ...
20930 Oct 2007 @ 11:14 PDTToolsReplyCode = 2644 No more room in databaseSince your "wasted" space is several orders of magnitude larger than the "actual" space to hold the data, I would consider this bad and worthy of investigation. In particular, review the PI choices.
20821 Oct 2007 @ 07:45 PDTToolsReplyLoading a file created in FastExport using fastload or btqmainThey are not "filler" they are "presence indicators" Default for FastExport is MODE INDICATOR. That means the record is prefixed with enough bytes to allow one bit for each column to indicate NULL ...
20719 Oct 2007 @ 09:46 PDTDatabaseReplyFastload Fixed Length ProblemFor an input VARCHAR field, FastLoad requires a two-byte binary length followed by the data. If the entire record consists of delimited text, FastLoad VARTEXT file format can do the conversion. For...
20615 Oct 2007 @ 03:31 PDTToolsReplyIGNORE DUPLICATE INSERT ROWSFastLoad ALWAYS quietly eliminates duplicate rows (even when the target table is defined as MULTISET). So there is no command to explicitly request this behavior.
20502 Oct 2007 @ 09:57 PDTDatabaseReplyProblem using the . (dot) commands with the fastloadThose are BTEQ commands. FastLoad provides no conditional execution. You could run a BTEQ step followed by a FastLoad step.
20402 Oct 2007 @ 09:49 PDTConnectivityReplyUDF creation using ODBC - V2R6In V2R6, Teradata does not support SQL UDFs. They must be written in C/C++ and may not contain embedded SQL statements.
20302 Oct 2007 @ 09:41 PDTConnectivityReplyOLE Load module updateInstall (or uninstall/reinstall) appropriate level of TeraGSS. Also double check TDICU while you're at it. These common components are required prerequisites for current drivers.
20230 Sep 2007 @ 08:12 PDTToolsReplyAll-Amp backup and Cluster BackupBackup is parallel on the Teradata side, but each ARCMAIN writes a single backup file on the client. If you have multiple backup devices available, you generally want to run multiple ARCMAINs in pa...
20123 Sep 2007 @ 01:56 PDTToolsReplyArcmain Question : Rollforward works only with RESTORE ?You must first COPY DATA TABLES, then COPY JOURNAL TABLES and specify APPLY TO clause so ARC can change the internal IDs of the journal records to match the copied tables.
20019 Sep 2007 @ 09:23 PDTDatabaseReplycollect stats programatically without use of dynamic SQL?COLLECT STATS is not considered "dynamic SQL", but it is considered DDL so is subject to additional authorization checking - which is what DBC.SysExecSQL does and how it figures into the picture.Bu...
19911 Sep 2007 @ 03:57 PDTDatabaseReplycollect stats programatically without use of dynamic SQL?Depends on what "programatically" and "dynamic" mean to you. I'm assuming that it's specifically the use of dbc.SysExecSQL in a stored procedure that you are forbidden from using? What are you tryi...
19811 Sep 2007 @ 03:28 PDTDatabaseReplyHow to determine the character-set of a Teradata Database?There can be multiple internal (server) and external (client) character sets in use at the same time. If you are referring to the character set used to store names of objects in dictionary tables, ...
19716 Aug 2007 @ 01:14 PDTConnectivityReplyTeradata AIX ODBC Data SourceOK. If it's really v3.05 then you DO need the TeraGSS library in LIBPATH after all. But you should install the latest EFix level of the driver and shared libraries.

Pages