#DateForumTypeThreadPost
1021 Apr 2010 @ 11:43 PDTDatabaseReply calling bteq in unix shell scriptbteq= &=1 First line, take out "=" from above. Inserted "=" to ovecome web site deletion of characters.
921 Apr 2010 @ 11:41 PDTDatabaseReply calling bteq in unix shell scriptCorrection: bteq &1 LOGON usename, password; select count(*) from dbname.tablename; EXIT; STOP Copy and paste messed up a bit, let me try again; not sure if this is related to CMS or webs...
820 Apr 2010 @ 11:55 PDTDatabaseReplyExplain PlanWe avoided this type of condition by using a where condition clause, which was redundant in a way; similar to, customer_id > 0 and this forced partition based scanning. Underlying fact table has cu...
716 Apr 2010 @ 09:25 PDTDatabaseReplyMERGE vs UPSERTFrom what I understand, Merge is SQL used to upsert data. Merge is a valid SQL command in databases such as Oracle. Never came across upsert as a valid sql command. Coming to TD, I am not famil...
616 Apr 2010 @ 09:11 PDTDatabaseReply calling bteq in unix shell scriptbteq &1 LOGON username, password; select count(*) from dbname.tablename; EXIT; STOP Put above in a file (t1.sh) and run from command line. Output and log info will be within the same fil...
516 Apr 2010 @ 08:04 PDTToolsReplyTeradata PT 12.0 error output schema does not matchI ran into a similar situation yesterday. Here are my suggestions: 1) Use TPT wizard (Windows 32 bit) to create template. After all it is done, you will see a dialog box with four major sections. ...
418 Mar 2010 @ 12:42 PDTDatabaseReplyAggregation is so slow..can anyone help me what i have to do?Weigh benefits of having an AJI (Aggregate Join Index). In a few AJI circumstances, AJI reduced from hours to seconds in our database. You may know that AJI supports sum and count, not sure about a...
318 Mar 2010 @ 12:38 PDTDatabaseReplyDELETE query is taking too long time in the production....Just a quick thought, did you consider or is this worth considering: 1) Create a new table with data that does *not* include DATE_KEY (TableNew). 2) Rename original table to something else (ADSP ...
218 Mar 2010 @ 11:37 PDTToolsReplyBest way to product automated exports in tab-delimited form?I prefer BTEQ for exporting data, just a google search for BTEQ CSV will get you relevant links. You may also consider using NVL. http://forums.teradata.com/forum/tools/long-title-in-bteq-export-t...
118 Mar 2010 @ 11:30 PDTDatabaseReplyBest way to compare contents of two tables?There are a number of tables, views and macros available at DBC user level. I am not sure if you have access to all these, I use "Teradata Administrator" and menu option Database, List all objects....