All forum activity

#DateUserForumTypeThreadPost
96719 May 2006 @ 03:53 PDTdcasadyConnectivityReply*** Failure 7566 The protected mode user is not defined; cannot execute UDFA DBS restart resolved the issue following the creation of the user on the UNIX nodes. As the database recovered, it configured the protected mode UDF functionality.
96619 May 2006 @ 11:54 PDTdnoethUDAReplySQL to retrieve datatype of a column> select distinct type(my_foo_col) from foobar;will be heavily skewed (all rows on a single AMP)Better use: select type(foobar.myfoocol);Don't ask me why, but this is not accessing the table: -> T...
96519 May 2006 @ 11:41 PDTMaranga-1667DatabaseTopicTeradata V2R6.01People,we are about to upgrade to Teradata V2R6.01, we are actually in V2R5.01. We think that we are making a big step.Does any of you have tested something in this new version? We have a Single No...
96419 May 2006 @ 02:14 PDTANGELDatabaseTopicData DistributionHi,Suppose we have a 10 AMP system. I have a table with 5 rows. How will the rows be distributed on the 10 AMP system.ThanksAngel
96318 May 2006 @ 03:31 PDTshaik.feroz@aaa-calif.comDatabaseReplyReverse string search (right to left)?Thanks!I am on V2R5
96218 May 2006 @ 12:44 PDTj355gaDatabaseReplyReverse string search (right to left)?Are you on V2R6? WITH RECURSIVE is only supported in V2R6.
96118 May 2006 @ 10:59 PDTshaik.feroz@aaa-calif.comDatabaseReplyReverse string search (right to left)?Jeff,I was getting an error while executing the query you provided.failure 3706 syntax error: expected something between the beginning of the request and the 'with' keyword.I was using bteq.Thanks
96018 May 2006 @ 10:29 PDTj355gaUDAReplySQL to retrieve datatype of a columnselect type(my_foo_col) from foobar group by 1;orselect distinct type(my_foo_col) from foobar;
95918 May 2006 @ 09:46 PDTrlaskarUDATopicSQL to retrieve datatype of a columnHi,I was trying to identify the datatype of a column using teradata SQL. While TYPE returns datatype of the column for all rows. So if it's 1000's of record in a column then using TYPE for that col...
95818 May 2006 @ 04:02 PDTDGiabbaiDatabaseReply10065 WSA E HostUnreachTeradata, by default, requires port 1025 for client utilities to access the RDBMS. Make sure that no software program is obtaining that port other than Teradata (there is a windows service, "Terada...
95717 May 2006 @ 10:12 PDTnithyanandamDatabaseReply10065 WSA E HostUnreachWell, BTEQ gives me the following error:*** Warning: RDBMS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS>So???
95617 May 2006 @ 07:09 PDTdurga9ConnectivityReplyProblem with Linux TeraJDBC.03.02.00.03 driver.I am getting similar error. This is simple java program to connect and run select from teradata db. I have tgdssjava.jar, and terajdbc4.jar files on class path. But I cannot find the tdgssconfig.ja...
95517 May 2006 @ 06:29 PDTj355gaUDAReplyMload delimited file with delimiter embedded in fieldExample of MLOAD using pipe delimiters.LOGTABLE ML_FOO;.LOGON ......BEGIN IMPORT MLOAD SESSIONS 4 TABLES FOO WORKTABLES WT_FOO ERRORTABLES ET_FOO UV_FOO ERRLIMIT 100;.LAY...
95417 May 2006 @ 02:41 PDTvictor4techAnalyticsTopicHow to format the output in teradataHi,I am a newbie and just trying a simple thing which I am finding hard to do. I want to format the output and see the formatted result. I used to write this command in Oracle but it doesn;t work h...
95317 May 2006 @ 02:22 PDTj355gaDatabaseReplyReverse string search (right to left)?This sql will search a string from left to right using recursive SQL. The output is the LAST section of the string where string is divided with the "_" character. You can probably modify it to sea...
95217 May 2006 @ 02:06 PDTNytewyndConnectivityReplyMS Access repeating Selects via ODBCIn oracle, I created an application that allowed the users to upload their tables into their schema using access and ODBC, then in a web application they could pick their tables from a drop down bo...
95117 May 2006 @ 01:27 PDTBobJConnectivityReplyMS Access repeating Selects via ODBCEasier said than done. Non-savvy Teradata users have no clue about creating DDL, then loading a Teradata table (even in a "special" database). MS Access has an established niche. Of course one ca...
95017 May 2006 @ 12:19 PDTshaik.feroz@aaa-calif.comUDAReplyAmp lock table overflow.Found the cause:Too many transactions running at the same time.
94917 May 2006 @ 12:18 PDTshaik.feroz@aaa-calif.comDatabaseReplyThe AMP Lock table has overflowedFound the cause:Too many transactions running at the same time.
94817 May 2006 @ 12:02 PDTshaik.feroz@aaa-calif.comUDATopicAmp lock table overflow.Hi All,I am using informatica to load data from MSSQL tables to Teradata.This is the error that I am getting while loading data into a few tableWRITER_1_*_1> WRT_8229 Database errors occurred: FnNa...
94717 May 2006 @ 12:01 PDTshaik.feroz@aaa-calif.comDatabaseTopicThe AMP Lock table has overflowedHi All,I am using informatica to load data from MSSQL tables to Teradata.This is the error that I am getting while loading data into a few tableWRITER_1_*_1> WRT_8229 Database errors occurred: FnNa...
94617 May 2006 @ 11:56 PDTDGiabbaiConnectivityReplyMS Access repeating Selects via ODBCWhen submitting an MS Access query, the RDBMS engine used is Access. Which would be the advantage of having a powerful Teradata system, if you let your users use the Access engine to run queries? W...
94517 May 2006 @ 09:49 PDTBobJConnectivityReplyMS Access repeating Selects via ODBCMy first reaction was to forbid the use of MS Access tables in queries going against Teradata. However, we have not a few, but hundreds of users doing this (and it's spreading). So, it would be f...
94417 May 2006 @ 09:36 PDTsimplexJobsTopicTERADATA developer at Columbus, OHIO -- Sure shotLooking for a TERADATA developer at Columbus, OHIO.Rate: $bestPlease email resume to resumes@simplexinfo.com
94317 May 2006 @ 09:32 PDTNytewyndConnectivityReplyMS Access repeating Selects via ODBCIn general, running queries through Access is not going to be very efficient, especially over an ODBC connection. Can you move your Access table into Teradata and run the query on the server? You...

Pages