All forum activity

#DateUserForumTypeThreadPost
119226 Jun 2006 @ 03:46 PDTAmitToolsReplySQL problemThanks Dieter for your response.If I use this SQL then it will return me with all the customers having data for 6 months only. But this is not my requirement. I need customers having CONSECUTIVE 6 ...
119125 Jun 2006 @ 06:39 PDTVesoniConnectivityReplyInserting strings in UTF-8 Teradata using JDBCAny idea?getString() i setString() work fine, but setString() just for ASCII chars. For others (example for Central Europe code page) insert "?" in database. getString() read every chars normal.Is ...
119024 Jun 2006 @ 11:52 PDTBBR2DatabaseReplyIdentifying invalid views?I wrote a bteq script which helps in identifying invalid views under a particular parent (eg SOUTHEASTDW in this case).It is run in windows enviornement (file/etl server) but can easily be changed ...
118923 Jun 2006 @ 03:09 PDTMattW At ATTAnalyticsReplyCreate Volatile Table not working with TrimThanks Dieter. As an Aside, while it did not work in Create AS, if I create the Table seperately, and Insert, it works fine...
118823 Jun 2006 @ 02:34 PDTdnoethAnalyticsReplyCreate Volatile Table not working with TrimHi Matt,it's not the TRIM it's LENGTH:This is no Teradata SQL, it's ODBC SQL, so replace it with CHAR_LENGTH and your query will run.The reason why it worked without the volatile table is an option...
118723 Jun 2006 @ 02:23 PDTdnoethToolsReplySQL problemHi Amit,it's easy if you know how to write a WHERE-condition to filter for data from the last 6 months:select cust_nfrom tabwhere ...group by cust_nhaving count(distinct tr_month) = 6But as the nu...
118623 Jun 2006 @ 12:46 PDTMattW At ATTAnalyticsTopicCreate Volatile Table not working with TrimI am trying to create a volatile table with the following slection criteria.CREATE VOLATILE TABLE DSL3 AS(Select BTN (CHAR(13)) BTN, Case When substr( trim(BILLED_CITY_STATE) ,(length (...
118523 Jun 2006 @ 10:00 PDTAmitToolsTopicSQL problemHi All,We have a requirement wherein we need to gather the list of customers having transaction accounts in the last consecutive 6 months.A customer can have more than one account & irrespective of...
118423 Jun 2006 @ 07:58 PDTVesoniConnectivityTopicInserting strings in UTF-8 Teradata using JDBCHi,How can insert UTF-8 bytes in Teradata in java using Teradata JDBC drivers?When I try with setBytes(int index, bytes[]) methodI get Conversion bteween BYTE data and other types is illegal.Any he...
118323 Jun 2006 @ 12:21 PDTFredToolsReplyUtilities downloadThere is no Teradata SQL Assistant 8.1 yet; I presume you mean the version included in the current TTU8.1 bundle - which would be SQL Assistant 7.1.If you have access to "My SupportLink" through Te...
118222 Jun 2006 @ 04:37 PDTBBR2DatabaseReplyDuplicate valueYou may do a INSERT..SELECT from a MULTISET (duplicate rows) to a SET table for ignoring duplicates.Fastload can kickout the duplicates while MLOAD has "IGNORE DUPLICATE" option which can be used.Y...
118122 Jun 2006 @ 04:34 PDTBBR2UDAReplyParsing of fields in outputIt is possible but may not yield correct results as some names can be real long for instance my nameVInay Kumar Bagare.Vinay Kumar is my first Name.... huh! Vinay
118022 Jun 2006 @ 01:25 PDTjs6465UDAReplyParsing of fields in outputUnfortunately it is not seperated by a comma but by a Space. Is there a way to code it to account for the space like you have done for a comma?
117922 Jun 2006 @ 01:08 PDTBBR2UDAReplyParsing of fields in outputThis may be possible if the First and last name are separated by Comma (or something other than a space.)assuming that it is a "," separated field, you could useSEL 'Bagare, Vinay' AS Str,TRIM(SUBS...
117822 Jun 2006 @ 01:02 PDTBlack BirdToolsTopicUtilities downloadI need to download the new version to TeraData SQL Assistant (i.e., version 8.1). I am not able to find that on the teradata.com website.Can anyone point me to the location from where I can downloa...
117722 Jun 2006 @ 12:30 PDTjs6465UDATopicParsing of fields in outputI have a question regarding the parsing of fields in output. For example, if my table has a field called Full_Name, and I want the output to be in First_Name and Last_Name, how could that be done? ...
117622 Jun 2006 @ 11:51 PDTBBR2UDAReplyP**** City State ZipUse this SEL CITY,STATE,ZIP FROM (SEL 'BAY CITY TX 77414' AS Str ,CHARACTER_LENGTH(Str) AS MAX_CHR ,CAST((TRIM(SUBSTRING(STR FROM (MAX_CHR-5) FOR MAX_CHR)))AS INT) AS...
117522 Jun 2006 @ 10:18 PDTtableUDAReplyP**** City State Zipsubstr(yourString, -5, 5) for zip codesubstr(yourString, -8, 2) for state [including a space before zip]rtrim(yourString, 9) without comma between city and state for city orrtrim(yourString,...
117422 Jun 2006 @ 09:37 PDTTDUser-781DatabaseReplyDuplicate valueHi,are you thinking about duplicate rows or duplicate PI values?If you're thinking about duplicate rows, then you'll probably have a multiset table with a NUPI on it.1- if you don't want to have du...
117322 Jun 2006 @ 09:31 PDTVesoniConnectivityReplyConnect to Teradata database from web application using JDBCHi,I'm using Tomcat Web server for our corporative web applications.I created database pool for Teradata (like for Oracle) and everything working fine.There is properties for server.xml file.(see a...
117222 Jun 2006 @ 05:59 PDTmanjaDatabaseReplyDuplicate valuehello,If you want to stop loading duplicate values for a particular column make that column a unique primary index.
117122 Jun 2006 @ 04:42 PDTscorpDatabaseTopicDuplicate valueAll waiting for the kind response of all friends1- How to stop the insert of duplicate value in a table.2- If fast load failed inserting the duplicate value in a table how this problem will be reso...
117022 Jun 2006 @ 12:41 PDTcsbAnalyticsReplyComparing Date with Decimal ColumnTry this.sel * from tablenamewhere columna = 'bcd'and '03/01/06' between cast(col1 as date format 'mm/dd/yy') and cast(col2 as date format 'mm/dd/yy') ;
116921 Jun 2006 @ 09:06 PDTKksToolsReplyRights and UsersI think use Teradata Administrator tool ,for more ease
116821 Jun 2006 @ 02:49 PDTshaik.feroz@aaa-calif.comThird Party SoftwareTopicIssue using Informatica to load Teradata tables.I have an issue while loading data from sql server to Teradata database. It takes a very long time to load 100K rows. when i checked the log I guess it is doing a row level insert instead of a bulk...

Pages