373 | 02 Jul 2012 @ 12:42 PDT | General | Reply | How to find the parent and child relationship between tables in Terdata by using Dictonary tables? |
I assume your question relates to referential integrity .... you can use following objects to get desired information:
DBC.All_RI_Children -> defined referential con... |
372 | 02 Jul 2012 @ 12:33 PDT | General | Reply | How to display the last 3 characters of lastname? |
In case CHARACTERS doesn't work, you can also use CHARACTER_LENGTH function to get the length of character field.
HTH!
|
371 | 29 Jun 2012 @ 04:10 PDT | UDA | Reply | Compiling Stored Proc - VC++ not installed error |
Which verison of TD you are using?
Regards, Adeel
|
370 | 29 Jun 2012 @ 04:06 PDT | UDA | Reply | TeraData vs Oracle |
Hi,
I think following link should help you:
http://downloads.teradata.com/download/extensibility/teradata-udfs-for-popular-oracle-functions
Regards, ... |
369 | 29 Jun 2012 @ 04:02 PDT | General | Reply | Teradata Functions |
If you are joining as a fresher, am sure the organization will guide you through it.
Cheers.
|
368 | 29 Jun 2012 @ 03:57 PDT | Database | Reply | What are the General roles & responsibilities of a TERADATA DEVELOPER |
Hi,
In which context are you asking that? As a future developer, or for certifications?
Regards, Adeel
|
367 | 02 Apr 2012 @ 02:52 PDT | Database | Reply | Converting Multiple rows of data into one row... |
Hi,
You can do it either by using recursive view, or by looping in a procedure.
Regards, Adeel
|
366 | 02 Apr 2012 @ 02:45 PDT | General | Reply | table does not exist |
Hi,
In such a case, table is expected to be in a database where it is not. Try by fully qualifying the table name in the procedure.
Regards, Adeel
|
365 | 02 Apr 2012 @ 02:44 PDT | General | Reply | Installation and connection profile |
Hi,
Using Teradata SQL Assistant .... you can connect using Teradata .Net Connector or ODBC DSN source .... login and password should be dbc.
Regards, Adeel
|
364 | 02 Apr 2012 @ 02:42 PDT | General | Reply | SQl for current period and Previous period |
Hi,
You can use calenders to get the min and max from within a month.
Regards, Adeel
|
363 | 05 Dec 2011 @ 02:13 PST | Database | Reply | End Dating Previous Relations |
Hi,
All you have to do is to rank them on start_dt and self join with rank - 1 and you will get what you desire.
Regards, Adeel
|
362 | 05 Dec 2011 @ 02:09 PST | General | Reply | Stored Procedure Configuration -- RegOpenKeyEx Failed. |
Hi,
I have Teradata 13 installed with Visual C++ 2008 Express and it works fine, can you try that?
Regards, Adeel
|
361 | 01 Nov 2011 @ 01:29 PDT | Database | Reply | Alternative to oracle procedure |
Are you facing any specific problem? or are you just seeking someone to do work on your behalf? :)
Regards, Adeel
|
360 | 19 Oct 2011 @ 02:56 PDT | UDA | Reply | Multiple Case Statements |
Yes, by DDL I meant table definition .... though it is abbreviation of Data Definition Language.
|
359 | 18 Oct 2011 @ 09:21 PDT | Database | Reply | How to store and display a german umlaut? |
Hi,
UNICODE should fix the issue. I am using following and i can see it properly when selecting:
CREATE SET VOLATILE TABLE Table1 ,NO FALLBACK ,
&nbs... |
358 | 18 Oct 2011 @ 09:10 PDT | UDA | Reply | Multiple Case Statements |
Hi,
Please allow me to say one thing .... if you are not sharing DDLs it makes our life horrible IF we chose to assist in your issues. Reason being .... now i'll have to figur... |
357 | 18 Oct 2011 @ 09:04 PDT | General | Reply | Not able to access table after Macro Fails |
Curious .... what makes you believe blocking session will not show up in PMON?
|
356 | 17 Oct 2011 @ 09:42 PDT | UDA | Reply | Stored Procedure Issue |
It should work fine, i tired with dummy definition of tables and SP you are calling in a loop.
Can you share DDLs for tables and SPs for further analysis?
Regards, ... |
355 | 17 Oct 2011 @ 09:34 PDT | UDA | Reply | Multiple Case Statements |
As requested earlier, please share DDL, data and SQL you get errors in!
The SQL you wrote above is perfectly fine:
Case when A.APPL_DOB_CFRM_CN is ... |
354 | 17 Oct 2011 @ 03:10 PDT | Analytics | Reply | SQL help - Median, 75th percentile price |
Hi,
There is a very nice article from our most active forum member Dnoeth on this topic. Link is as follows:
http://developer.teradata.com/blog/dnoeth/2011/06/missi... |
353 | 17 Oct 2011 @ 03:06 PDT | UDA | Reply | Multiple Case Statements |
Hi,
You can surely use CASE combinations .... better to use paranthesis for clearer SQL.
Another option is to use a DECODE UDF for Teradata, available at: http... |
352 | 17 Oct 2011 @ 02:58 PDT | Database | Reply | increase size of teraData database |
For the demo version, limit is still 4 GB .... doesnt really makes sense for a demo version to have more than that.
Regards, Adeel
|
351 | 17 Oct 2011 @ 02:56 PDT | Database | Reply | How to compare data from tables in Teradata with tables in Oracle |
Hi,
Is it possible for you to look into INMOD option? Or can you load the TIMESTAMP such as "12-07-2011:23:58:23" as VARCHAR(19) and then process using SQL?
... |
350 | 17 Oct 2011 @ 02:51 PDT | General | Reply | Not able to access table after Macro Fails |
Hi,
While executing SELECT/INSERT/DELETE/DROP on the table, can you login PMON and check if your request is blocked by another session?
Regards, Adeel
|
349 | 13 Oct 2011 @ 01:34 PDT | Analytics | Reply | Row counts for every table in a given database |
satishkumar206 .... please post new questions in new threads!
|