#DateForumTypeThreadPost
2127 Feb 2006 @ 03:30 PSTAnalyticsReplyhow to convert a period of D+30, D+60 etc to exact day and monthTry the sql extract month from date feature...
2017 Feb 2006 @ 10:40 PSTDatabaseReplyNeed help on executing the BTEQ commands through PERL scriptIf your perl script can call out to an OS command, then you can execute bteq script. However, if you are just trying to get some result sets from teradata using bteq and export the results to file...
1924 Jan 2006 @ 04:52 PSTAnalyticsReplyRead data from txt file using Procedure/function in Teradata ??If you are try to use a command line tool to output results, then use BTEQ.
1824 Jan 2006 @ 04:49 PSTAnalyticsReplyinteroperability with email and smsdepending on what your program does with Teradata. If it just going through odbc and grab data from the database, then no problem. I am not familiar with sqlmail but I think if this is what it sup...
1724 Jan 2006 @ 04:36 PSTDatabaseReplyLogin to Teradat SQL assistantI suspect the pc you are working with somehow changing/reverting the settings/drivers that you have just installed.
1624 Jan 2006 @ 04:34 PSTDatabaseReplyARCHIVE DatabaseARCMAIN is a client utility. If you do not see it, then you need to install it.
1524 Jan 2006 @ 04:30 PSTDatabaseReplyIMPORT 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?
1424 Jan 2006 @ 04:27 PSTDatabaseReplyTablename 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...
1324 Jan 2006 @ 04:20 PSTTrainingReplyIncemental 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...
1224 Jan 2006 @ 04:17 PSTTrainingReplydata contains bad charactertry casting the value and then check if the result contains character. (I assume you are trying to do calculation?)
1124 Jan 2006 @ 04:15 PSTToolsReplyDemoTDAT logon/passwordin the host file, change the DemoTDAT to DemoTDATcop1. The default password for dbc is dbc...
1024 Jan 2006 @ 04:12 PSTToolsReplyNeed 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
924 Jan 2006 @ 04:08 PSTToolsReplyTpump 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-...
824 Jan 2006 @ 03:43 PSTToolsReplySecure Copytry something sftp...or secure FTP..
724 Jan 2006 @ 03:40 PSTToolsReply.DISPLAY in MLOADmaybe instead of listing the field as empty, populate it with ***** or something unique, see if the script works...
624 Jan 2006 @ 03:36 PSTToolsReplyFastLoad vs NL Charactermaybe define that newline character but not loading it? Hope that helps..
524 Jan 2006 @ 03:26 PSTToolsReplyBatch 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...
424 Jan 2006 @ 03:23 PSTToolsReplyFastload,multiload,fastexport,tpumpTry the documentation website...it has sample scripts.http://www.info.ncr.com/Teradata/eTeradata-BrowseBy.cfm?page=Teradata%20Tools%20and%20Utilities
324 Jan 2006 @ 03:21 PSTToolsReplyFastload 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.
224 Jan 2006 @ 03:18 PSTToolsReplyQuryman ErrorMake sure you have set up the teradata node connection information and all your odbc drivers are up to date.
124 Jan 2006 @ 03:14 PSTToolsReplyQuerying 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.