#DateForumTypeThreadPost
606 Nov 2015 @ 12:46 PSTTeradata StudioReplyUnexpected access rights problem when attempting to export table dataI wanted to report that according to our users the problem was solved in version 15.10.00.04, i.e. once they upgrade the error never occurs again, while their access rights remain the same they had...
518 Sep 2015 @ 12:08 PDTToolsReplyFastExport Remove Binary/Indicator Values in Outmod Hi Jim, Those first 2 bytes (not characters) generated by fexp are what was called a VLI - record variable length indicator. It's a 16-bit data structure containing an integer in binary form ...
417 Sep 2015 @ 01:53 PDTTeradata StudioReplyUnexpected access rights problem when attempting to export table dataThank you for your prompt reply, Francine I checked the log as you suggested and the reported missing access right is SEL on DBC.DBCInfo. (?) I didn't think the app uses this view in order to...
316 Sep 2015 @ 03:09 PDTGeneralReplyTuning the SQL queryHi Vinay, My first question would be if the inner join condition applies to the Primary Index (PI) of the larger table. Otherwise the execution plan would probably try to redistribute those 5 bil...
216 Sep 2015 @ 02:26 PDTTeradata StudioTopicUnexpected access rights problem when attempting to export table dataHi, Running Studio Express 15.00.02.201411070423 one of our users attempts to export data from a table he has created and populated, clicking the table name in the Data Source Explorer left panel ...
112 Dec 2012 @ 12:25 PSTDatabaseReplySET & Multiset TablesHi Harpreet, I'd recommend you please review option #3 in your first answer, if table SET and NUPI, complete row needs to be scanned *unless* a unique index (USI) is also defined, in...