All forum activity

#DateUserForumTypeThreadPost
91712 May 2006 @ 11:19 PDTDGiabbaiToolsReplyInvoke Teradata BTEQ/MLOAD scripts from unix shell scriptJust add this BTEQ statement before the "logon":.SET ERROROUT STDOUT
91612 May 2006 @ 11:15 PDTDGiabbaiAnalyticsReplyAny equivalent pseudo columns in TD like ROWNUM in OracleIt is difficult to apply the concept of "the first N columns" to a parallel environment (like TeraData is), where data is uniformly distributed through the amps (in a normal situation).In general, ...
91512 May 2006 @ 09:09 PDTDeveloperAnalyticsReplyAny equivalent pseudo columns in TD like ROWNUM in OracleThanks for reply. I guess that would help.
91412 May 2006 @ 08:11 PDTJaguarToolsReplyInvoke Teradata BTEQ/MLOAD scripts from unix shell scriptHi TDUser, Appreciate your help..It works..However I am facing another problem.I am redirecting the output of btq to a log file.But the log file only captures the return code.I wish to cap...
91312 May 2006 @ 03:02 PDTWahab-724DatabaseReply10065 WSA E HostUnreachHi,I think your data base is down. Plz check it once weather your database is running or not.The possibilities of these error message is1. Database is down (OR)2. Some problem in your network conne...
91212 May 2006 @ 12:37 PDTnithyanandamDatabaseTopic10065 WSA E HostUnreachGuysJust wanted to find out if there is any solution for the above error.. Been searching an answer for the above problem for the couple of days but negative.Recently, installed the Teradata Demo C...
91111 May 2006 @ 07:26 PDTSunil AgrawalAnalyticsReplyAny equivalent pseudo columns in TD like ROWNUM in OracleThe below query will return 100 rows in increasing order of col1.select col1 , col2 . . , row_number() over (order by col1) as row_numfrom tablenamequalify row_num
91011 May 2006 @ 02:28 PDTDeveloperAnalyticsTopicAny equivalent pseudo columns in TD like ROWNUM in OracleHi Guys,Is there any pseducolumn concept in TD like ROWNUM in Oracle or, is there any way to get first 100 rows of a table ? Suggestions appreciated.Thanks,
90911 May 2006 @ 02:02 PDTDeveloperAnalyticsReply3706: Syntax error: expected something between ')' and ','. For derivedHi, I donot know your exact problem definition , but some how simulated one case like you and tested it its working fine. below is the template i used.I guess you need to verify the place of joingi...
90811 May 2006 @ 01:45 PDTdsadAnalyticsReply3706: Syntax error: expected something between ')' and ','. For derivedThanks for the replies guys.Correct aliasing seems to have fixed the problem.Thanks again.
90711 May 2006 @ 11:41 PDTFredAnalyticsReply3706: Syntax error: expected something between ')' and ','. For derivedIs your query perhaps being submitted in some manner that requires a name be assigned to each field? In other words, do you needCOUNT(ITM_NUM) C1,COUNT(ORD_NUM) C2,COUNT(ORD_LN) C3Also, are you rea...
90611 May 2006 @ 09:41 PDTMyNetHelperConnectivityTopicOLE DB Response FileCan anyone tell me where to find a response file for the OLE DB driver install. There is one for ODBC on the CD, but I can't seem to find one for OLE DB. The normal response file creation process...
90511 May 2006 @ 07:57 PDTTDUser-781ToolsReplyInvoke Teradata BTEQ/MLOAD scripts from unix shell scriptIn your shell script you can use the same commends you use in windows environment:betq < the ctl filename >> the log filenamehope this helps,bye,TDUser
90411 May 2006 @ 06:16 PDTJaguarToolsTopicInvoke Teradata BTEQ/MLOAD scripts from unix shell scriptHi , I need to invoke Bteq/Mload scripts from a unix shell script to fetch data from Teradata database.Can someone help we that?Thanks
90311 May 2006 @ 02:40 PDTTDUser-781AnalyticsReply3706: Syntax error: expected something between ')' and ','. For derivedHi, what about defining alias for each field of the derived table???I haven't tested your query, but I would use correct aliasing in using derived tables as a general behaviour....Bye, TDUser
90210 May 2006 @ 07:59 PDTdsadAnalyticsReply3706: Syntax error: expected something between ')' and ','. For derivedNope still the same.I think it has something to do with the derived table.Have not been able work on this today, but will keep trying.
90110 May 2006 @ 06:06 PDTpwsegal@gmail.comAnalyticsReply3706: Syntax error: expected something between ')' and ','. For derivedOK, what aboutSELECT P.SRCSYS_CODE,P.SUP_NM,L.SRC_LOC_CD,L.LOC_NAME,D.DEST,COUNT(D.ITM_NUM),COUNT(D.ORD_NUM),COUNT(D.ORD_LN)FROM (SELECT ORD_NUM,ORD_LN,ORD_LN_ST,ITM_NUM,ORD_QTY,LOC_NAME AS DESTFRO...
90010 May 2006 @ 01:50 PDTdsadAnalyticsReply3706: Syntax error: expected something between ')' and ','. For derivedNope,did not work... same error as before
89910 May 2006 @ 10:53 PDTtihomaDatabaseReplydrop database ?Thx for your help.
89810 May 2006 @ 07:49 PDTJaguarConnectivityTopicConnect to Teradata database from web application using JDBCHi , can anyone provide me the jdbc settings (to be given in unix environment) that are required to connect to Teradata database from a web application.Also is there any way in which i can invok...
89710 May 2006 @ 07:25 PDTpwsegal@gmail.comAnalyticsReply3706: Syntax error: expected something between ')' and ','. For derivedTry this (assuming the counts that are from the drived table).SELECT P.SRCSYS_CODE,P.SUP_NM,L.SRC_LOC_CD,L.LOC_NAME,D.DEST,COUNT(D.ITM_NUM),COUNT(D.ORD_NUM),COUNT(D.ORD_LN)FROM (SELECT ORD_NUM,ORD_...
89610 May 2006 @ 05:22 PDTTSDatabaseReplyCOLLECT STATISTICSThanks a lot!will get back in case of any other queries.Regards,TS.
89510 May 2006 @ 05:05 PDTTDUser-781DatabaseReplyCOLLECT STATISTICSHi TS,I would answer like this to your questions:1. when writing about small tables you are thinking about lookup tables, aren't you? if so, thinking about a 3NF db, I would collect stats on the pk...
89410 May 2006 @ 04:02 PDTTSDatabaseTopicCOLLECT STATISTICSHi,I have few queries realted to COLLECT STATISTICS:1) Do we need STATISTICS for small table?2) After how many records or percentage of changes before we should run new STATS or refresh STATS?3) Wh...
89309 May 2006 @ 08:05 PDTdsadAnalyticsTopic3706: Syntax error: expected something between ')' and ','. For derivedHi TD newbie here,am getting the 3706: Syntax error: expected something between ')' and ','.for the following querySELECT P.SRCSYS_CODE,P.SUP_NM,L.SRC_LOC_CD,L.LOC_NAME,D.DEST,COUNT(ITM_NUM),COUNT...

Pages