All forum activity

#DateUserForumTypeThreadPost
164221 Aug 2006 @ 04:04 PDTGreatSushantDatabaseReplyHow to retrieve Metadata info using TPT API?1-Get list of all the databases from a Teradata serverSelect databaseName from dbc.databases where dbkind='D'2-Get list of all the tables, views from a Teradata DBSelect tablename from dbc.tables w...
164121 Aug 2006 @ 02:40 PDTajai_47ToolsReplyDATE FORMAThi dieter..thanks for the reply.. my problem is solved now.. :-)
164021 Aug 2006 @ 02:02 PDTmagrawalDatabaseTopicHow to retrieve Metadata info using TPT API?I am using Teradata PT APIs to create a connector from my application. I want to do following tasks, but couldn't find a direct way to do this thro' APIs? 1-Get list of all the databases from a Ter...
163920 Aug 2006 @ 01:04 PDTRMMTrainingTopicTeradata Basics EnquiryHello All,Please can anybody guide me about books / tutorial either softcopy / Hard copy to learn basics / SQL / Load & Unload utilities of Teradata .Thanks in advance,Rishikesh Mittal.
163819 Aug 2006 @ 01:36 PDTdnoethToolsReplyDATE FORMATHi Ajai,you can cast that column to a date:SELECT MAX(my_col (DATE, FORMAT 'mmmyyyy')) (CHAR(7))FROM my_tab;Dieter
163719 Aug 2006 @ 01:26 PDTdnoethAnalyticsReplyGetting one entry per RANKHi Carole,just add more columns to the Order By to make it unique or use row_number instead of rank...Dieter
163619 Aug 2006 @ 01:04 PDTgiriToolsTopicsessionsHi can some one explain me SESSIONs with respect to USERs, AMPs , SQL StatementsThank u
163519 Aug 2006 @ 07:02 PDTVinuConnectivityTopicCreating New User Defined FunctionsHow to create our own user defined functions please let me know its very important
163418 Aug 2006 @ 04:38 PDTPauloConnectivityTopicteradata data source connection on Websphere on WindowsI am trying to set a Websphere 5 application server data source to connect to a teradata db elsewhere. I can use jdbc/odbc connections fine in this server to connect to that same db. But when I try...
163318 Aug 2006 @ 01:58 PDTabdysDatabaseReplyAdd a number to next rowThanks Nicolas, that was great help.
163218 Aug 2006 @ 11:44 PDTcaroleAnalyticsTopicGetting one entry per RANKI need to get the most recent records (based on date) for each ID. I cannot do a group by since there are too many non-aggregate values that I do not want to consider when grouping. I have tried:...
163118 Aug 2006 @ 11:37 PDTDiEgoRTrainingReplyFastLoad, Multiload UsageI do not pretend to give you exhaustive answer, but once I've noticed your post...From my practial view: FastLoad is faster than Multiload, but one can open only a limited number of load sessions a...
163018 Aug 2006 @ 11:30 PDTDiEgoRToolsReplyProblem using Teradata import - making me crazy!!02251219 |381646195I have noticed than you have a space after the first number.I had to set the delimiter in Queryman Export Option to | and also asked to enclose the values in "."02251219 "|"38164...
162918 Aug 2006 @ 07:00 PDTajai_47ToolsTopicDATE FORMATi m trying to retrieve the max value from the field which contains data like FEB2006,MAR2006, etc... From these data i have to select the max value. Can you please help me out with this ASAP.
162818 Aug 2006 @ 06:09 PDTVRTrainingTopicFastLoad, Multiload UsageHi,Could any one please explain the functionality behind fastload and multiload, the functional difference between them, and also at what situation each one is used.Thanks,
162718 Aug 2006 @ 06:03 PDTJohn MacAnalyticsReplyUpdate syntaxSomething like this would probably do ...UPDATE TMP1FROM TEMP_PRD.T_CST_SUB_DAILY_INFO_TEMP TMP1 ,(SELECT T_CUA_CUST_CODE , COUNT (*) AS CC_COUNT FROM TEMP_PRD.T_CST_SUB_DAILY_I...
162618 Aug 2006 @ 05:16 PDTJohn MacUDAReplyLimitation ON Bteq ExportSorry mate, no idea.
162518 Aug 2006 @ 02:50 PDTmanuk82DatabaseTopicTeradata TrainingHi All, I am totally new to Teradata database. Can any one guide me How to start with and where i can find good tutorials?Thanks,Manu.
162417 Aug 2006 @ 11:13 PDTsfyeu1AnalyticsTopicUpdate syntaxI can run below query in DB2, but I got the error message in Teradata. May anyone can help me to solve it?UPDATE TMP1FROM TEMP_PRD.T_CST_SUB_DAILY_INFO_TEMP TMP1SET (TMP1.T_NO_OF_ACTIVE_MRT ) =...
162317 Aug 2006 @ 11:10 PDTTeradataStaffingSpecialistJobsTopicNeed Teradata People-Developers & DBAHello We are always in need of excellent ECTL, ETL Developers and Teradata DBAS. If you have experience in Teradata then Please email your latest resume, contact, salary expectations and referenc...
162217 Aug 2006 @ 09:47 PDTsparanToolsReplySelect Top 10 recordstry with Rank function
162117 Aug 2006 @ 09:43 PDTsparanUDAReplyLimitation ON Bteq Exportyou are correct. it seems we have MP-RAS.i used fastexport to solve this problem.one more, is there any chance to get octal delimiter "\001" in the fastexport script.thanks a lot,Sparan
162017 Aug 2006 @ 07:49 PDTJohn MacUDAReplyLimitation ON Bteq ExportMP-RAS is the 'flavour' of UNIX used on the Teradat box. It's a bit old and has a 2GB limitation on the size of any files.Quick bit of maths makes me think you may indeed have hit the 2GB limit...2...
161917 Aug 2006 @ 03:46 PDTlittldoDatabaseTopicMVS(Z/OS) TDP access to TD Server via TCP/IPHi,Because of a history of company mergers, our production mainframe is 600 miles away from our newer teradata that's only on the IP network. Is it possible to configure the Z/OS TDP to use IP net...
161817 Aug 2006 @ 08:59 PDTsparanUDAReplyLimitation ON Bteq Exporterroring out after 4.5GB size(24 M). what is MP-RAS ?

Pages