All forum activity

#DateUserForumTypeThreadPost
26706 Feb 2006 @ 09:54 PSTAnKoUDATopicUNION limitHi,I've got a situation as follows...a single view containing multiple views with some filter condition on each child view.replace view main_view asselect * from view_1UNION ALLselect * from view_...
26606 Feb 2006 @ 08:27 PSTakhil.bansal@gmail.comDatabaseReplyINSERT EXPLAIN not workingHi Kishaninstead of trying INSERT EXPLAIN INTO QCD AS QUERY_0001 SELECT SVC_ENTY_ID FROM DB_TX.SERVICING_ENTITYPlease try this EXPLAIN INSERT INTO QCD AS QUERY_0001 SELECT SVC_ENTY_ID FROM DB_TX.S...
26506 Feb 2006 @ 07:51 PSTA-2368DatabaseTopicTeradata V2R5.1 on Windows 2000 would not come up.I have installed Teradata V2R5.1 on Windows 2000 Advanced Server. The componenents i have installed are the Cliv 2.04.07, Teradata Database(TNT.05.01.01.00), piom.02.01.00.00(Data Connectivity Driv...
26406 Feb 2006 @ 04:57 PSTAmby_SawTrainingReplyNR-011 CertificationHi Preeti, Even I am planning to give the Teradata NR-011 certification are there any course or classroom trainings conducted & where did u get the books from ? what books are u referring to ?...
26303 Feb 2006 @ 10:45 PSTshaik.feroz@aaa-calif.comDatabaseReplyPlease Help me in Bteq ScriptsCould you post the query and some sample data. That will help.
26203 Feb 2006 @ 09:42 PSTkhabDatabaseReplyPlease Help me in Bteq Scriptsare you using any Join Indexes?
26103 Feb 2006 @ 09:23 PSTTD_ArchDatabaseReplyDate Syntaxselect date + interval '1' month - extract (day from date)
26003 Feb 2006 @ 08:54 PSTsantoshkumar.bhugathaDatabaseTopicDate SyntaxCan anyone tell me the syntax/command to find the last day of the month? Please mail me to santoshkumar.bhugatha@gmail.com
25903 Feb 2006 @ 08:52 PSTsantoshkumar.bhugathaDatabaseTopicPlease Help me in Bteq ScriptsI have two tables which generate no null value. But iam joining them using Inner JOin condition, i am getting the resultant output data with nulls. How come ? What may be the problem? Please respon...
25802 Feb 2006 @ 12:38 PSTmeet_asToolsReplycan we force mload to check the Application error tableyes, I have already completed this. I did it like this--.IF &SYSUVCNT1 > 0 THEN; .SYSTEM 'c:\Paging.pl any_argument';.ENDIF;Its better if we place the above statement after the .END MLOAD Command.a...
25702 Feb 2006 @ 12:31 PSTmeet_asToolsReplyCan we call bteq script in mload script.Yes, I did it with the same way.. Thanks for your response..Regards
25602 Feb 2006 @ 11:29 PSTJim ChapmanDatabaseReplyDelete / truncate commandNo, DROP TABLE is very fast, regardless of table size. It does not log individual rows.
25502 Feb 2006 @ 09:57 PSTBBR2ToolsReplyQuryman ErrorI believe BTEQ uses native connection while SQL Assistant uses ODBC.You may want to upgrade your ODBC driver.Vinay
25402 Feb 2006 @ 09:55 PSTBBR2DatabaseReplyDelete / truncate commandJim,It was my experience to use DELETE all and then drop table for very large tables.If you try dropping a very large table, I believe all the activity will be logged in TJ. While DELETE ALL does n...
25302 Feb 2006 @ 09:51 PSTBBR2ToolsReplyCan we call bteq script in mload script.you can use .OS command MLOAD utility within a BTEQ.You will have to ensure that MLOAD executable path is set.Here's a sample.LOGON TDPID/UID,*****;.export report file = rep.txt;select * from DBC.C...
25202 Feb 2006 @ 12:45 PSTFredConnectivityReplyTeradata ODBC Trouble in MS/AccessProbably DR 90597 (bug in driver on TTU7.1 CD's). Fixed in ODBC 3.3.0.8 and later. Get updated driver from Teradata.Com downloads area or the patch server.
25102 Feb 2006 @ 12:38 PSTFredToolsReplyCan we call bteq script in mload script.At least in a network attached environment you can use .SYSTEM to invoke any command line including BTEQ or something that calls BTEQ. On the mainframe you'd probably have to write your own "shell"...
25002 Feb 2006 @ 12:34 PSTFredToolsReplycan we force mload to check the Application error tableCertainly. Use .IF statements testing built-in variables such as &SYSETCNT1 to check for rows in the error table, and use .SYSTEM to execute some external command to send the page. See the manual f...
24901 Feb 2006 @ 05:22 PSTTeraTintinTrainingReplyHow many Certified Teradata MastersWe have 4 at my office who sit next to me.
24801 Feb 2006 @ 04:39 PSTChuckRecruitJobsTopicTeradata Developer in Bensalem, PAOur client in Bensalem, PA is in need of a Senior Teradata Developer with strong Cobol and DB2 experience. This is a long term contract position. Please call me at (609)716-8700, ext. 302 or emai...
24701 Feb 2006 @ 10:33 PSTKrishan.RDatabaseTopicINSERT EXPLAIN not workingHi,Can some explain to me why the following statement fails. I have a QCD database and I am trying to populate the QCD using the following query:########################INSERT EXPLAIN INTO QCD AS ...
24601 Feb 2006 @ 10:18 PSTarunkumark2000@yahoo.comToolsReplycan we force mload to check the Application error tableHi,If you are trying to perform a check on the Application Error table, then it is not possible to fire a BTEQ script from within a Multi Load script. Alternatively, you can schedule the BTEQ immed...
24501 Feb 2006 @ 10:16 PSTarunkumark2000@yahoo.comToolsReplyCan we call bteq script in mload script.Hi,It is not possible to call a BTEQ script from within an MLoad script. What specifically are you trying to do here? If i understand you correctly, you are trying to use conditional flow control. ...
24401 Feb 2006 @ 07:16 PSTTarunaJobsTopicOpening for MicroStrategy/BO Developer, MicroStrategy Admin, Teradata ETL Developers for Bangalore Location Hi , We have urgent permanent positions directly with our top notch Client at Bangalore.MicroStrategy/BO Developer: Should be an engineering candidate with 6+ yrs of software development experience...
24331 Jan 2006 @ 10:49 PSTrkeith01AnalyticsReplyTeradata function equivalent to 'LIKE %..%' in TeradataDDIn Teradata your example would be:SEL * FROM emp WHERE empnm LIKE 'dd%';

Pages