All forum activity

#DateUserForumTypeThreadPost
149228 Jul 2006 @ 02:07 PDTjporellDatabaseTopicUnion All problemCan anyone explain the following odd results?When I execute the following query:select 'x' ,count(*) from dbc.databasesunion allselect 'x1' ,count(*) from dbc.databasesI get the following results:x...
149128 Jul 2006 @ 11:59 PDTdnoethDatabaseReplyHow to subtract time from a timetamp fieldThere's no need to typecast:duration * interval '00:00:01' hour to second Dieter
149028 Jul 2006 @ 10:27 PDTvictor4techDatabaseTopicHow to subtract time from a timetamp fieldHi,I have a field which has time duration in seconds...It has to be subtracted from a timestamp field. So, the first step would be to convert it to a HH:MM:SS format. I am trying to write a case st...
148928 Jul 2006 @ 04:29 PDTANGELDatabaseReplyNUSI Bitmapping?Hi,Ya it compares the rowids ThanksAngel
148828 Jul 2006 @ 04:19 PDTvinod_sugurDatabaseReplyHow to fetch chunks of data in TeradataI would suggest to fetch the rows by using analytical function i.e Row_Number() Select *From (select Row_number() OVER(Order by day_of_calendar) val, day_of_calendar, calendar_date from sys_calend...
148728 Jul 2006 @ 03:42 PDTManoj_Kumar_ParmarDatabaseReplyNUSI Bitmapping?Hi Angel, thanks for reply, Does it mean, that it compares all the rowid of cond in where clause(which are having NUSI) to each other and then create the BITMAP.thanks in Advance.....
148628 Jul 2006 @ 03:41 PDTManoj_Kumar_ParmarDatabaseReplyNUSI Bitmapping?Hi Angel, thanks for reply, Does it mean, that it compares all the rowid of cond in where clause(which are having NUSI) to each other and then create the BITMAP.thanks in Advance.....
148527 Jul 2006 @ 05:30 PDTmparkerJobsTopicNYC - Top investment bank - Senior Distributed Database Engineer (Teradata)My client, a top investment bank, located in NYC is currently seeking a senior level, hands-on database engineer. The ideal candidate will have a diverse background in database technologies and the...
148427 Jul 2006 @ 03:11 PDTManikToolsReplyProblem faced while using FastLoadHi Fred,Yes your are right.The moment I used the Indicator option in FastLoad, it worked.Thanks for the quick help.Regards,Manik
148326 Jul 2006 @ 06:54 PDTTeradataStaffingSpecialistJobsTopic*****URGENT:ECTL Developer, 3 Positions!!!Order ID : 10590 Assignment Info Order Date : 24-JUL-2006 Positions : 3 Start Date : 31-JUL-2006 End Date : 31-JAN-2007 Work Location : Dayton, OH ,USA Job Description Job Title : ECTL De...
148226 Jul 2006 @ 05:31 PDTjkleeAnalyticsReplyproblem using Informatica to load Teradata tables.I don't work with Informatica anymore, but if I remember correclty, you have to choose the correct loader.For TD, there are four: Relational, Fastload, MLoad, and TPump.
148126 Jul 2006 @ 02:48 PDTFredDatabaseReplyTDPID Vs AccountIDTDPID (the part before the slash) identifies the Teradata system to which you will connect (mapped via network hostname or mainframe subsystem ID).AcctID controls how resource usage will be grouped...
148026 Jul 2006 @ 02:40 PDTFredDatabaseReplyConvert Varbyte to CharacterActually the point of moving the data back to the original platform is that the data is NOT translated. (It remains in client format even in the error table field; that's why it's typed VARBYTE - s...
147926 Jul 2006 @ 02:11 PDTFredToolsReplyProblem faced while using FastLoadDefault for FastExport is MODE INDICATOR (null flag bits at the start of each record) but default for FastLoad is no INDICATORS.Either change the FastLoad.begin loading financial.customer_new Error...
147826 Jul 2006 @ 11:06 PDTManikToolsTopicProblem faced while using FastLoadHi All,Here's a problem I am facing while using FastLoad.I have exported five rows with just one field i.e. cust_id from the financial.customer tableusing fastexport. I used the following script to...
147726 Jul 2006 @ 07:41 PDTAshuDatabaseTopicHow to fetch chunks of data in TeradataHi,I have a very urgent requirement.There are some millions of records in one of my Teradata tables.Now I need to process these records by fetching 10000 records at a time.For example- say in the f...
147626 Jul 2006 @ 07:40 PDTAshuToolsTopicHow to fetch chunks of data in Teradata. Urgent!!!!Hi,I have a very urgent requirement.There are some millions of records in one of my Teradata tables.Now I need to process these records by fetching 10000 records at a time.For example- say in the f...
147526 Jul 2006 @ 07:35 PDTAshuUDATopicHow to fetch packets of records and process them in TeradataHi,I have a very urgent requirement.There are some millions of records in one of my Teradata tables.Now I need to process these records by fetching 10000 records at a time.For example- say in the ...
147426 Jul 2006 @ 02:46 PDTdnoethUDAReplyEquivalent of "Connect By prior .. with level" in TeradataHi Ashu,since V2R6 there's Standard SQL "WITH" for recursive queries, most of Oracle's functionality can be converted. There's a good article for DB2 how to convert CONNECT BY to WITH, most of it i...
147325 Jul 2006 @ 09:49 PDTAshuUDATopicEquivalent of "Connect By prior .. with level" in TeradataThere is "Connect By prior .. with level" statement in Oracle.Can anybody please tell me if there is an equivalent to this statement in Teradata.
147225 Jul 2006 @ 08:43 PDTDaveCAnalyticsReplyEquivalent of Oracle-SEQUENCE_NAME.NEXTVAL in TeradataI've only been using Teradata for a few months, so don't take this as gospel, but....The short answer is that you can't - there is no equivalent.The more nuanced answer is that you might be able to...
147125 Jul 2006 @ 07:52 PDTPhaniUDAReplyHow to run a stored procedure please?call nameofprocedure()
147025 Jul 2006 @ 12:19 PDTakhil.bansal@gmail.comDatabaseTopicTDPID Vs AccountIDHi,What is the difference between TDPID and Account ID parameters of LOGON command that we give while logging to Teradata using BTEQ ?Regards
146925 Jul 2006 @ 07:56 PDTjporellDatabaseReplyConvert Varbyte to CharacterThanks very much for your input but I don't understand why a platform change would help me translate the data in the Hostdata field. I know I can move the data to my local machine and view a recor...
146824 Jul 2006 @ 09:24 PDTFredDatabaseReplyConvert Varbyte to CharacterThe HOSTDATA column contains whatever bytes the client sent. If there is character data, it will be in the client characterset so using a UDF to (in effect) just declare it LATIN or UNICODE probabl...

Pages