#DateForumTypeThreadPost
97827 Apr 2011 @ 01:44 PDTDatabaseReplyquery that shows appointments in two days from "today"You should post Sybase questions on a Sybase forum :-) In Teradata it would be an additional WHERE-condition AND appt_date = current_date + 2 Dieter
97727 Apr 2011 @ 01:41 PDTDatabaseReplyExecuting DDL in a Store ProcedureIf the SP is running in Teradata Mode there's probably a BEGIN TRANSACTION submitted by DataStage, you should check the QueryLog. You could try an END TRANSACTION before the DDLs and maybe anoth...
97620 Apr 2011 @ 04:05 PDTToolsReplyBTEQ .PACK and deadlockSERIALIZE sends rows with the same Row Hash to the same session, thus avoids different sessions locking the same value. ARRAYSUPPORT is exactly the same as BTEQ's PACK. Based on the SQL in DML L...
97519 Apr 2011 @ 02:18 PDTDatabaseReplyHow to import from an Oracle .dmp file?An Oracle DUMP is proprietary, you might find third party tools to extract the data and produce some flat files. But i'm not aware of any tool to directly import it into TD. Dieter
97419 Apr 2011 @ 02:07 PDTToolsReplyBTEQ .PACK and deadlockBTEQ INSERTs require a Write lock on a Row Hash level. When you got 2 rows with the same PI in different sessions both try to place the same lock, if it's a single row insert one session has to wa...
97319 Apr 2011 @ 01:54 PDTDatabaseReplyDescribe tableHELP TABLE is only returning column definition, but SHOW TABLE gives the full CREATE TABLE statement. Dieter
97219 Apr 2011 @ 01:51 PDTToolsReplyRegarding Temporary SpaceBoth user A and user B have exactly the same limits, not the spool/temp space is inherited, just the numbers. And spool is not based on the owner's perm space, it's all currently not used perm sp...
97115 Apr 2011 @ 12:15 PDTDatabaseReplyScripting Primary KeysRetaining the PK definition was implemented a few month ago, but i don't remember which release/patch level. I have to admit that i didn't like it, because it changed the output of SHOW TABLE with...
97015 Apr 2011 @ 12:01 PDTDatabaseReplyNot updating correctlyNothing wrong, this should work as expected. Did you double check everything? Can you provide a script (+ output) reproducing this result? Then you should open an incident. Dieter
96913 Apr 2011 @ 02:14 PDTDatabaseReplyPerformance tuningA table with "a little over 11,000 recs" is small, probably just a single datablock per AMP. The optimizer will not choose an SI access for such small tables, as it's not faster than a Full Table ...
96813 Apr 2011 @ 02:04 PDTGeneralReplyNeed help on DATE functionDATE '2011-03-31' is a date literal, which must be a single expression. You have to change the condition depending on the datatype of THIS_END_DATE: = (:THIS_END_DATE - EXTRACT(DAY FROM :THIS_E...
96713 Apr 2011 @ 05:55 PDTDatabaseReplyvolatile table as select..with data - not loading dataJust add ON COMMIT PRESERVE ROWS, as the default is ON COMMIT DELETE ROWS. Dieter
96613 Apr 2011 @ 03:19 PDTDatabaseReplyHow to find list of database objects in teradataHi Mandar, of course a dba could revoke all access rights to the system views, but this would be totally stupid :-) Regarding dbc.tvm (and other system *tables*), it's similar to other DBMSes. ...
96512 Apr 2011 @ 06:42 PDTDatabaseReplyHelp with Count DistributionOops, i forgot "=1", this should work now: select zip_code, count(*) from ( Sel zipcode, trackingnumber, eventdatetime from tracking -- last event of each trackingnumber qualify row_number...
96412 Apr 2011 @ 01:20 PDTDatabaseReplyHow to find list of database objects in teradataHi Mandar, every Teradata user will have access to system views in dbc. It depends on the dba which views are accessible, there are two sets, views with and without an appended X. These are s...
96311 Apr 2011 @ 02:26 PDTDatabaseReplyHelp with Count Distributionselect zip_code, count(*) from ( Sel zipcode, trackingnumber, eventdatetime from tracking -- last event of each trackingnumber qualify row_number() over (partition by trackingnumber order b...
96208 Apr 2011 @ 01:19 PDTDatabaseReplyValue compression on timestamp columnIf there's both start and end timestamp switching to Period in TD13 will save disk space, too. UNTIL_CHANGED is stored in a single byte. Dieter
96107 Apr 2011 @ 12:57 PDTUDAReplyDifference in outputYou need to know about the data to be loaded into that column. The benefit of LATIN is size, it's a single byte character set whereas UNICODE is implemented as UTF-16 (=2 bytes) in Teradata. ...
96007 Apr 2011 @ 12:50 PDTDatabaseReplyReverse string search (right to left)?I don't know, but it's easy to rewrite: right(col, 3) -> substring(col from char_length(col) - 2) In TD13.10 you simply put this into a SQL UDF Dieter
95907 Apr 2011 @ 12:49 PDTTrainingReplyfew QuesThe limits for each release are listed in an appendix in the Database Design manual Dieter
95807 Apr 2011 @ 12:40 PDTDatabaseReplyInstallation Teradata 13 Express - 64 bit Windows OS. I can't help you with TD Express on 64-bit Windows, i try to avoid Windows as much as possible :-) The only one i got is a 32-bit XP running in a virtual machine on my Mac. I think VMWare is th...
95706 Apr 2011 @ 02:22 PDTDatabaseReplyInteger (with Unix epoch time) convert to timestamp?See the second last comment at: http://developer.teradata.com/blog/robg/2011/02/using-interval-to-add-or-subtract-fractional-seconds-to-or-from-timestamp-values Dieter
95606 Apr 2011 @ 02:15 PDTConnectivityReplyproblem with hibernate and mapped entityYou didn't show the output, but i assume there were some blanks :-) Of course i assume that the target column is defined as VARCHAR instead of CHAR. Teradata doesn't append trailing blanks on...
95506 Apr 2011 @ 02:08 PDTDatabaseReplySpecify datablock size, Percent freespaceYou're right, 127 is the default (might be different on the appliance-style systems). The only way to find out about the default datablocksize is the dbscontrol utility, but only DBAs have acces...
95406 Apr 2011 @ 01:47 PDTDatabaseReplyInstallation Teradata 13 Express - 64 bit Windows OS. AFAIK TD Express on Windows is 32-bit only. So you need to run it on VMWare (as an extra benefit you get Teradata on Linux, which is the common Teradata OS nowadays). Dieter

Pages