All forum activity

#DateUserForumTypeThreadPost
4387002 Sep 2014 @ 11:28 PDTRaja_KTGeneralReplyCan anyone please tell me use of merge block ratio in ddlsHi Purushotham, You can go through this link. It provides a vivid description: http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/Create_Table-Details...
4386902 Sep 2014 @ 11:20 PDTRaja_KTGeneralReplyWithout using Join keyword how can we retrive matching rows from both the tablesCan you use  intersect ,exists, (not exists), in , (not in), .....union n minus ......? or is it an inhibition that join should not be used at all?  
4386802 Sep 2014 @ 10:27 PDTbalaji.bgdevToolsTopicTPT Extract not working for column name starting with FROM_ I got the below mentioned error when I had column name starting with FROM_ in the table.   TPT_INFRA: TPT02932: Error: TPT_INFRA: TPT02934: Error: invalid token  near line 193 (t...
4386702 Sep 2014 @ 10:19 PDTbalaji.bgdevToolsReplyTPT Extract - Newline character in data causes number of records mismatchCan someone please respond to this if you know a resolution for this problem?   This will very helpful for me if we can solve ouside of query.
4386602 Sep 2014 @ 10:18 PDTPurushothamGeneralTopicWithout using Join keyword how can we retrive matching rows from both the tablesHi,   Could anyone pls share me a query .without  using join keyword  how can we retrive the matching rows from both the tables..   Regards, Purushotham..  
4386502 Sep 2014 @ 10:17 PDTfeinholzToolsReplyExporting to Multiple files in Fast ExportThe lowercase -c is not what you think it is.  :) What version of TPT are you using? The only reason why rows were distributed when exporting 13.3 million is because there was enough work to...
4386402 Sep 2014 @ 10:09 PDTPurushothamGeneralTopicCan anyone please tell me use of merge block ratio in ddlsHi Everyone,   use of Default Merge block Ratio in DDl's      
4386302 Sep 2014 @ 09:14 PDTbalaji.bgdevToolsReplyExporting to Multiple files in Fast Exportit worked when I exported 13.3 million rows but with -c (lower case). Thanks Steve !!!
4386202 Sep 2014 @ 08:51 PDTbalaji.bgdevToolsReplyExporting to Multiple files in Fast ExportWith lower case it did not export data into multiple files. Is it because of I had less data. I had only 25,000 rows.
4386102 Sep 2014 @ 08:49 PDTbalaji.bgdevToolsReplyExporting to Multiple files in Fast ExportI do not see -C at all as an option. Is it because of the version?   Usage: tbuild -f ScriptFile [-d | -t] [-e UTF16] [-m StatisticsInterval]            ...
4386002 Sep 2014 @ 02:57 PDTToddAWalterDatabaseReplyNew in Release 13 ? Alter table not possible on columns with statisticsNot clear what you mean by a production crash. If you had a failure of the Teradata database then it should be reported to the Teradata Global Support Center so that it can be found and repaired. ...
4385902 Sep 2014 @ 02:30 PDTFredDatabaseReplyString contains an untranslatable characterYou get the error because the function name is translate_chk not translate_check. But this will check the name of the column itself and not the table contents - so won't do what you want. You ...
4385802 Sep 2014 @ 02:18 PDTFredDatabaseReplydoes Teradata support UTF-16 surrogate pair?Teradata does not currently support surrogate code points.
4385702 Sep 2014 @ 01:46 PDTlcarter40TrainingReplyNeed Help Fro Traning PurposeI don't believe the purpose of this forum is to provide test question answers. You can take the SQL WBT classes to research these questions, test this SQL on a system such a Teradata Express, ...
4385602 Sep 2014 @ 01:14 PDTkrishaneeshTeradata ApplicationsReplyFASTLOAD / MLOAD Data Parcel How to See what inside?SQL assistant when querying the table would ask you to give the extension you want the data parcel to be inwhich case you can specify as txt. Once the answer set gets loaded you can click on the .t...
4385502 Sep 2014 @ 10:08 PDTsamkvDatabaseTopicTime Dimension table with Historic date/times (Timestamp with Timezone)Hello, I have a need to create a Time Dimension table that has every hour of the day with (timestamp with timezone) for the last 2 years.  How can I create this table that will have ...
4385402 Sep 2014 @ 09:45 PDTSankalp.CTeradata ApplicationsTopicFASTLOAD / MLOAD Data Parcel How to See what inside?Hi, In FLOAD and even MLOAD in ET_TARGET_TABLE, in case off error we get data Parcel. But How to analyse it? How to see what inside?   Thanks! Sankalp
4385302 Sep 2014 @ 09:00 PDTabort_sessionDatabaseReplyNew in Release 13 ? Alter table not possible on columns with statisticsWe have a production crash after installion this workaround above. We have tested positive with an alter statement with compress, but not with adding a new column to a table.   We can'...
4385202 Sep 2014 @ 08:42 PDTToddAWalterDatabaseReplyTemporals and Outer JoinsIf you are getting 3610, that is a SW fault and should be reported to the Teradata Global Support center. Please write an incident.
4385102 Sep 2014 @ 06:03 PDTSumaAitaGeneralReplyconvert 13 digit epoch time to date?Thanks Dieter..
4385002 Sep 2014 @ 04:44 PDTRaja_KTToolsReplyCustom Message in BteqSince you mention about logfile, I m thinking that you may want to use .goto and label too...... can you try with this: insert into.... .if errorcode <> 0 then .goto insert1 insert in...
4384902 Sep 2014 @ 04:19 PDTRaja_KTTeradata ApplicationsReplydiff between volatile and GTT table with ON PRESERVE COMMIT statementThey are similar in many features. You can create and see both how they are implemented. This link highlights a comparison: http://www.info.teradata.com/HTMLPubs/DB_TTU_13_10/index.html#page/Data...
4384802 Sep 2014 @ 04:04 PDTBITeraDataGeneralReplySTRIPING WHITE SPACES   Hi Dieter, Thanks for your response .I am sorry its is NULL characters that gets appended . When I am extracting data from XML using XMLTABLE ,Its appending X'00'(...
4384702 Sep 2014 @ 03:29 PDTdnoethToolsReplyCustom Message in BteqNOTIFY: - is not writing to standard output, but to EventLog on Windows or system log on Unix. - must be specified before the SQL commands - has a different syntax .notify HIGH msg 'Bteq ...
4384602 Sep 2014 @ 02:36 PDTambuj2k50ToolsReplyCustom Message in BteqI also tried with .REMARK but the custom message is not getting populated in the logfile.

Pages