#DateForumTypeThreadPost
24805 May 2011 @ 10:55 PDTDatabaseReplyDrop / Delete tables in bulkThe following query assumes the first working day on the month is the first monday of the month. You may need to adjust this for your location and/ or to exclude public holidays on a monday. It al...
24705 May 2011 @ 10:30 PDTGeneralReplyHow to recovert Teradate Query from Windows Standbyno
24604 May 2011 @ 02:51 PDTDatabaseReplyInserting a value in tableSubstring and Position (or Substr and Index - they are the non ANSI versions): Create Volatile Table T1 (PK Integer Not Null , InCol Varchar(120) Not Null Unique Primary Index (PK) On Commit...
24530 Apr 2011 @ 02:36 PDTDatabaseReplyWay to transpose columns to rows?See http://forums.teradata.com/forum/analytics/transposing-data
24428 Apr 2011 @ 03:15 PDTToolsReplybteq export issuerequesttext does not always contain the create table text. You should use show table commands. Run bteq to generate the show table commands, then .run that file: .logon .set width 200 .set ...
24328 Apr 2011 @ 02:31 PDTGeneralReplyNeed input : How to avoid dirty read without waiting for the table to be refreshedIf you place an exclusive lock on the table for the duration of the delete/ insert, it will ensure the table consistency. So: locking DBNAME.TABLENAME for Exclusive delete from DBNAME.TABLENAM...
24210 Mar 2011 @ 11:56 PSTDatabaseReplyTable size difference despite the same definition and dataIf you put compression on a column, then the system will always compress nulls. So if you compress 'Fred' on your column, the collumn will compress Fred or nulls. If you do not compress the column...
24124 Feb 2011 @ 04:52 PSTToolsReplycan i do data converson for column in fastloadIf the column is defined in the table as char(3), it should just take the first 3 characters without complaining. (You cannot take anything else like the 2nd, 3rd, 4th). Otherwise, use MLoad - th...
24021 Feb 2011 @ 11:56 PSTDatabaseReplyHiga charts?Try posting a message on Woody's blog.
23921 Feb 2011 @ 11:53 PSTDatabaseReplyInner join on multiple Columns best way?(It's a bit urgent)Always avoid OR conditions in joins. Use a union: SELECT reg_no FROM A INNER JOIN B ON A.Id=B.Id1 WHERE XXXXXX AND YYYYYY AND ZZZZZZ UNION SELECT reg_no FROM A INNER JOIN B ...
23819 Feb 2011 @ 12:25 PSTDatabaseReplyHiga charts?From Google: http://developer.teradata.com/blog/woody/2010/07/how-do-you-create-those-cool-resusagespma-higa-charts
23717 Feb 2011 @ 02:21 PSTToolsReplyEBCDIC file from a Network connected server.....Fastload, Multiload and TPump all allow you to specify the character set of the input file using the -c option. TPT aso allows you to specify input chracterset. If your input data is all charac...
23617 Feb 2011 @ 12:20 PSTGeneralReplyANSI standards checking.See SQL Flagger in the SQL Reference Fundamentals manual.
23516 Feb 2011 @ 05:26 PSTGeneralReplyCast smallint to timeHow is the time stored in your smallint? The largest value in a smallint is 32767 so it cannot be hhmmss format or seconds since midnight. (Unless your times are restricted to very early hours only...
23426 Jan 2011 @ 12:05 PSTDatabaseReplyLocking InformationExplain will tell you.
23326 Jan 2011 @ 12:03 PSTGeneralReplyError trying to create table from select while select work perfectly fine by itself See Database Forum.
23226 Jan 2011 @ 12:03 PSTDatabaseReplyError trying to create table from select while select work perfectly fine by itselfcreate table dbc.tb2 as (select Rcrd_No, compltn_dt, substr(compltn_dt,1,position(' ' in compltn_dt )) as dt, trim(substr(compltn_dt,position(' ' in compltn_dt )+1,characters(compltn_dt)))as t...
23117 Dec 2010 @ 03:45 PSTDatabaseReplyMAcro to create the DDL for Replace view or Cretae viewIs your production database called Production or ProductionDB? The only reason I can see why it should return no rows is that database Production was empty or did not exist on the system you were u...
23017 Dec 2010 @ 11:39 PSTDatabaseReplyMAcro to create the DDL for Replace view or Cretae viewYou can only run one DDL statement in a macro, so you cannot do this by macro. Also, you do not need to collect the columnnames if you just want a Select * view. If you run the following BTEQ s...
22917 Dec 2010 @ 11:10 PSTToolsReplyFastload - Timestamp to Date 1. Your input file as shown is not vartext - there is no length on the fromt or record delimiter. 2. If you specify the file as TEXT, you can then define the start date and time as separate fields...
22811 Dec 2010 @ 12:32 PSTDatabaseReplyHow to retrive the last word in the Sentence in Teradata ?Take a look at the link WAQ provided. This tells you how to use the Oracle UDF's to find it in Teradata.
22708 Dec 2010 @ 02:45 PSTDatabaseReplyDatabase "aliasing" -possibleThere is no "alias" feature within the database, but you can use Unix/ mainframe/ Linux/ Windows scripting to use an alias in scrpts and expend them by shell or JCL features. Make sure you do that ...
22606 Dec 2010 @ 01:39 PSTDatabaseReplyNeeds to change DATE formatIt will export the data into mm/dd/yyyy format.
22506 Dec 2010 @ 08:12 PSTDatabaseReplyNeeds to change DATE formatYou have to format the date and cast it as character. Not sure how you get the dates to come out of SQL Assistant like that, but the following works fine for me on TD12: cREATE VOLATILE TABLE ...
22406 Dec 2010 @ 04:38 PSTDatabaseReplyVTT vs GTTYou would tend to use volatile tables in batch scripts where you are building some form of work or summary table for use only in that script. Because you can turn logging off for the table, it is ...

Pages