All forum activity

#DateUserForumTypeThreadPost
1015317 Dec 2008 @ 12:15 PSTbalachandra-7286ToolsReplyfastload script insert phase error.give set record vartext display_errors "|";hope, it will work.
1015216 Dec 2008 @ 02:07 PSTkhp2332ToolsTopicfast exportI am new to teradata and is currently working on accessing teradata server to fetch records from a particular table in to a text file. Have installed teradata sql client on my workstation (windows ...
1015116 Dec 2008 @ 11:09 PSTdiw07DatabaseReplyJoin with Different Data Formatswell I would not be selecting the string... But the column that contains it? Also, just add any possibility of letter?
1015016 Dec 2008 @ 10:15 PSTPetr HorcickaDatabaseReplyJoin with Different Data FormatsHi, you are right, conversion to integer doesn't support letters. If there are a reasonable number of letters, you can try something like CASE LIKE ANY construction, depending on what do you want i...
1014916 Dec 2008 @ 08:41 PSTajai_47ToolsTopicFacing Issue while Using Import in BTeqSET WIDTH 80; SET PAGELENGTH 1; SET ECHOREQ OFF; SET HEADING ''; SET SEPARATOR ''; ...
1014815 Dec 2008 @ 10:40 PSTambiToolsTopicfacing BTEQ issuewe are facing weired issue while invoking BTEQ from UNIX....we have bunch od BTEQ's in shell script and they run one after another...it runs fine and suddenly for bunch of BTEQ's log files come up ...
1014715 Dec 2008 @ 05:10 PSTwannabe_guruToolsReplyusing OREPLACE functionDieter, This column is set up as a UNICODE column in the table.SQL Assistant was used to generate the example.Pasted answ...
1014615 Dec 2008 @ 02:24 PSTdiw07DatabaseTopicJoin with Different Data FormatsI keep getting the error "Bad character in format or data of VLTC_ER_COV_MO.I_IRD"An example of a string in i_ird would be "00574286073740714EE19770516F"There are cases where there is a letter in t...
1014515 Dec 2008 @ 01:14 PSTsean.laughlinJobsTopicContract to Hire Lead DW/BI Architect Northern Chicago burbsWe have supported this client on numerous successful recruitments for their BI/DW group and are their first choice in outside vendors. The client is currently seeking to engage a high level Lead BI...
1014415 Dec 2008 @ 01:08 PSTtimchorleDatabaseReplySub-Query Join and Union ProblemHi there much appreciated, in fact that gave me about a 25% savings in time alone. This is the version Im working from : VERSION 06.02.02.56RELEASE V2R.06.02.02.56I have some work guidlines around ...
1014315 Dec 2008 @ 11:36 PSTannal.tamizhnambiDatabaseReplyRegarding Identity numbers generation by PE/AMPSThanks for the info!!!I'm fine with the gaps.I wanted to know if at all there would be any scenario where we would run out of numberseven if we have not inserted the allowable count of records due ...
1014215 Dec 2008 @ 11:01 PSTdnoethDatabaseReplyRegarding Identity numbers generation by PE/AMPSHi Annal,each AMP/PE requests a bunch of values (by default 100000) and then assignes those values one after the other, just like a sequence in Oracle.But sequence values are assigned by muliple AM...
1014115 Dec 2008 @ 10:48 PSTdnoethDatabaseReplyHow to make date logic/math use a date partitionHi Dennis,you must be running a release pre-TD12, because this version should work the way you want it.You might try a Derived Table/View with calculated columns, maybe the optimizer does a product...
1014015 Dec 2008 @ 10:41 PSTdnoethDatabaseReplySub-Query Join and Union ProblemHi Tim,first of all you should check if you can replace the UNION with a UNION ALL.UNION is automatically DISTINCT, which is a huge overhead.This should help already.If it's still not fast enough p...
1013915 Dec 2008 @ 10:06 PSTtimchorleDatabaseTopicSub-Query Join and Union ProblemIf someone could please help, basically I can't optimize my query cause I want to join on 3 union tables – which can’t “see” within scope I guess, what came before:My real code is far more ...
1013814 Dec 2008 @ 12:59 PSTannal.tamizhnambiDatabaseTopicRegarding Identity numbers generation by PE/AMPSHi all,I have some doubts on Identity numbers generated by PE/AMPs.Say my Identity column is a smallint and say i define the start and end number as 1 to 32000and my Batch generation number is 1000...
1013714 Dec 2008 @ 06:36 PSTidontknowDatabaseReplyHow to make date logic/math use a date partitionWhy not write an sql statement which will dynamically output the sql statement you need to execute (with the date range hardcoded in order to make use of the PPI), this dynamic SQL can then be run ...
1013613 Dec 2008 @ 09:12 PSTgander_ssDatabaseReplyHow to make date logic/math use a date partitionHi,can u please post the PPI statement used in table DDL.Also post the column info of PI And SI on the table.And is there any join index or has index on th table ????
1013513 Dec 2008 @ 06:00 PSTKoentjeDatabaseReplyStatistics information retrieved in dbc for Teradata 12This is really what I wanted to have.Thanks a lot for this quick response.Koen.
1013412 Dec 2008 @ 04:07 PSTdnoethDatabaseReplyStatistics information retrieved in dbc for Teradata 12Hi Koen,there changed a lot in TD12, especially on 64bit.You'll find the latest version of that stats query on the TeradataForum:http://www.teradataforum.com/attach.htmDieter
1013312 Dec 2008 @ 04:05 PSTdnoethToolsReplyusing OREPLACE function'1A' is an error character which is used when a character cannot be translated.Is your example data the result of a TRANSLATE WITH ERROR?Your screenshot is showing ascii/latin but no unicode chars....
1013212 Dec 2008 @ 01:20 PSTJennifer OstremJobsTopicDISH Network Seeking a Sr. Teradata Database AdministratorWe are seeking someone with five to eight years experience in a large database environment, with at least 2 years focused on Teradata. four year college degree in a computer related field.Candidat...
1013112 Dec 2008 @ 11:13 PSTwannabe_guruToolsReplyusing OREPLACE functionLooks interesting.(question on the tick marks, does this refer to the key next to the 'enter' key?)Have tried both below with the following errors:SELECT ID, OREPLACE(ColA, ‘1A’XCV,’’) FROM...
1013012 Dec 2008 @ 07:43 PSTKoentjeDatabaseTopicStatistics information retrieved in dbc for Teradata 12What is the query to read the statistics information in dbc for Teradata 12?We had something for previous releases.Or is there no impact due to the new release on dbc level?
1012912 Dec 2008 @ 07:12 PSTHrishikeshToolsTopicUnable to open History Table or write History in TD12 TTUs when working on WINDOWS VISTA PCFriends, We have recently got Windows Vista PCs. We have loaded TD12 TTUs. We are able to establish connection to Teradata Servers.But it is not writing history.Please guide.Thanks.Hrishikesh

Pages