#DateForumTypeThreadPost
1629 Mar 2011 @ 10:08 PDTDatabaseReplyUSI vs Primary key to enforce uniquenessHi Dieter, Thanks for the info. I tested few scenarios... Created with non unique primary index on composite columns and table is partitioned on date column .. inserted 2 duplicate records to...
1528 Mar 2011 @ 08:54 PDTDatabaseTopicUSI vs Primary key to enforce uniquenessHi , We have a composite primary index column and partitioning is done on column whcih is not part of primary index , hence we are not in position to create unique primary index. we thought o...
1425 Mar 2011 @ 12:45 PDTDatabaseTopicFind the first occurance of Number in a stringHi All, I want to find the first occurance of number [0-9] in a particular string. Say for an example Input : ABCDE5789PDH Output : 6 Input : DE09567 Output : 3 Total St...
1318 Mar 2011 @ 07:35 PDTDatabaseReplyClarification. is it possible to create table using create/select with format clause from base table.Hi Dieter, Thanks a lot... It is not the real time scenario ..table structure is for illustration purpose..
1217 Mar 2011 @ 11:31 PDTDatabaseTopicClarification. is it possible to create table using create/select with format clause from base table.Hi All, Would like to know whether it is possible to create table using create/select statement which will take format clause from base table. for example and illustration , say my base table...
1129 Dec 2010 @ 10:47 PSTDatabaseTopicForeign Key Violations , Logging Errors Hi , If we specify insert/select with logging error clause , during the insert if it encounter any foreign key violations , it will insert the error record in error table. 1) Child table h...
1008 Dec 2010 @ 11:52 PSTToolsTopicTeradata PT - ODBC and Load operator - Release lock on target tablesHi All, How to release lock on Fastload target tables when the input data is data stream from oracle database. we are using odbc operator as producer to extract data and load operator as consu...
917 Nov 2010 @ 09:41 PSTGeneralReplyExecuting Fastload through Java Hang in unixThanks a lot. It's working now.
815 Nov 2010 @ 11:16 PSTGeneralTopicExecuting Fastload through Java Hang in unixHi All, When we try to execute simple Fastload script through Java in unix , it hangs . same when We tried executing it manually through fastload command "fastload < /temp/data/fastload.txt...
727 Oct 2010 @ 10:34 PDTGeneralReplyThe BTEQ script for IMPORT function is not workingHi , Change the layout portion in the above script with the one mentioned below. USING a (VARCHAR(1)), b (VARCHAR(10)) and include delimiter , in the flat file 1,EXPALL0610 2,HLTHCP061...
626 Oct 2010 @ 03:36 PDTGeneralReplydays since Jan 1 ,4712 BC in TeradataThanks a lot Carlos ,it's working
525 Oct 2010 @ 12:40 PDTGeneralTopicdays since Jan 1 ,4712 BC in TeradataHi All, 1) Is it possible to specify BC(Before Christ) or AD in date format ?. I checked the Manual , but i couldn't get anything. 2) Is there any equivalent syntax in Teradata to...
419 Oct 2010 @ 10:21 PDTDatabaseTopicHow to find a particular table in Teradata is locked using SQL query?Hi All, Query is running very long due to some locks and normally we used to check using PMON and find the session which is blocking the current query. what are the different way by which we...
318 Oct 2010 @ 03:04 PDTGeneralReplyDifferent results in bteq and sql assitant for current_date with format optionThanks a lot Dieter .
218 Oct 2010 @ 12:39 PDTGeneralTopicDifferent results in bteq and sql assitant for current_date with format optionHi, why we are getting different results when the same query is executed in bteq and sql assitaint ?. select current_date (format 'MMM'); Oct same query in Sql Assitant is not giving exp...
116 Oct 2010 @ 06:14 PDTGeneralTopicMaximum number of AMPS possible in Teradata version 12 and above ??? Hi All, Maximum number of nodes supported by BYNET is 512 and room for expansion upto 2048 and maximum number of vprocs supported by each node is 128. so say for an example at max 65536 AMP is ...