#DateForumTypeThreadPost
18719 Jan 2012 @ 07:02 PSTGeneralReplypermanent space availability,space,permanent space The space used for macros, views, and triggers definitions is NOT part of the the owner PERM space. From the docco: A database or user with no PERM space can still own views, macros,...
18618 Jan 2012 @ 12:18 PSTGeneralReplyGet returnCode of Mload from Shell Script Vinay: mload < PostCampaigns.mload echo $? should show the errorcode. HTH. Cheers. Carlos.  
18517 Jan 2012 @ 12:17 PSTToolsReplyVerification process after updating table Hi: Take a look at ACTIVITYCOUNT keyword in the bteq reference. HTH. Cheers. Carlos.
18416 Jan 2012 @ 03:22 PSTToolsReplyODBC architecture error for TPT Oracle Irfan: If your Oracle 11 sits on a 32bit OS you must use the 32 bit version ODBC dll (odbcad32.exe?). I think you can do it easily deleting the odbc connection you created with the Data ...
18312 Jan 2012 @ 02:46 PSTDatabaseReplyCheck row is Numeric or not Hi. I provided a solution for a colleague who needed to check whether a string was 'only numbers' or not. It's explained here: http://carlosal.wordpress.com/2009/12/02/on...
18212 Jan 2012 @ 12:28 PSTDatabaseReplyCan't create a recursive view when specifying the database Mark: Yep. The reference from the 'UNION ALL' part of the query to the (not yet) created view cannot contain the dbname, because the view itself does not exist and it cannot be resol...
18116 Dec 2011 @ 12:49 PSTDatabaseReplykilling a particular query in a session with out viewpoint/pmon >>So the  "SessionNoIn" parameter in abortsessionfunction  represents the "queryid" in dbqlogtbl instead of the "sessionid" in the dbqlogtbl? ...
18015 Dec 2011 @ 06:34 PSTCloud ComputingReplyRunning Teradata VMware 12.0 1 TB edition on ESXi Ram: The whole process is explained here (in spanish): http://carlosal.wordpress.com/2011/03/19/teradata-13-10-sobre-suse-linux-enterprise-server-en-vmware/ http://carlosal.wordpres...
17915 Dec 2011 @ 12:42 PSTDatabaseReplykilling a particular query in a session with out viewpoint/pmon I don't think you can kill a statement, you can kill a session without PMON using SYSLIB.AbortSession() if granted. HTH. Cheers. Carlos.
17813 Dec 2011 @ 04:22 PSTGeneralReplyTeradata CHAR datatype not storing NUMERIC values Nitin: SELECT TYPE(234);  *** Query completed. One row found. One column returned.  *** Total elapsed time was 1 second. Type(234) --------------------------------...
17712 Dec 2011 @ 08:21 PSTGeneralReplyHow to create a table with Column names in Thai??? Objects in data dictionary are stored in UNICODE, so if you've got a client app with a font capable of representing the thai symbols, you should be able to create tables with thai-named colu...
17601 Dec 2011 @ 12:42 PSTToolsReplyFastload DateTime, Timestamp Steven: I respectfully disagree. The example showed the loading of the 'text representation' of a timestamp. Teradata stores timestamps as structures which are not 'text' (th...
17530 Nov 2011 @ 04:28 PSTToolsReplyFastload DateTime, Timestamp Hi: Sorry if I didn't make myself clear. This is what I meant. There is not implicit conversion between VARCHAR (formatted as a 'TIMESTAMP') and a DATE (but there is between a TI...
17430 Nov 2011 @ 03:14 PSTToolsReplyFastload DateTime, Timestamp anujh: The (not) implicit conversion you're talking about is from VARCHAR to DATE, not from TIMESTAMP to DATE (implicit). HTH. Cheers. Carlos.
17325 Nov 2011 @ 03:47 PSTGeneralReplydata distribution in amp when more amps added Yes. This is called 'reconfig' (reconfiguration). Cheers. carlos.  
17224 Nov 2011 @ 04:02 PSTDatabaseReplyhow does we retrieve exact record in case of hash collission ROWID (unique) = ROWHASH + UNIQUE (32 bit) jones, homes, whatever: Same ROWHASH, but different ROWID. HTH. Cheers. Carlos.
17123 Nov 2011 @ 06:15 PSTDatabaseReplywhen i use"arcmain" to restore a database,i got a error Hi: What part of "No more room in database." is that you don't understand? You are trying to restore/copy into a database which has not room (space) enough to store all the...
17014 Nov 2011 @ 02:42 PSTDatabaseReplySET and MULTSET table Table2 is SET table because is created from SELECT, and SET is the default in Teradata. Table3 is MULTISET because is created from table1, which is MULTISET. Cheers. Carlos.
16911 Nov 2011 @ 03:18 PSTDatabaseReplyHow to delete the record from the base table with foreign key mapping I stand corrected: you cannot use a trigger to delete cascade: "BEFORE triggers cannot have data-changing statements as their triggered action (triggered SQL statements)." Chee...
16811 Nov 2011 @ 02:14 PSTDatabaseReplyHow to delete the record from the base table with foreign key mapping There is not ON DELETE CASCADE. You must do it explicity (join, SP, Trigger...) Cheers. Carlos.
16710 Nov 2011 @ 08:33 PSTToolsReplyHelp Needed on bteq export/import optionYou cannot use the same file to EXPORT and IMPORT as the same time (without an EXPORT RESET between them). Cheers. Carlos.
16610 Nov 2011 @ 12:04 PSTDatabaseReplyinstallation of teradata on redhat linux step by step RedHat Linux is not a certified OS where you can install Teradata. You can try and install VMware on it an then use a Virtual Machine (with SuSE 64) to have a Teradata database running. ...
16509 Nov 2011 @ 10:39 PSTGeneralReplyAltering the partitioning of a non-empty table The partitioning is made on the primary index, which is the basement of the table distribution throught the AMPs. You can create another table with the desired partitioning schema and INSERT...
16408 Nov 2011 @ 04:28 PSTDatabaseReplyHow to format numbers as Comma separated Tools->Options->Answerset-> Check "Display 1000 separators in numeric columns" HTH. Cheers. Carlos.
16308 Nov 2011 @ 12:36 PSTDatabaseReplyHow to format numbers as Comma separated    BTEQ -- Enter your SQL request or BTEQ command: SELECT CAST(123456789.00 AS FORMAT 'G999999999D99');  *** Query completed. One row found. One column retur...

Pages