All forum activity

#DateUserForumTypeThreadPost
159214 Aug 2006 @ 01:22 PDTdnoethToolsReplySelect Top 10 recordsHi Vincent,TOP syntax was implemented in V2R6 :-)Dieter
159114 Aug 2006 @ 08:59 PDTven_vickDatabaseTopicWhat are the TD components do we need to install on the Linux with DatastageHi, I am trying to connect to Teradata which is on a windows machine while the Datastage is on the Linux sever. What do I need to install on the linux side apart from the ODBC in order to use the D...
159014 Aug 2006 @ 08:59 PDTven_vickToolsTopicWhat are the TD components do we need to install on the Linux with DatastageHi, I am trying to connect to Teradata which is on a windows machine while the Datastage is on the Linux sever. What do I need to install on the linux side apart from the ODBC in order to use the D...
158914 Aug 2006 @ 08:54 PDTven_vickThird Party SoftwareTopicWhat are the TD components do we need to on Linux with Datastage serverHi, I am trying to connect to Teradata which is on a windows machine while the Datastage is on the Linux sever. What do I need to install on the linux side apart from the ODBC in order to use the D...
158814 Aug 2006 @ 08:53 PDTven_vickThird Party SoftwareTopicWhat are the TD components do we need to on Linux with Datastage serverHi, I am trying to connect to Teradata which is on a windows machine while the Datastage is on the Linux sever. What do I need to install on the linux side apart from the ODBC in order to use the D...
158712 Aug 2006 @ 07:48 PDTDiEgoRUDAReplyHow to fetch packets of records and process them in Teradataon UNIX I would use something like 'fastexport < your_fe_script | split' or even better, just 'fastexport < your_fe_script | your_programm', provided your programm supports pipes. otherwise you cou...
158612 Aug 2006 @ 07:36 PDTDiEgoRUDAReplyNeed to fire 1000 different SQL statements and verify results automaticallyI am not entirely clear what do you mean by verifying results against DB, but if the only thing you need is to compare the results against some fixed values, you could use the http://www.excelsql.c...
158512 Aug 2006 @ 07:23 PDTDiEgoRAnalyticsReplystandard deviation function with parition byif you want to have your information verbatim, then how about using something like SELECT city, state,AVG(population),STDDEV_SAMP (population)from tablenamegroup by 1,2
158411 Aug 2006 @ 05:40 PDTJulieRobinsonJobsTopicTERADATA DBA- Contract to Hire- Omaha, Nebraska12 month contract for hire- with a large stable company in Omaha, Nebraska. please contact julie.robinson@modisit.com if you are interested or know someone who might be.Description of Services: Su...
158311 Aug 2006 @ 03:53 PDTilyasToolsTopicbatch fileI am new to teradata, that's why I am asking a very basic (may be dump question) for many of you. I created a amj file of Multiload through Ole load. How can I created a batch file for next run of ...
158211 Aug 2006 @ 03:49 PDTJim ChapmanDatabaseReplyTeradata and near-line storageNo, not currently.
158111 Aug 2006 @ 11:09 PDTchipper1ToolsTopicSystem Maintenance and deleting from $Netvault_Catalog.catalogHi everybody We want to delete records over 90 days from the $Netvault_Catalog.catalog table, has anyone already done this? Is there a quick solution for deleting records over 90 days? Thanks
158011 Aug 2006 @ 09:09 PDTilyasToolsTopicOleLoadin OLELoad (OLE DB access module) when ever i try to select source or destination a teradata database, i am getting this error."Please select a valid host or edit your c:\....\hosts" file.I edited ...
157910 Aug 2006 @ 04:40 PDTjdartonAnalyticsReplyProvider SyntaxI was able to get mine going by installing the latest TD driver for OLE/DB and using this connection string:Provider=TDOLEDB.1;Data Source=server.com;Persist Security Info=True;User ID=myuserid;Pas...
157810 Aug 2006 @ 04:21 PDTcmarrAnalyticsReplyProvider SyntaxDoes anybody have a solution for this? I had the exact same problem as Misfit and Sputnik and can't seem to resolve it. I also don't want to use SQL Server Providers. I want to user the Teradat...
157710 Aug 2006 @ 03:04 PDTshankargraoDatabaseTopicTeradata and near-line storageFor the sake of this discussion, I am using the phrase 'nearline storage' to refer to the process/solution/technology for moving rarely-used data outside the DATABASE and to a cheaper storage syste...
157610 Aug 2006 @ 02:48 PDTVincent GabrielliToolsTopicSelect Top 10 recordshello folks, trying to perform the following SELECT TOP 10 call_session_idFROM etlbase.vivr_call_dtlto get the top 10 records of the table. However, I get the following error: 3706: Syntax error: e...
157510 Aug 2006 @ 12:14 PDTFredToolsReplymload got stuckYour example shows a space in the .SYSTEM string - so the OS sees "D:\" as the (invalid) command and "paging.pl" as the argument.Windows default error handling mechanism is to display a modal dialo...
157410 Aug 2006 @ 11:31 PDTmeet_asToolsTopicmload got stuckHi ,I have a mload script that raises the pager if there is any application error table created. I have placed the paging part after the .END MLOAD command as shown below-/* End the load process. *...
157310 Aug 2006 @ 10:49 PDTRob_KahnToolsTopicUser Defined InputOracle has a command that allows a user to input a variable and then that variable gets used in the SQL.-----------Example:Select dataFrom table1WhereTO_NUMBER(TO_CHAR(db1.table1.effective_dt,'YYYY...
157210 Aug 2006 @ 10:21 PDTkjohnson-3035JobsReplyVirtual Teradata DBA*
157110 Aug 2006 @ 09:39 PDTkjohnson-3035JobsTopicVirtual Teradata DBADoes anyone know of any Teradata DBA positions that are 90-100% telecommute/work from home ?
157010 Aug 2006 @ 05:18 PDTdeeps_v_37DatabaseReplyNUSI Bitmapping?Yeah..Optimizer NEEDS statistics to be collected on NUSI's to decide between Full table scan and NUSI bitmapping.* But its not true that collecting statistics on NUSI's itself makes the optimizer s...
156910 Aug 2006 @ 03:37 PDTBijuJobsTopicTeradata DBAHi All,We are looking for Teradata DBA's with exp from 3 to 6yrs.Location would be Chennai, India.Those interested may reply with Cv to biju@synovaindia.com
156809 Aug 2006 @ 07:43 PDTJohn MacDatabaseReplyCancelling Rollback on a PPI tableFred,Thanks for your reply.ALTER in conjunction with adding/dropping partitions on a PPI table is perhaps a bit different to 'normal' DDL. There's a substantial amount of data deleted and inserted ...

Pages