All forum activity

#DateUserForumTypeThreadPost
1599016 Jun 2010 @ 10:01 PDTflash7gordonConnectivityTopicteradata client install a no show in odbcHi, We installed this teradata driver: cliv2_WINDOWS_x8664.13.00.00.01.ZIP on a windows 2008 box. It's a 64 bit teradata driver. But when I go to add a System DSN in ODBC, none of...
1598916 Jun 2010 @ 09:36 PDTflash7gordonConnectivityTopicwhat does the teradata client point to?Hi, I'm using the r13 client tools and they work fine on my laptop. But now I have to install the client tools/odbc/oledb on a server that are generic so I need to point at the internal te...
1598816 Jun 2010 @ 08:38 PDTTnewbeeDatabaseReplyCapture the data while updating a tableThanks for ur reply! I have added a flag which I will be setting whenever a record gets updated. In this way after all updates, I can use the flag to find the updated records.
1598716 Jun 2010 @ 06:04 PDTstuffie0912DatabaseReplytable size without indexesUsing the example above...(shown below) Can I calculate total table size for all tables of a specific user? _____ select databasename, tablename, sum(currentperm) from dbc.tablesize where ...
1598616 Jun 2010 @ 06:02 PDTstuffie0912AnalyticsTopicusing dbc.tablesize, determine total tablesize for a specific userUsing TD SQL Assistant, how can I find the total size of all my tables I have created? Just for my username. What statistics are in dbc.tablesize? will it collect tablesize info for tables...
1598516 Jun 2010 @ 06:02 PDTarcher007GeneralReplyPrimary Index Reducing SpaceThanks dnoeth for your reply. We didn't specify PI, so you may be right, first column would have been take as PI. Could you please explain little more about AMP distribution with the help of an exa...
1598416 Jun 2010 @ 04:17 PDTAdeel ChaudhryExtensibilityReplyExternal Store procedure to read a local client fileThe process of "call parseFile('filename');" can be easily achieved using a combination of UDFs and SPs. UDFs for reading data from file and SPs for using that data and INSERTs/UPDATEs. Regards,...
1598316 Jun 2010 @ 04:06 PDTAdeel ChaudhryMarketing & CRMReplyI need a MACRO that will allow the User to define the tableCan you please provide more details what exactly you are trying to achieve?
1598216 Jun 2010 @ 04:05 PDTAdeel ChaudhryMarketing & CRMReplyC++ compilerTeradata requires C++ compiler .... the question of "what compiler" depends on the answer of "what OS". You can get the list of supported OS and C++ compiler from help/support. Regards, MAC
1598116 Jun 2010 @ 04:00 PDTAdeel ChaudhryAnalyticsReplyNeed help on logic!Hi, What is "Tasks" column in second table? Can you provide 1 detailed example of what are the inputs and what exactly are you trying to achieve? Regards, MAC
1598016 Jun 2010 @ 03:45 PDTAdeel ChaudhryDatabaseReplyCapture the data while updating a tableHi, Triggers would be your best bet .... but as you mentioned you are not allowed to use them .... can you share some UPDATE statements to clear the overall picture? Regards, MAC
1597916 Jun 2010 @ 03:42 PDTAdeel ChaudhryGeneralReplyProblem with Extented Ascii dataHi, Can you please mention from which tool you are trying to read data? Regards, MAC
1597815 Jun 2010 @ 11:13 PDTChandooTrainingReplyWant Teradata SQL TutorialHi Request to all. currently I am wokring in DB2. I am learning teradata. Kindly forward teradata SQl material. please. My mail id : chandooncr@gmail.com Thanks in advance.
1597715 Jun 2010 @ 10:54 PDTdnoethGeneralReplyPrimary Index Reducing SpaceWas it really a NOPI-table in TD13 defined with NO PRIMARY INDEX or did you just omit the PI definition? What does a SHOW TABLE return? If it actually was a NOPI table then there migth have be...
1597615 Jun 2010 @ 08:45 PDTarcher007GeneralTopicPrimary Index Reducing SpaceHi, I did the following 1) First, I fastloaded a flat file [Record count: 184368033 ] in to a table [Table column length: 231] that does not have primary index. After loading 1/6th of the fil...
1597515 Jun 2010 @ 04:39 PDTJim ChapmanDatabaseReplylength of the stringUse the standard SQL function CHARACTER_LENGTH.
1597415 Jun 2010 @ 04:20 PDTtparvaizDatabaseTopiclength of the stringHi I want to know how to do something like this in teradata (case when LENGHT(a.address) > 5 then a.address else a.other_address end) If the lenght of the address is greater than 5 characters...
1597315 Jun 2010 @ 12:52 PDTl.kDatabaseReplyIncremental / Differential backup in Teradata...Hi pawan, How to enable AFTER permanent journaling at database level and table level?
1597215 Jun 2010 @ 11:54 PDTnwojackJobsReplyCertified Teradata DBA - Richmond, VA - 12 month contractEmail your resume to me - nwojack@visionit.com
1597115 Jun 2010 @ 11:53 PDTnwojackJobsTopicCertified Teradata DBA - Richmond, VA - 12 month contractThis position is for a senior level database administrator, preferably Teradata administrator, who is responsible for design, development and administration of large scale (500Gb - 2TB in size) ana...
1597015 Jun 2010 @ 11:04 PDTTnewbeeDatabaseReplyCapture the data while updating a tableAnyobody with any suggestions? BTW, we are not allowed to use a trigger or stored procedure.
1596915 Jun 2010 @ 10:34 PDTnambiaruveetilDatabaseTopicIdentifying BTEQ Name from QuerylogProblem statement - We need a process to tie the Querylog to the BTEQ ? Is there some option in Teradata to capture the BTEQ Name from Query Log. ? Can we use PROCID or is there any other option ?
1596815 Jun 2010 @ 09:19 PDTTnewbeeDatabaseTopicCapture the data while updating a tableHi all! I have a sequence of update queries on a very huge table TableA. Now when it updates the table I want to capture all the primary key of the records getting updated. This primary key will...
1596715 Jun 2010 @ 08:25 PDTdnoethDatabaseReplyMulitple Row values into a sinlge Column...Two ways to achieve that result set: select paycode1 from tab where paycode1 '' union all select paycode2 from tab where paycode2 '' union all ... or a Cross Join to a helper table: se...
1596615 Jun 2010 @ 07:34 PDTl.kDatabaseTopicMulitple Row values into a sinlge Column...Hi, I have a scenario to combine all the column's value in a single column.For example,we have 5 columns like Pay_code1,Pay_code2,Pay_code3,Pay_code4 and Pay_code5.Each column will contain val...

Pages