#DateForumTypeThreadPost
1125 May 2007 @ 12:16 PDTUDATopicMacro and securityHi,How does Teradata Macro provide column level security?Please give an example for this topic.Thanks,
1023 Nov 2006 @ 05:29 PSTDatabaseReplyIs there any way to select "ROWID" of a record?Hi,The usage of ROWID in DML statement is not allowed in v2R5 onwards.It is used only by Optimizer to join the Join Index back to the base table in case of Partial covering query to fetch the resu...
923 Nov 2006 @ 05:20 PSTDatabaseTopicJoin Elimination by SIHi all,How does the Soft Referential Integrity eliminate Joins?Thanks in advanced,
802 Aug 2006 @ 07:57 PDTToolsTopicLoading UTF8 data using MloadHi,We tried to load data in UTF-8 format with tab as delimiter using Mload. But it is moving to ET tables and the errorcode is '6705'.here is the sample UTF8 data(with tab delimiter):63 ÌÊ33 Ä/2...
701 Aug 2006 @ 10:31 PDTToolsReplyTab Delimited Flat file and MloadHi,It works with '09'XC in Unix too.The problem was due to the tool which I had used to generate the test flat file.Thanks,
601 Aug 2006 @ 04:26 PDTToolsTopicTab Delimited Flat file and MloadHi all,My requirement is to insert the data from a TAB delimited flat file using Multiload Job script.I used the following in the Mload:.IMPORT INFILE customers.dat FORMAT VARTEXT '09'XC LAYOUT new...
520 Jul 2006 @ 11:02 PDTDatabaseTopicIdentifying a Node in MPPHi all,How do the request from the client send to appropriate Node in the MPP system?The AMP within a Node is identified by Mapping The hash value generated by PE's generator in the Hashmap.(But th...
420 Jul 2006 @ 11:01 PDTDatabaseTopicIdentifying a Node in MPPHi all,How do the request from the client send to appropriate Node in the MPP system?The AMP within a Node is identified by Mapping The hash value generated by PE's generator in the Hashmap.(But th...
307 Jun 2006 @ 02:09 PDTDatabaseReply10065 WSA E HostUnreachHi,Check whether you use any Firewall S/W.If it is so,turn off and try it.If the Teradata Service is running and if you are unable to connect it thruoghSQL Assistant then this error may be reported...
209 Dec 2005 @ 11:56 PSTToolsTopicOracle to Teradata MigrationHi,I tried to load Teradata from Oracle table.Look at the following code---------------------------------------------//To write Oracle table data into a flat file//dept.sql (Oracle)----------------...
126 Nov 2005 @ 09:18 PSTDatabaseTopicInsert-SelectHi,I want to insert the records from an existing table to new tables.I would like to know the time taken when I use Insert-Select stmt.But I could not estimate this using EXPLAIN.Is there a way out...