All forum activity

#DateUserForumTypeThreadPost
21724 Jan 2006 @ 04:30 PSThhDatabaseReplyIMPORT DATA WITH USING (variable)I am not sure this will work but have you try putting those values from a file into a teradata table and use the table to drive your file name?
21624 Jan 2006 @ 04:27 PSThhDatabaseReplyTablename can be deifned in where clauseI would not say this is bad but just a timesaving feature. To prevent this from happening again, try changing your defaultdatabase to a database contains nothing. The default database is the wher...
21524 Jan 2006 @ 04:20 PSThhTrainingReplyIncemental BackupTeradata does not really have a true incremental backup. But by using journalling and backing up the journals, it's a simple way of incremental backup.For cluster backup, please read this... basic...
21424 Jan 2006 @ 04:17 PSThhTrainingReplydata contains bad charactertry casting the value and then check if the result contains character. (I assume you are trying to do calculation?)
21324 Jan 2006 @ 04:15 PSThhToolsReplyDemoTDAT logon/passwordin the host file, change the DemoTDAT to DemoTDATcop1. The default password for dbc is dbc...
21224 Jan 2006 @ 04:12 PSThhToolsReplyNeed help abt Teradata start up !!!!you need to a script to do fastexport, the demo cd may have some sample scripts or go to this site...http://www.info.ncr.com/eDownload.cfm?itemid=052830007
21124 Jan 2006 @ 04:08 PSThhToolsReplyTpump PerformanceI hope the reason you want to use tpump is largely based on data avalability and not to replace mload entirely.There are many tunable parameters for tpump but try those out like-sessions-pack rate-...
21024 Jan 2006 @ 03:43 PSThhToolsReplySecure Copytry something sftp...or secure FTP..
20924 Jan 2006 @ 03:40 PSThhToolsReply.DISPLAY in MLOADmaybe instead of listing the field as empty, populate it with ***** or something unique, see if the script works...
20824 Jan 2006 @ 03:36 PSThhToolsReplyFastLoad vs NL Charactermaybe define that newline character but not loading it? Hope that helps..
20724 Jan 2006 @ 03:26 PSThhToolsReplyBatch locking issueI would recommend looking at the locking issue rather than blocking issue first: what kind of query, tool or set up (ANSI?) that caused the locking not being release? Do you allow direct user quer...
20624 Jan 2006 @ 03:23 PSThhToolsReplyFastload,multiload,fastexport,tpumpTry the documentation website...it has sample scripts.http://www.info.ncr.com/Teradata/eTeradata-BrowseBy.cfm?page=Teradata%20Tools%20and%20Utilities
20524 Jan 2006 @ 03:21 PSThhToolsReplyFastload QuestionAfter you load the data in staging, you can always issue some sqls to look at the data, right? Or perform some aggregations on Oracle then compare to Teradata.
20424 Jan 2006 @ 03:18 PSThhToolsReplyQuryman ErrorMake sure you have set up the teradata node connection information and all your odbc drivers are up to date.
20324 Jan 2006 @ 03:14 PSThhToolsReplyQuerying DB2 using SQL Assistant 6SQL Assistant can connect to any ODBC Driver. So if there is an DB2 ODBC driver installed, you should be able to use SQL Assistant on DB2.
20224 Jan 2006 @ 02:52 PSTTeraTintinToolsTopicQuryman ErrorMy Querman is not workingWhen I try to connect machine data source I get the following error:160: specified driver could not be loaded due to system error 126 (Teradata)Any tips to resolve this iss...
20124 Jan 2006 @ 12:14 PSTshaik.feroz@aaa-calif.comDatabaseReplyTablename can be deifned in where clauseThis is something we should be very careful while writing queries. what happened in the query is personnel1 is considered as an alias for personnel and it works with out error. similarly if we have...
20024 Jan 2006 @ 12:01 PSTSunil AgrawalDatabaseTopicTablename can be deifned in where clauseI just noticed something in Teradata. We can define a table in the WHERE clause. For example the below query run without any error from the p****r: -select * from personnelwhere personnel1.user_id ...
19924 Jan 2006 @ 11:41 PSTLuke SmithDatabaseTopicDelete / truncate commandI understand there is no truncate command in Teradata. Truncate command just moves the pointer at the end of the table to the beginning and marks space it used to available and since it just moves ...
19823 Jan 2006 @ 09:46 PSTteranubToolsTopicQuerying DB2 using SQL Assistant 6All, I am very new to Teradata. I am trying to find out if I could actually use SQL Assistant 6 to query a DB2 database. Is there a way to do that? I haven't used TSO very much and trying to avo...
19723 Jan 2006 @ 06:43 PSTshaik.feroz@aaa-calif.comDatabaseReplyavg on time field not working ?Try this select CHAINE, avg (cast(trim(duree)||':00' as interval hour(4) to second (0) )) from dwhtrf.PO_SUIVI_DICZ group by CHAINE
19623 Jan 2006 @ 01:49 PSTellenConnectivityTopicTransparent Gateway for Teradata on SUNI am trying to find the Teradata Client Software to install on a Sun SOLARIS in order to use the the Transparent Gateway for Teradata with an ORACLE database. I have not had any luck finding what ...
19523 Jan 2006 @ 01:18 PSTjasonfUDAReplySQL to update a column using another columnYou said initially that LP_Qty "should retain it's previous value till it is FisPeriodEnd_Dt". I don't know your data well enough to see how to calculate this on a daily basis. Can you provide a ...
19423 Jan 2006 @ 11:31 PSTterausrUDAReplySQL to update a column using another columnthis 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, ...
19323 Jan 2006 @ 09:48 PSTjasonfUDAReplySQL to update a column using another columnSeems 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?

Pages