#DateForumTypeThreadPost
47109 Jan 2014 @ 11:20 PSTDatabaseReplyList of all Teradata Column Types with their associated DbTypesHi Seanc, I am not able to understand clearly the requirement. However, with my initial understanding, it seems, you can get details from dbc.columns. select * from dbc.columns. If you want, you c...
47009 Jan 2014 @ 09:02 PSTGeneralReplyHow to use dynamic column name in a query?Hi Jacob, My thought of  bteq as: export the result set from B. Then use "using" at the time of import to resolve  the required query. Please let me know. Cheers,
46909 Jan 2014 @ 08:12 PSTDatabaseReplyInserting multiple values with single quotes in single fieldHi Sunny, The above one I tested it and it works as per your requirement. Test it and see it. You may miss out some quotes. Let me know if you want it otherwise. Cheers,
46809 Jan 2014 @ 04:20 PSTDatabaseReplyImproving perfomance in viewJust my thought: How about a join index? Also a  a row-key based merge join A, B. You can check the explain.  
46709 Jan 2014 @ 04:02 PSTGeneralReplyTeradata Database software Just to share my thought: I work on few tools and databases using just the link(website using username/password and domain) and it is quite handy since no download to laptop.  Those sites &...
46609 Jan 2014 @ 12:52 PSTDatabaseReplyTeradata Spool issue in Recursive issueYou have not told about the tool that reads real time data. In SAP DS for example, reading from wsdl, you can reformat the data in anyway you want and can load to target. If you are using Ab Initi...
46508 Jan 2014 @ 11:24 PSTDatabaseReplyInserting multiple values with single quotes in single fieldI did this way: insert into abc.raja_test1 values('''USA'', ''CHN'', ''IND'', ''GBR'''); I use quote 'USA', 'C...
46408 Jan 2014 @ 10:16 PSTExtensibilityTopicHive I have data like : empid name salary..... 123    Joseph 1900 435     James 2000 675     Perez 6999 ...... 1 million records. ...
46308 Jan 2014 @ 08:45 PSTDatabaseReplyTeradata Spool issue in Recursive issueI feel that sanitation check should be there at each and every stage of data flow. Also Modeler, should check  data matching with end requirements.
46208 Jan 2014 @ 09:27 PSTDatabaseReplyPDCR (Performance Data Collection and Reporting database)Hi Praveen, You can have a look at this discussion. http://forums.teradata.com/forum/database/need-alternative-to-dbql-processing.   Cheers, Raja
46108 Jan 2014 @ 02:20 PSTAnalyticsReplyCall a macro from a stored procedure?   Hi Ratnam, From  (select id,query from ......raja_test where id=1) I get all the fields with id=1. But from outside I select only the query, because I want only the query. I ...
46008 Jan 2014 @ 02:10 PSTDatabaseReplyFind out all the groups in a data. Sachin, I feel you can put the input and output data in tabular format using code , given in format bar. The last part of the data is not clear. It seems that anyone who makes calls from and...
45907 Jan 2014 @ 11:56 PSTDatabaseReplyTeradata Spool issue in Recursive issueRight now I can think think of stored procedure with nested loops, checking with if condition , after stripping each field from resiliation and compare , before inserting to a final table. Cheers,...
45807 Jan 2014 @ 10:29 PSTToolsReplyVariant records and TPTI remember few years back , when I had to clone the QA env to DEV environment, including the entire structure of unix and database. We wrote scripts to automate the entire structure, through unix s...
45707 Jan 2014 @ 03:35 PSTDatabaseReplySpecial charcters/XML Hi Nishant,   Maybe this link will help you? This link is form Dieter's http://forums.teradata.com/forum/database/issue-in-loading-as-first-character-in-the-field &n...
45607 Jan 2014 @ 03:02 PSTDatabaseReplySpecial charcters/XMLAre you facing the same in bteq in unix environment? or you can use Teradata admin tool, Query. Cheers, Raja
45507 Jan 2014 @ 12:58 PSTDatabaseReplyConverting Number to CharacterHi Stiphu, You can cast as you require: /*created table*/ CREATE MULTISET TABLE db1.raja_test ,NO FALLBACK ,      NO BEFORE JOURNAL,      NO AFTER JOU...
45406 Jan 2014 @ 10:56 PSTAnalyticsReplyCall a macro from a stored procedure?You mean only query column thus: select query from (select id,query from EDW01_D_IPA_DV_STG_N_01.raja_test where id=1)a;
45306 Jan 2014 @ 07:12 PSTDatabaseReplyData corruption in SCD 2 dim tableHi Singh, First thing is job security. Take back up always. You have not told about the SCD 2 , whether it is flag, version, start date end date or a combination of these. Sample data ?????? Onc...
45206 Jan 2014 @ 06:37 PSTDatabaseReplyMODE and FORMAT - TD Utilities.Very much you can do.  Also try to cast with the exact number of bytes for the entire  columns when you cast for the entire select and see.  Cheers,  
45106 Jan 2014 @ 04:20 PSTDatabaseReplyMODE and FORMAT - TD Utilities. you can use vi editor to search and replace  unwanted characters --s/ //g  or you can use sed -e 's/ //g'   Also, I hope you are trying tpt:   &nb...
45006 Jan 2014 @ 02:01 PSTDatabaseReplyTeradata Spool issue in Recursive issue Whaw!!!! Even with volatile table or recursive view separately also, it may be slow. Finally you can insert to target table. Have you thought of it? You know the data well, since in your sel...
44905 Jan 2014 @ 09:25 PSTCloud ComputingReplyVMWARE and TD 14.10Hi, I am able to configure the BIOS  my new laptop, through a long R&D, even though Lenovo customer care  does not support . I am able to land on VMWARE and am able to use bteq too. ...
44805 Jan 2014 @ 01:50 PSTToolsReplyVariant records and TPT Have you seen this one where they use APPLY CASE WHEN? It can help you.  http://forums.teradata.com/forum/tools/using-templates-for-operators-provided-in-tpt   Cheers, ...
44704 Jan 2014 @ 08:50 PSTDatabaseReplyPulling Primary/Foreign Key Relationships I hope any of these tables below can help you. DBC.All_RI_Children DBC.All_RI_Parents DBC.RI_Distinct_Children DBC.RI_Distinct_Parents   You can analyze these table ...

Pages