All forum activity

#DateUserForumTypeThreadPost
4921421 Apr 2015 @ 01:42 PDTKishore_1DatabaseReplyRuleType in tdwm.ruledefsThanks Pierre.Any idea what are the ruletypes designated by 5,6 and 7?
4921321 Apr 2015 @ 01:37 PDTPurushothamDatabaseReplyHow to find the associated tables or view in teradata?HI, could be pls explain me use of QUALIFIED .. without using qualified also we can get :SHOW TABLE <TABLE_NAME> OR sel * from dbc.tables where requexttext like '%table_name%'
4921221 Apr 2015 @ 12:46 PDTchiran54321Teradata StudioReplyTeradata Studio Express - installation error 1311.Source file not foundI would suggest you to extract all the contents from the TeradataStudio ZIP file to a folder and try installing.
4921121 Apr 2015 @ 12:39 PDTjaveed939Teradata ApplicationsTopicBTEQ import not reading and displaying data completelyHi guys, I have problem with below  import bteq script. its not displaying complete out put from the below query in the script. the query is displaying two records when ran from teradata...
4921020 Apr 2015 @ 05:18 PDTfgrimmerTeradata StudioReply[TERADATA STUDIO][SMARTLOAD][Unable to load an ASCII character]Didier, The JDBC Driver should be fine since Studio bundles the latest version. Untranslatable character indicates that the data can not be loaded into the column. What happens when you try UTF-8 f...
4920920 Apr 2015 @ 04:23 PDTfeinholzToolsReplyCalling tbuild.exe directly via command prompt (Windows)Technically, TTU does not support "multiple versions" of the same products on the same machine. This means you need to manipulate environment variables to achieve your goal.   We ...
4920820 Apr 2015 @ 04:19 PDTtoadrwToolsReplyCalling tbuild.exe directly via command prompt (Windows)So the trick is when you have tpt installed, but the tbuild command is not calling TPT is to first try uninstall/reinstall.  If that doesn't work then the next step would be to add the pat...
4920720 Apr 2015 @ 03:46 PDTchandru1979JobsReplyTeradata developer available for projects Teradata developer available for projects Hello Friends, I do have consultant ( Teradata developer ) who is available for the project, His current location is ...
4920620 Apr 2015 @ 02:49 PDTkmanivan82DatabaseTopicStore timestamp with timezoneHi Team, There is a requirement to import record from File into a TD table. There is a timestamp column with timezone. For ex. 03/26/2015 04:00:32 PDT. How to define a field in table to sto...
4920520 Apr 2015 @ 01:50 PDTmadajarTeradata StudioTopicTeradata Studio Express - installation error 1311.Source file not foundI'm trying to install the Teradata Studio Express win 32 x86.15.00.02.00 executable on my windows machine. I do have JRE 1.7 installed (32-bit). I am seeing the following error message within ...
4920420 Apr 2015 @ 01:09 PDTchandru1979JobsTopicTeradata developer available for projectsHello Friends, I do have consultant ( Teradata developer ) who is available for the project, His current location is in NC and he is open for anywhere inside EST on corp to corp basis, b...
4920320 Apr 2015 @ 11:29 PDTPrivate Forum
4920220 Apr 2015 @ 11:27 PDTHarshaKudumulaViewpointTopicIs there a way to pull Lab Group owners other than a portalHi All, I have a requirement to setup alert mechanism to send a notification to Lab Group Owner if the space in the Lab Group reaches the threshold limit. Is any one aware on how to pull the Lab G...
4920120 Apr 2015 @ 11:21 PDTHarshaKudumulaDatabaseReplyStats Manager Issue during Analyze job :Unable to synchronize SystemId: 2 | id: 4 with Teradata on 'AnalyzeJob:5'!Which version are you in?  
4920020 Apr 2015 @ 11:17 PDTHarshaKudumulaViewpointReplyTASM Exception and TASM FiltersThanks Carrie, are you talking about DBMS version or Viewpoint Version? i beleive it is Viewpoint? pelase confirm.
4919920 Apr 2015 @ 11:15 PDTHarshaKudumulaViewpointReplyAutostats Alert SetupThanks Gary, In which version, Teradata planning to setup up this alert feature for AutoStats?
4919820 Apr 2015 @ 11:11 PDTHarshaKudumulaConnectivityReplyConnecting to Teradata from .net application using ODBC/OLEDByou need to install .Net driver to connect via .Net driver. if i didn't answer your question. Elaborate it in detail.
4919720 Apr 2015 @ 10:41 PDTdaeTeradata StudioTopic[TERADATA STUDIO][SMARTLOAD][Unable to load an ASCII character]Hello, Using "Smart Load" Function, I get an error (cf. below) loading my file with a character whose decimal code=130. As an extended ASCII code, I thought that using "File Encodi...
4919620 Apr 2015 @ 10:03 PDTtstrick4DatabaseReplyForce Result Set to Return Column Names and Not Column TitlesAnyone had any luck with this?  Trying to create a Teradata linked server IN MS SQL and but select from views that have column title attributes.
4919520 Apr 2015 @ 08:52 PDTtmcrouseDatabaseTopicCase statement or Where statemetI am trying to code in SQL Assistant something I created in SAS. I am having SAS issues that is why I am trying to use SQL Assistant instead. My code in SAS is: [code] %LET ASM = ('99221'...
4919420 Apr 2015 @ 06:54 PDTadi1209DatabaseReplyNeed Help in Selection -I have an inner query which is something like below -  SELECT C.mstr_tvr_prg_card_id, CASE WHEN MAX(D.TRAN_DT) < CURRENT_DATE -90 then 'Y'  ELSE 'N' &n...
4919320 Apr 2015 @ 06:42 PDTadi1209DatabaseTopicNeed Help in Selection -
4919220 Apr 2015 @ 05:17 PDTTeradata_SADatabaseTopicEXPLAIN - Tag Sort …by way of the sort key in spool field1… Field1 is created to allow a tag sort. This is in the Teradata documentation ref...
4919120 Apr 2015 @ 05:11 PDTtagheDatabaseTopicoptimisation of a query with TRIM function hello everyone.   i have an INSERT query with a subquery like this one:   SELECT 1               FROM SD_CRM.D_INDIV_PREF DIP...
4919020 Apr 2015 @ 04:31 PDTbhartiya007DatabaseTopicdeadlock issue in simultaneous DML statements.Hi All, We have some files which are being loaded to teradata tables. The files are loaded via different pipelines in informatica and parallel insert, update and delete operations are taking place...

Pages