#DateForumTypeThreadPost
7127 Oct 2006 @ 01:19 PDTDatabaseReplyHelp on SET/MULTISET.. plzzWhat is the PI of the SET table, and how "non-unique" is it (typical/max rows per value)? Can you change the PI?Can you define USI? Are there any duplicate rows being eliminated during INSERT/SELEC...
7026 Oct 2006 @ 12:28 PDTToolsReplyFastExport script parametersIn UNIX, a common solution is to use a "here document" and let the shell do the substitution.Or you can dynamically build statements in a file and use .RUN to include them in your FastExport.
6925 Oct 2006 @ 02:27 PDTDatabaseReplyTDP-IDIf you are logging on other than from a mainframe, TDPID is the prefix for your Teradata hostnames (which must be set up in DNS or hosts file). Default is "dbc".If you use MyTD as the TDPID, then M...
6825 Oct 2006 @ 02:03 PDTUDAReplyHolding on to a db connection in a unix sessionYou can run BTEQ in "interactive mode", (just as you can the db2 command). But there's nothing in Teradata directly equivalent to db2's persistent background connection (db2bp).
6724 Oct 2006 @ 12:18 PDTDatabaseReplyRoundHalfwayMagUpNot aware of any "bugs". If you have any tables with PPI where the partitioning expression includes DECIMAL calculations, you need to ALTER TABLE ... REVALIDATE PRIMARY INDEX WITH {DELETE|INSERT} a...
6620 Oct 2006 @ 05:13 PDTToolsReplyCan BTEQ Prompt User for Password in ScriptsWhy not just use a "here document"?#!/bin/ksh#prompt for username and passwordecho "enter username:"read usrecho "enter password:"read passbteq
6520 Oct 2006 @ 04:14 PDTDatabaseReplySupport for generating unique sequence numbersTeradata does not have a SEQUENCE object type. Best alternative will depend on what you are doing with the values. For example, do they have to be strictly increasing with no gaps, or just unique? ...
6417 Oct 2006 @ 04:43 PDTAnalyticsReplymultiple results in CASE statementNo, the result of a CASE expression will be a single field.
6317 Oct 2006 @ 04:40 PDTUDAReplyColstats privileges???You can also collect stats if you have the INDEX right (though that can only be granted on individual tables and not at the database level).And if you are using roles, you will need to look at Role...
6210 Oct 2006 @ 12:53 PDTToolsReplyDelimited fille using FastexportFastExport does not support VARTEXT output. Depending on the size of the file, perhaps using some other utility or tool would work better for you.Or if you concatenate all the fields to a single de...
6103 Oct 2006 @ 05:23 PDTConnectivityReplyConnect to TeraDatabase using Teradata.Client.ProviderDo you have a DNS / hosts file entry for mySystemNamecop1? How many characters in the actual "mySystemName" part?
6028 Sep 2006 @ 06:09 PDTDatabaseReplyCreating a Table in a Stored ProcedureTo use these types of statements (DDL, DCL, dynamic SQL), the immediate owner of the SP must be the creator.So as you noted, if you log on as SYSDBA and CREATE PROCEDURE SYSDBA.P it works as expect...
5925 Sep 2006 @ 03:42 PDTUDAReplyUTY2806 Maximum retry limit (200) exceeded for transactionNot much detail here, but I'm guessing you have many rows in the table with the same PI value and/or the input file contains many records with the same PI value. Use of SERIALIZE ON may help, parti...
5822 Sep 2006 @ 10:14 PDTToolsReplyDBCErrorCodeElectronic copies of Teradata manuals or documentation CD images can be freely downloaded from http://www.info.ncr.comThere's also a link from teradata.com navigation bar under "Resources" "Technic...
5716 Sep 2006 @ 04:35 PDTToolsReplyRDBMS error 8018 while running fastload.If you consistently have trouble running with more than one session per node, you probably have a network issue. For example, you may see this behavior if one adapter is set to half duplex but the ...
5613 Sep 2006 @ 08:05 PDTDatabaseReplyComments within ViewsThe DBMS doesn't strip off the comments, but versions of the ODBC driver and SQL Assistant may.To work around this in SQL Assistant, run the CREATE VIEW using "Execute Parallel" (with only a single...
5512 Sep 2006 @ 12:11 PDTConnectivityReplyOLEDB Connection issueHmm... ODBC 3.3.0.8 had bad performance with encrypted logons also. Are you perhaps connecting to an old DBMS release, or a newer release with AllowDeprecatedLogons flag set?In any case, I suspect ...
5410 Sep 2006 @ 01:18 PDTConnectivityReplyOLEDB Connection issueThat's a fairly old version. TDOLEDB 1.2 was part of TTU7.1 (released in 2003). And patch level 1.2.0.4 in particular was compiled with a pre-release version of TeraGSS. You don't say what version ...
5330 Aug 2006 @ 02:50 PDTDatabaseReplyIMPORT DATA WITH USING (variable)For the export, do it in two steps.IMPORT DATA FILE = 'TEST.DAT';.EXPORT DATA FILE = 'WORK.TXT';USING ROOT (CHAR (20)), CODE (CHAR(2))SELECT '.EXPORT DATA FILE ='||:ROOT||';' (CHAR(255));SELECT 'SE...
5224 Aug 2006 @ 05:08 PDTToolsReplyDate format conversionOne possibility would be CAST(:fld AS DATE FORMAT 'DD-MMM-YY') but whether or not that does what you want depends on Century Break setting (those pesky two-digit years!). And since Century Break is...
5110 Aug 2006 @ 12:14 PDTToolsReplymload got stuckYour example shows a space in the .SYSTEM string - so the OS sees "D:\" as the (invalid) command and "paging.pl" as the argument.Windows default error handling mechanism is to display a modal dialo...
5009 Aug 2006 @ 04:40 PDTDatabaseReplyCancelling Rollback on a PPI tableYou incorrectly assumed that the request was abortable and was rolling back. ALTER is not a normal DML operation like DELETE. ALTER does not use Transient Journal, so once it begins processing you ...
4904 Aug 2006 @ 09:58 PDTDatabaseReplyConnecting between Different BoxesThere is no "built in" support for joining between two Teradata systems. In V2R6.1 you may be able to simulate this by writing an external table function to access the other system.
4804 Aug 2006 @ 09:53 PDTDatabaseReplyDate CalculationHow about justSELECT SomeDate - BirthDate YEAR(4) FROM ...Or if you want the result to be numeric rather than an "interval",CAST((SomeDate - BirthDate YEAR(4)) AS SMALLINT)
4704 Aug 2006 @ 02:27 PDTToolsReplyMLOAD RestartabilityBe careful. This works as long as MLOAD has not started the Apply phase. After that, "starting over" is problematic since MLOAD does not use Transient Journal logging (cannot be backed out). Don't ...

Pages