430 | 09 Oct 2008 @ 01:34 PDT | Tools | Reply | Multiload Error | This 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 ... |
429 | 07 Oct 2008 @ 09:49 PDT | Connectivity | Reply | Create UDF with SQL code | You 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... |
428 | 06 Oct 2008 @ 11:32 PDT | Database | Reply | Random Competition Draws | You 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). |
427 | 06 Oct 2008 @ 09:38 PDT | Tools | Reply | Trimspool(Oracle) Equivalent in Teradata | You don't mention what utility you are using to export data (bteq ?)Try using fast export in VARTEXT mode. |
426 | 06 Oct 2008 @ 09:34 PDT | UDA | Reply | Query Performance | It 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 ... |
425 | 17 Jun 2008 @ 02:09 PDT | Tools | Reply | unable 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... |
424 | 13 Jun 2008 @ 06:12 PDT | Database | Reply | Moving data between 2 servers in Teradata | you have to either archive and copy. Or fastexport/fastload |
423 | 13 Jun 2008 @ 06:07 PDT | Database | Reply | VERTICAL STRING CONCATENATION | It 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,... |
422 | 13 Jun 2008 @ 05:53 PDT | Tools | Reply | BTEQ import problem | The 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); |
421 | 13 Jun 2008 @ 04:56 PDT | Tools | Reply | MLOAD 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... |
420 | 13 Jun 2008 @ 02:59 PDT | UDA | Reply | Datg Warehouse Loading | If 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... |
419 | 13 Jun 2008 @ 02:25 PDT | Tools | Reply | MLOAD 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. |
418 | 13 Jun 2008 @ 12:36 PDT | Database | Reply | rowkey | rowkey is the combination of partition# plus the rowid. (just like how rowid is the combination of rowhash and uniqueness value) |
417 | 13 Jun 2008 @ 12:20 PDT | Database | Reply | Why 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 ... |
416 | 12 Jun 2008 @ 02:46 PDT | Database | Reply | what is the easiest way to change column name | you 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... |
415 | 12 Jun 2008 @ 02:42 PDT | Tools | Reply | MLOAD 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). |
414 | 12 Jun 2008 @ 01:47 PDT | Database | Reply | Fastexport: a variable as name of my file | You 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'... |
413 | 12 Jun 2008 @ 01:39 PDT | Database | Reply | Backup/Recovery of DBQL | The 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 ... |
412 | 12 Jun 2008 @ 12:52 PDT | Tools | Reply | Oracle to teradata using informatica | Not 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 ... |
411 | 12 Jun 2008 @ 12:49 PDT | Connectivity | Reply | Secure Database Connection from JDBC to TeraData | Starting 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... |
410 | 12 Jun 2008 @ 12:37 PDT | Tools | Reply | Fexp Character translation error | You 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. |
409 | 02 Jun 2008 @ 08:33 PDT | Tools | Reply | ARCMAIN Error : Name not in HOSTS file or names database | Teradata 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... |
408 | 01 Jun 2008 @ 12:05 PDT | Database | Reply | Few basic queries | This 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... |
407 | 23 May 2008 @ 02:05 PDT | Tools | Reply | Passing values/variables to a Multiload script from unix | You can use the .ACCEPT command to read an environment variable... lookup the multi load manual for syntax and more details. |
406 | 23 May 2008 @ 01:37 PDT | Database | Reply | Identify User - Deleted Records | If 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 ... |