#DateForumTypeThreadPost
2025 Mar 2010 @ 09:31 PDTDatabaseReplyCompile Stored Procedures in BatchThanks a Bunch, it worked....
1925 Mar 2010 @ 01:22 PDTDatabaseTopicCompile Stored Procedures in BatchVersion: TD V2R6 Environment: Mainframe I am trying to find out how to compile Stored Procedure in Batch with just Referencing their Name and without including SP DDL statements. I know how to ...
1803 Mar 2010 @ 10:25 PSTDatabaseReply'Date' BETWEEN 'select Date'Thanks Rajesh for the solution. Below are two ways to accomplish it without refrencing "Day" since it wasn't working outside of subquery. Following two worked perfectly, so I am sharing with the Fo...
1702 Mar 2010 @ 05:24 PSTDatabaseTopic'Date' BETWEEN 'select Date'I want to get month end date of 2 months prior. For instance, if i run the SQL today, i should get 2010-01-31 where the question marks are in the SQL below. Mind you, I cannot use volatile table. ...
1620 Oct 2009 @ 12:42 PDTToolsReplyMLoad UpdateActually all of the records will be updated with this new value for FIELD1. Since this table is huge, I intend to use MultiLoad Update.
1520 Oct 2009 @ 09:59 PDTToolsTopicMLoad UpdateI have to Update only one field in the table with one valuea using MultiLoad (dont want to use BTEQ since DBA dislike to update table with >100k rows with BTEQ). For instance, SQL is following.....
1430 Aug 2009 @ 06:18 PDTAnalyticsReplyDifference between select * from Table & select individual columnsWell, it helps Teradata when you enslist colum names in the query. By using '*' you add one more stage and asking Teradata to resolve that * first, and then bring the data. By using specific colum ...
1324 Aug 2009 @ 02:42 PDTUDAReplyBTEQits not graphical interface, it is just a way to connect Teradata either Batch or interactive modes. So, if your company purchased it, you have it, you just find out syntax for it to use it.
1224 Aug 2009 @ 12:33 PDTUDATopicGraphical rep of Data flow to/from TDDoes anyone know about a tool which could be used to graphically show data flow from/to the Teradata? we have huge EDW, and I have heard such exist but don't remember what the name or vendor was. T...
1102 Mar 2009 @ 11:29 PSTDatabaseReplysql questionYes, i have seen that and I would use numbers rather floats...but for some reason one developer did SELECT COUNT(*) (FLOAT) FROM DB.table; not sure what is he trying to achieve, cannot ask him no ...
1002 Mar 2009 @ 11:04 PSTDatabaseTopicsql questionMy question is, would following pull up row counts in floats? SELECT COUNT(*) (FLOAT) FROM DB.table;
925 Jul 2008 @ 08:29 PDTDatabaseReplyTeradata DUAL LOAD (architectue/Design) qustionThanks for the reply. I will refer to the documentation.
824 Jul 2008 @ 07:41 PDTDatabaseReplyTeradata DUAL LOAD (architectue/Design) qustionBy "Shadow Technology" I meant standby system (SYSTEM B), which relies on System A (default) for its data, but when System A goes down for maintenance or disaster, System B takes over, and switch o...
723 Jul 2008 @ 07:28 PDTDatabaseTopicTeradata DUAL LOAD (architectue/Design) qustionWe are implementing Dual Load in a mainframe environment. This implementation is divided into several phases, and replicates existing schedule i.e. running two Jobs which will be loading same data ...
606 Jun 2007 @ 01:15 PDTDatabaseTopicBasic SQL Datatype Question.I have some basic SQL questions, please pardon me for my lack of knowledge. When do we use FLOAT or DECIMAL in SQL, what's the criteria? Is how to define DECIMAL/FLOAT is a standard in all the SQL...
517 May 2007 @ 08:57 PDTToolsReplyinvoking BTEQ from Mainframe?Lukekay thankyou very much for taking so much trouble for me! appreciate your help again! :-)
416 May 2007 @ 07:43 PDTToolsTopicinvoking BTEQ from Mainframe?Currently I am using following to update date column in Teradata on Mainframe platform.- There is one Job which copies the date stored in a DATASET in YYYYMMDD format to SNAP_DT.TXT file on DATASTA...
318 Dec 2006 @ 12:36 PSTToolsReply911-ETL developerThanks so much for your reply Aravind. Knowing I currently do not have an ETL developer position is it possible: A) to get a job first and then learn there according to your instructions or B) lear...
216 Dec 2006 @ 01:46 PSTToolsTopic911-ETL developer- Question> My question to all the respectable Teradata Gurus/Experts is: What am I required to study to develop ETL?- Background> I currently have a Teradata Level 1 certification with no experien...
116 Dec 2006 @ 01:07 PSTTrainingReplyImplementation & SQL examsTo Nagendhran,Coffing books are available on his website. "http://www.coffingdw.com/index.asp".