|43870||02 Sep 2014 @ 11:28 PDT||Raja_KT||General||Reply||Can anyone please tell me use of merge block ratio in ddls||Hi Purushotham,
You can go through this link. It provides a vivid description:
|43869||02 Sep 2014 @ 11:20 PDT||Raja_KT||General||Reply||Without using Join keyword how can we retrive matching rows from both the tables||Can 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?
|43868||02 Sep 2014 @ 10:27 PDT||balaji.bgdev||Tools||Topic||TPT 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... |
|43867||02 Sep 2014 @ 10:19 PDT||balaji.bgdev||Tools||Reply||TPT Extract - Newline character in data causes number of records mismatch||Can 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.
|43866||02 Sep 2014 @ 10:18 PDT||Purushotham||General||Topic||Without using Join keyword how can we retrive matching rows from both the tables||Hi,
Could anyone pls share me a query .without using join keyword how can we retrive the matching rows from both the tables..
|43865||02 Sep 2014 @ 10:17 PDT||feinholz||Tools||Reply||Exporting to Multiple files in Fast Export||The 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... |
|43864||02 Sep 2014 @ 10:09 PDT||Purushotham||General||Topic||Can anyone please tell me use of merge block ratio in ddls||Hi Everyone,
use of Default Merge block Ratio in DDl's
|43863||02 Sep 2014 @ 09:14 PDT||balaji.bgdev||Tools||Reply||Exporting to Multiple files in Fast Export||it worked when I exported 13.3 million rows but with -c (lower case). Thanks Steve !!!
|43862||02 Sep 2014 @ 08:51 PDT||balaji.bgdev||Tools||Reply||Exporting to Multiple files in Fast Export||With lower case it did not export data into multiple files. Is it because of I had less data. I had only 25,000 rows.
|43861||02 Sep 2014 @ 08:49 PDT||balaji.bgdev||Tools||Reply||Exporting to Multiple files in Fast Export||I 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]
|43860||02 Sep 2014 @ 02:57 PDT||ToddAWalter||Database||Reply||New in Release 13 ? Alter table not possible on columns with statistics||Not 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.
|43859||02 Sep 2014 @ 02:30 PDT||Fred||Database||Reply||String contains an untranslatable character||You 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 ... |
|43858||02 Sep 2014 @ 02:18 PDT||Fred||Database||Reply||does Teradata support UTF-16 surrogate pair?||Teradata does not currently support surrogate code points.
|43857||02 Sep 2014 @ 01:46 PDT||lcarter40||Training||Reply||Need Help Fro Traning Purpose||I 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, ... |
|43856||02 Sep 2014 @ 01:14 PDT||krishaneesh||Teradata Applications||Reply||FASTLOAD / 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... |
|43855||02 Sep 2014 @ 10:08 PDT||samkv||Database||Topic||Time 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 ... |
|43854||02 Sep 2014 @ 09:45 PDT||Sankalp.C||Teradata Applications||Topic||FASTLOAD / 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?
|43853||02 Sep 2014 @ 09:00 PDT||abort_session||Database||Reply||New in Release 13 ? Alter table not possible on columns with statistics||We 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'... |
|43852||02 Sep 2014 @ 08:42 PDT||ToddAWalter||Database||Reply||Temporals and Outer Joins||If you are getting 3610, that is a SW fault and should be reported to the Teradata Global Support center. Please write an incident.
|43851||02 Sep 2014 @ 06:03 PDT||SumaAita||General||Reply||convert 13 digit epoch time to date?||Thanks Dieter..
|43850||02 Sep 2014 @ 04:44 PDT||Raja_KT||Tools||Reply||Custom Message in Bteq||Since you mention about logfile, I m thinking that you may want to use .goto and label too......
can you try with this:
.if errorcode <> 0 then .goto insert1
insert in... |
|43849||02 Sep 2014 @ 04:19 PDT||Raja_KT||Teradata Applications||Reply||diff between volatile and GTT table with ON PRESERVE COMMIT statement||They are similar in many features. You can create and see both how they are implemented. This link highlights a comparison:
|43848||02 Sep 2014 @ 04:04 PDT||BITeraData||General||Reply||STRIPING WHITE SPACES||
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'(... |
|43847||02 Sep 2014 @ 03:29 PDT||dnoeth||Tools||Reply||Custom Message in Bteq||NOTIFY:
- 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 ... |
|43846||02 Sep 2014 @ 02:36 PDT||ambuj2k50||Tools||Reply||Custom Message in Bteq||I also tried with .REMARK but the custom message is not getting populated in the logfile.