#DateForumTypeThreadPost
25520 Aug 2007 @ 11:11 PDTToolsReplyUpdating Teradata Compiler and Linker Paths (cufconfig -f ) - HELP REQUIREDAnd yeah it's always useful to back up those Amp*disk* files in tdconfig directory before the reinstall, just replacing those DB files after the install, get's you back on to your old database. (pr...
25420 Aug 2007 @ 05:48 PDTToolsReplyUpdating Teradata Compiler and Linker Paths (cufconfig -f ) - HELP REQUIREDChris, AFAIK, the tdatuser and the corresponding group should have got created when you installed the database itself. This is something that's done by the database setup program. And the user and ...
25320 Aug 2007 @ 12:12 PDTDatabaseReplyAccess Logging and Query LoggingI think the short answer would be, Access Logging is concerned with security (ie. who's doing what ?) where as Query Logging (DBQL) is an aid for debugging (ie what's happening around ?). Where as ...
25217 Aug 2007 @ 09:35 PDTUDAReplyLoading Unicode data from Oracle to teradataI will throw in my 2 cents, which may not be much on this ...How did you take a "look" at the data in TD ?In the past I have seen folks complaining about seeing junk, when in reality their PC didn'...
25117 Aug 2007 @ 01:41 PDTDatabaseReplyStoring XML in teradataDo you want TD to just "store" the XML document, not process any XML tags or so ? ... in that case you will have to make use of CLOB/BLOB and develop custom JDBC/ODBC apps to do the task ...Else if...
25016 Aug 2007 @ 11:45 PDTAnalyticsReplyHow can we Reverse a String in TeradataAs jim suggested, check if you can do it via a UDF. But there are lots of shops who would say a no to using UDFs...This is a small (& not very tidy) example of using recursive SQL to do the same ta...
24916 Aug 2007 @ 10:56 PDTDatabaseReplyConnection being reset systematicallyAnd if you are running on Windows 2003 SR2 standard edition... well it's a place where not many have been lucky to get things to work. support guys have always washed their hands on the topic, thou...
24816 Aug 2007 @ 10:16 PDTDatabaseReplyHelp needed:oIs it something like this that you are looking for ?SELECT EXTRACT(MONTH FROM B) "Month", COUNT(*) OVER(PARTITION BY "Month") "Count"FROM MyTable; Month Count 6 2 6 2 7 1 8 3 8 3 8 3Else probabl...
24716 Aug 2007 @ 09:47 PDTDatabaseReplyHelp neededSELECT EXTRACT(MONTH FROM B) "Month", COUNT(*) "Count"FROM MyTableGROUP BY 1
24615 Aug 2007 @ 11:14 PDTConnectivityReplyUDF performance.I think the first thing to check would be whether you altered the UDF to run on unprotected mode ...ALTER FUNCTION EXECUTE NOT PROTECTED;
24513 Aug 2007 @ 05:21 PDTConnectivityReply[NCR][ODBC Teradata Driver][Teradata Database] Insufficient memory for a Concrete Step for this requestI would put my guess on the Informatica setup. The ODBC driver should not generate an MSR on it's own unless the application does so.
24412 Aug 2007 @ 11:27 PDTConnectivityReply[NCR][ODBC Teradata Driver][Teradata Database] Insufficient memory for a Concrete Step for this requestIt looks like in new setup, Informatica is firing an MSR (multi statement request) where as the old seems to be the plain fashioned single statement insert. The former gives better performance than...
24310 Aug 2007 @ 03:24 PDTAnalyticsReplyInternal errorGenerally that means open a bug with teradata support.Internal errors also happens at times (and not rarely) with wrong SQL (syntax/semantic), so you may want to review your SQL once again.And no m...
24210 Aug 2007 @ 12:37 PDTDatabaseReplyFastload File formatAlso if you are loading from unix,you can do a little bit of "seding" and use a named FIFO to load, which won't take any extra space or change your original source file.here's a template# create a ...
24109 Aug 2007 @ 07:33 PDTConnectivityReply[NCR][ODBC Teradata Driver][Teradata Database] Insufficient memory for a Concrete Step for this requestThat error message comes from the par$er, so the only way I can think of the new setup generating the error, but the old one working fine would be that the new one is possibly using ODBC extensions...
24008 Aug 2007 @ 12:09 PDTToolsReplyCan I write output to flat files through stored procedures?It's generally recommended to do all the processing within the TD system, if the target is the same TD system.Depending on the nature of your processing logic, it may be possible to write a complex...
23908 Aug 2007 @ 12:02 PDTConnectivityReplyODBC/CLiODBC and CLI are two different APIs. while ODBC is an industry standard API, which means that if you write an application making use of ODBC API, you can switch it to a different DBMS without rewri...
23807 Aug 2007 @ 11:00 PDTAnalyticsReplycoalesce + concatenationIf I recall correctly, this issue was fixed in V2R6.1
23707 Aug 2007 @ 05:30 PDTDatabaseReplysum of counts on 2 different tablessomething like this ?SELECT ACNT.CNT + BCNT.CNT AS TOTCNTFROM (SELECT COUNT(*) FROM A)ACNT(CNT), (SELECT COUNT(*) FROM B)BCNT(CNT)
23607 Aug 2007 @ 01:42 PDTDatabaseReplyHow to find No of rows that a query has returned?The standard (?) SQL is a set oriented language and does not have provision for procedural logic like IF THEN processing...You can however try doing this inside a stored procedure, which can make u...
23506 Aug 2007 @ 08:24 PDTDatabaseReplyHow to find No of rows that a query has returned?if you are using bteq you can use the bteq variable ACTIVITYCOUNT to do this..IF ACTIVITYCOUNT = 0 THENyou might also have to the bteq .GOTO command to get your logic into bundle.refer the bteq man...
23403 Aug 2007 @ 06:16 PDTToolsReplyMulti language columns in a table?That's true you can have both kind of columns in the same table, And TD don't care if it's Arabic or Chinese or any language that matter, when the column definition says UNICODE, it means it can co...
23303 Aug 2007 @ 04:24 PDTToolsReplyMulti language columns in a table?As long as you stick to Unicode with your Arabic data, you should be able to define those columns as unicode and use it...........Add1 VARCHAR(30) CHARACTER SET UNICODE
23203 Aug 2007 @ 12:53 PDTUDAReplyTeraData vs OracleI once had a training session for folks who were porting an OLTP JDBC Application( with tons of RIs, triggers etc in cascaded fashion) from Oracle to TD, so there was the obvious complaints going o...
23102 Aug 2007 @ 11:42 PDTDatabaseReplyError: No more room in database DBCMost likely that's because you allocated all the perm space to other databases ...check what's the free perm in DBC, and if it's very low, move some space from other databases...

Pages