#DateForumTypeThreadPost
43009 Oct 2008 @ 01:34 PDTToolsReplyMultiload ErrorThis kind of error normally pops up when the job had errored out once (due to other various reasons) and gets resubmitted.load utils making use of FIFO always require a full cleanup and start from ...
42907 Oct 2008 @ 09:49 PDTConnectivityReplyCreate UDF with SQL codeYou can accomplish the same via normal joins without the necessity to have a UDF.SELECT A.*, SCLI.F00H12AL(A.PCodBk, A.PCODFT , A.PCODLAN )FROM Acan be re-written as ...SELECT A.*, B.DESCRFROM A, T...
42806 Oct 2008 @ 11:32 PDTDatabaseReplyRandom Competition DrawsYou can use recursion (if there's no max limit) or a lookup table if there's a max limit on the number of entries (even calendar would do).
42706 Oct 2008 @ 09:38 PDTToolsReplyTrimspool(Oracle) Equivalent in TeradataYou don't mention what utility you are using to export data (bteq ?)Try using fast export in VARTEXT mode.
42606 Oct 2008 @ 09:34 PDTUDAReplyQuery PerformanceIt seems the objective is to get "distinct" values of certain columns. In which case you might want to try using Group by / distinct to achieve the same. One may be better than the other depending ...
42517 Jun 2008 @ 02:09 PDTToolsReplyunable to run the bteq script on sun Unix os.That's normally given by unix if the user does not have execute permission on the executable... so check the permissions on the bteq executable and make sure the unix user id you are using has exec...
42413 Jun 2008 @ 06:12 PDTDatabaseReplyMoving data between 2 servers in Teradatayou have to either archive and copy. Or fastexport/fastload
42313 Jun 2008 @ 06:07 PDTDatabaseReplyVERTICAL STRING CONCATENATIONIt kind of gets ugly, and is sort of a cross join in disguise ... I wouldn't sign my name on performance ;) ... but is there for academic purposes..WITH RECURSIVE MYREC(STE, CITY, LVL)AS(SELECT ST,...
42213 Jun 2008 @ 05:53 PDTToolsReplyBTEQ import problemThe casting syntax is not correct, actually you don't need to cast ....USINGOutlet_ID (varchar(10)),Opened (varchar(10)),Upgraded (varchar(10))insert into storedt values(:Outlet_ID,:Opened,:Upgraded);
42113 Jun 2008 @ 04:56 PDTToolsReplyMLOAD script error.It could be happening because the format of your input data field format is not matching what is expected by teradata. You can experiment by adding a formating clause in your insert to accurately r...
42013 Jun 2008 @ 02:59 PDTUDAReplyDatg Warehouse LoadingIf the row count is small (which I presume would be the case since the feed is generated every couple of minutes), then tpump is the best option. As far as filenames are concerned, normally this ac...
41913 Jun 2008 @ 02:25 PDTToolsReplyMLOAD script error.you have to use VARCHAR in the layout instead of CHAR when using VARTEXT as the format. your tables columns could be still CHAR only the layout has to be updated.
41813 Jun 2008 @ 12:36 PDTDatabaseReplyrowkeyrowkey is the combination of partition# plus the rowid. (just like how rowid is the combination of rowhash and uniqueness value)
41713 Jun 2008 @ 12:20 PDTDatabaseReplyWhy renaming time varies???I am guessing that you meant the RENAME is taking a long time.... Did you check for blocks in PMON/Teradata manager ? That's a nice place to look as to what is happening to the SQL while its under ...
41612 Jun 2008 @ 02:46 PDTDatabaseReplywhat is the easiest way to change column nameyou can do an ALTER TABLE mytbl RENAME COLUMN oldnme TO newnme;However there are restrictions, like you can't rename a column if it's part of an index (for PI you will have to drop and recreate the...
41512 Jun 2008 @ 02:42 PDTToolsReplyMLOAD DELETE TASK always **** 20:40:23 UTY0815 MLOAD session(s) connected: ?I think it has to do with the fact that all the records (from the input file) have to be duplicated in all the amps (since the delete is not based on the PI).
41412 Jun 2008 @ 01:47 PDTDatabaseReplyFastexport: a variable as name of my fileYou may want to avoid using '/' and ':' in the date as certain filesystems will treat them as special characters.Also try putting the variables in the shell script and not in the .profile where it'...
41312 Jun 2008 @ 01:39 PDTDatabaseReplyBackup/Recovery of DBQLThe PMCP package consists of a bunch of DBs and user ids that you create in the system, a bunch of tables that sort of reflects the "log" tables in DBC plus some extras.. views to manipulate these ...
41212 Jun 2008 @ 12:52 PDTToolsReplyOracle to teradata using informaticaNot really my field, but I remember some folks getting a named fifo (aka pipe) to work with informatica so that it didn't create flat files ...
41112 Jun 2008 @ 12:49 PDTConnectivityReplySecure Database Connection from JDBC to TeraDataStarting V2R6.0 encryption is supported via the ENCRYPTDATA jdbc URL parameter (you can look up the jdbc manual for details)... You shouldn't need any more jars than the JDBC ones...
41012 Jun 2008 @ 12:37 PDTToolsReplyFexp Character translation errorYou would want to check your table definitions to see if there are any Unicode columns. Chances are that there are some ... in which case exporting as ascii may not be a good idea.
40902 Jun 2008 @ 08:33 PDTToolsReplyARCMAIN Error : Name not in HOSTS file or names databaseTeradata administrator and SQL Assistant are ODBC based client tools and connect using the IP Address/DNS names mentioned in the DSN settings. The CLI utilities on the other hand requires a TDPID/I...
40801 Jun 2008 @ 12:05 PDTDatabaseReplyFew basic queriesThis comes under recurisve query in Teradata.WITH RECURSIVE RECTBL(ENO, ENME, MGNO)AS( SELECT EMPNO, ENAME, MGR FROM EMP WHERE EMPNO = 5126 UNION ALL SELECT EMPNO, ENAME, MGR FROM EMP INNER J...
40723 May 2008 @ 02:05 PDTToolsReplyPassing values/variables to a Multiload script from unixYou can use the .ACCEPT command to read an environment variable... lookup the multi load manual for syntax and more details.
40623 May 2008 @ 01:37 PDTDatabaseReplyIdentify User - Deleted RecordsIf your shop maintains the DBQL information in PMCP databases, you might find stuff there for the past days... you should be able to find it from PMCPINFO.DBQL* views ...

Pages