|49214||21 Apr 2015 @ 01:42 PDT||Kishore_1||Database||Reply||RuleType in tdwm.ruledefs||Thanks Pierre.Any idea what are the ruletypes designated by 5,6 and 7?
|49213||21 Apr 2015 @ 01:37 PDT||Purushotham||Database||Reply||How 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%'
|49212||21 Apr 2015 @ 12:46 PDT||chiran54321||Teradata Studio||Reply||Teradata Studio Express - installation error 1311.Source file not found||I would suggest you to extract all the contents from the TeradataStudio ZIP file to a folder and try installing.
|49211||21 Apr 2015 @ 12:39 PDT||javeed939||Teradata Applications||Topic||BTEQ import not reading and displaying data completely||Hi 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... |
|49210||20 Apr 2015 @ 05:18 PDT||fgrimmer||Teradata Studio||Reply||[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... |
|49209||20 Apr 2015 @ 04:23 PDT||feinholz||Tools||Reply||Calling 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 ... |
|49208||20 Apr 2015 @ 04:19 PDT||toadrw||Tools||Reply||Calling 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... |
|49207||20 Apr 2015 @ 03:46 PDT||chandru1979||Jobs||Reply||Teradata developer available for projects||
Teradata developer available for projects
I do have consultant ( Teradata developer ) who is available for the project, His current location is ... |
|49206||20 Apr 2015 @ 02:49 PDT||kmanivan82||Database||Topic||Store timestamp with timezone||Hi 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... |
|49205||20 Apr 2015 @ 01:50 PDT||madajar||Teradata Studio||Topic||Teradata Studio Express - installation error 1311.Source file not found||I'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 ... |
|49204||20 Apr 2015 @ 01:09 PDT||chandru1979||Jobs||Topic||Teradata developer available for projects||Hello 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... |
|49203||20 Apr 2015 @ 11:29 PDT||Private Forum |
|49202||20 Apr 2015 @ 11:27 PDT||HarshaKudumula||Viewpoint||Topic||Is there a way to pull Lab Group owners other than a portal||Hi 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... |
|49201||20 Apr 2015 @ 11:21 PDT||HarshaKudumula||Database||Reply||Stats Manager Issue during Analyze job :Unable to synchronize SystemId: 2 | id: 4 with Teradata on 'AnalyzeJob:5'!||Which version are you in?
|49200||20 Apr 2015 @ 11:17 PDT||HarshaKudumula||Viewpoint||Reply||TASM Exception and TASM Filters||Thanks Carrie, are you talking about DBMS version or Viewpoint Version? i beleive it is Viewpoint? pelase confirm.
|49199||20 Apr 2015 @ 11:15 PDT||HarshaKudumula||Viewpoint||Reply||Autostats Alert Setup||Thanks Gary, In which version, Teradata planning to setup up this alert feature for AutoStats?
|49198||20 Apr 2015 @ 11:11 PDT||HarshaKudumula||Connectivity||Reply||Connecting to Teradata from .net application using ODBC/OLEDB||you need to install .Net driver to connect via .Net driver. if i didn't answer your question. Elaborate it in detail.
|49197||20 Apr 2015 @ 10:41 PDT||dae||Teradata Studio||Topic||[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... |
|49196||20 Apr 2015 @ 10:03 PDT||tstrick4||Database||Reply||Force Result Set to Return Column Names and Not Column Titles||Anyone 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.
|49195||20 Apr 2015 @ 08:52 PDT||tmcrouse||Database||Topic||Case statement or Where statemet||I 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:
%LET ASM = ('99221'... |
|49194||20 Apr 2015 @ 06:54 PDT||adi1209||Database||Reply||Need Help in Selection -||I have an inner query which is something like below -
WHEN MAX(D.TRAN_DT) < CURRENT_DATE -90 then 'Y'
ELSE 'N' &n... |
|49193||20 Apr 2015 @ 06:42 PDT||adi1209||Database||Topic||Need Help in Selection -|| |
|49192||20 Apr 2015 @ 05:17 PDT||Teradata_SA||Database||Topic||EXPLAIN - 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... |
|49191||20 Apr 2015 @ 05:11 PDT||taghe||Database||Topic||optimisation of a query with TRIM function||
i have an INSERT query with a subquery like this one:
FROM SD_CRM.D_INDIV_PREF DIP... |
|49190||20 Apr 2015 @ 04:31 PDT||bhartiya007||Database||Topic||deadlock 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... |