| 194 | 23 Jan 2006 @ 11:31 PST | terausr | UDA | Reply | SQL to update a column using another column | this is my original insert statement it updates LP_Qty with the RF_Qty everyday now.DELETE FROM RTL_DEV_DATA.RPLNSHMNT_FORECAST ALL;INSERT INTO RTL_DEV_DATA.RPLNSHMNT_FORECASTSEL it.Item_ID, ... |
| 193 | 23 Jan 2006 @ 09:48 PST | jasonf | UDA | Reply | SQL to update a column using another column | Seems like you should try to add the logic to your insert statement so that you do not need to do a sperate update. Could you post your current insert statement for review? |
| 192 | 23 Jan 2006 @ 09:42 PST | DEEPU | Database | Reply | Removing Column Format | You can use Alter DML for this: Alter table table_nameadd existing_column_name data_type; //without format phraseBut you can't change the column attributes if it requires modification of internal s... |
| 191 | 23 Jan 2006 @ 06:18 PST | phil1212 | Database | Topic | avg on time field not working ? | Hello,I've got 3 fields in my table all are in char(5).'03:02' as deb'03:06' as fin'00:04' as dureeI'm trying to calculate an average on the "duree" field but it fails.I first cast it as a time to ... |
| 190 | 23 Jan 2006 @ 02:25 PST | akhil.bansal@gmail.com | Database | Topic | Removing Column Format | How can the Format defined for a column be removed ? |
| 189 | 22 Jan 2006 @ 06:41 PST | shajeer | Database | Reply | Warehouse 8.0 Demo ? | No Idea |
| 188 | 22 Jan 2006 @ 04:38 PST | Manoj_Kumar_Parmar | Training | Reply | BTEQ sample scripts | HI Dennis, thanks alot for information, this time I am not working through my pc, I will check laterthanks |
| 187 | 21 Jan 2006 @ 03:41 PST | terausr | Tools | Topic | Fastload Question | I need to export flat files out of Oracle and Fastload it into Teradata.,Let's take an example A table has say 5 fields and these are integers & datesI am sending them in this format6305,1451,2400,... |
| 186 | 21 Jan 2006 @ 01:11 PST | terausr | UDA | Reply | SQL to update a column using another column | Thanks Jason for your reply. My ETL process deletes all data from the target table everyday and reloads it with fresh data. It's a DSS. I need to do the update with previous day's value if the cond... |
| 185 | 20 Jan 2006 @ 09:20 PST | Dennis Calkins | Database | Reply | Can a teradata database trigger/stored procedure call a java program or Executable? | But ODBC runs on UNIX.You can download the ODBC driver for Teradata for SOLARIS, LINUX, HPUX, AIX from http://www.teradata.com/t/page/130536Like I said you can try writing C Wrapper functions... |
| 184 | 20 Jan 2006 @ 03:00 PST | kiran9988 | Tools | Topic | Fastload,multiload,fastexport,tpump | Can someone send me the sample scripts that u used for multiload,fastlaod,fastexport,tpumpwith some comments attached to the scripts.Am new to teradata and i appreciate the help if some one provide... |
| 183 | 20 Jan 2006 @ 01:11 PST | mustaqbasha | Database | Reply | Can a teradata database trigger/stored procedure call a java program or Executable? | First, my code will run on unix env, so I cannot go with ODBC.Second, To write a code to access messaging server or database server in C will take lot development effort and timeThird, most my exi... |
| 182 | 20 Jan 2006 @ 12:29 PST | DEEPU | Database | Reply | duplicate unique primary key error | Sharad,UPK error occurs only when the UPI column that you are trying to insert is alraedy present there in your table.Check if you are passing identity column value also , if yes then don't pass it... |
| 181 | 20 Jan 2006 @ 12:10 PST | Dennis Calkins | Training | Reply | BTEQ sample scripts | If you install the DEMO APPLICATIONS off the DEMO CD you will find all the scripts for all the DEMO apss here.c:\Program Files\NCR\Teradata For Microsoft Windows Demo\bin |
| 180 | 20 Jan 2006 @ 12:04 PST | Dennis Calkins | Database | Reply | Can a teradata database trigger/stored procedure call a java program or Executable? | Sorry We don't support native Java functions. Can you re write the Java function in 'C' using ODBC or something? V2r6 allows you to write TABLE UDFS where your UDF can return a set of ROWS one... |
| 179 | 20 Jan 2006 @ 11:33 PST | dnoeth | Database | Reply | Collect Stats | Hi Luke,sorry, but you won't find any documentation about it.Most DIAGNOSTIC statements are undocumented, but sometimes you can guess the meaning of a keyword :-)Dieter |
| 178 | 20 Jan 2006 @ 10:18 PST | jai | Connectivity | Topic | NullPointerException in TdgssConfigApi | Hi, We are using Teradata driver with JBoss-3.2.3 application server. We have a datasource deployed on the server. We are seeing the following exception when getConnection is invoked on the datasou... |
| 177 | 20 Jan 2006 @ 09:47 PST | mustaqbasha | Database | Reply | Can a teradata database trigger/stored procedure call a java program or Executable? | Hi,Thanks for your prompt response! Would appreciate your comments on these as well:Here are my project requirements:1. From a teradata database trigger I need to update different vendor database(S... |
| 176 | 20 Jan 2006 @ 09:06 PST | jasonf | UDA | Reply | SQL to update a column using another column | I am not entirely sure this will work since I don't fully understand your ETL process or the data involved, but could you add an update to LP_Qty as part of your daily refresh process? Only when i... |
| 175 | 20 Jan 2006 @ 08:49 PST | paloma.palacios@accenture.com | Database | Topic | IMPORT DATA WITH USING (variable) | We need to make a BTEQSQL with the command “EXPORT REPORT” using a variable that contain the name file that we must use and generate.Following, we explain the SQL with the syntax USING to recup... |
| 174 | 20 Jan 2006 @ 08:43 PST | Luke Smith | Database | Reply | Collect Stats | Hi dnoeth,Thanks so much, this is so helpful, just ideal as you can have the sampling per collection, great.Is this available in any doc as I could not find anything like this anywhere..? |
| 173 | 20 Jan 2006 @ 07:50 PST | dnoeth | Database | Reply | Collect Stats | Hi Luke,the global flag is set by dbscontrol -> internal field 46: CollectStatsSampleOn a session level it's:DIAGNOSTIC "COLLECTSTATS, SAMPLESIZE=xx" ON FOR SESSION;For a singe Collect Stats:DIAGNO... |
| 172 | 20 Jan 2006 @ 06:59 PST | Luke Smith | Database | Reply | Collect Stats | Hi TDuser,yes thank you that has helped, I saw that in the documentation but did not understand fully, but now do |
| 171 | 20 Jan 2006 @ 06:15 PST | Luke Smith | Tools | Topic | Batch locking issue | Can anyone help with the following problem :When we start our batch in the evening, if a user has left a query running or a query has failed but left a non-shareable access lock on a table, then ou... |
| 170 | 20 Jan 2006 @ 06:13 PST | TDUser-781 | Database | Reply | Collect Stats | Hi Luke, reading from the manuals: " the system automatically determines the appropriate sample size to generate accurate statistics for good query plans and performance."Basically, when you collec... |
