#DateForumTypeThreadPost
320 Oct 2014 @ 01:30 PDTDatabaseReplyUsing ARCMAIN Don't use the word "ARCHIVE" as the file name. Arcmain is probably getting it confused with the word ARCHIVE in "ARCHIVE DATA TABLES". Try a different FILE=
220 Dec 2011 @ 11:48 PSTUDAReplyHow we can use timestamp with timezone in teradata(Eqv to from_tz in oracle) All you need to do is add or subtract the "interval" from the time. So for example, to go from a current time on the East Coast to the West Coast you simply subtract an interval of 3 h...
123 Mar 2010 @ 07:16 PDTDatabaseReplyQuery troubleshootingThe first thing you want to do is to run an explain on the query. This will tell you each step the parsing engine will take when formulating a plan to execute the query. The second step to improve ...