1012 Sep 2006 @ 10:58 PDTDatabaseReplyProblem with SHOW MACROAccording to the TD manualsShow Macro is limited to 12,500 Chars., thats the why, but I have't thought of a how.Tbob
906 Sep 2006 @ 12:26 PDTDatabaseReplyConcurrent Active SessionsTerdata Manager -> monitor -> session information -> activeTbob
823 Aug 2006 @ 03:16 PDTAnalyticsReplyAny function like Oracle "months_between"? extract(month from end_date) - extract(month from start_date);
708 Aug 2006 @ 10:18 PDTJobsTopicTeradata Discussion Form infested by Pesky Phone Salesmen.Is there anyway these people can be blocked?
614 Jul 2006 @ 10:57 PDTDatabaseReplySyntax to Alter tableThanks for the response Mayhan,I guess I was misinterpreting the DDL manual.Tbob
513 Jul 2006 @ 12:23 PDTDatabaseTopicSyntax to Alter tableWhat's the syntax to alter table:col(smallint) needs to be changed to integer..Tbob
411 Jul 2006 @ 09:58 PDTAnalyticsReplyIs there a 'sounds-like' phonetic function ?Could be how 'fone' is perceived to be pronounced by TDSELECT case when SOUNDEX('fawn') = SOUNDEX('fone') then 'both equal' else 'both not equal ' endboth equalTbob
303 Jul 2006 @ 11:17 PDTUDAReplySQLVasilis,sounds like you might use'like'select * from table where column like '%a%';or sel * from tablewhere colname like any ('%a%', '%b%');SQL reference found www.info.ncr.comTbob
224 Mar 2006 @ 10:43 PSTUDAReplyDefault spacesMy understanding of Varchar has been that no trailing spaces where storedalso, and that Chars function was specially suited to Varchar for this reason.So I reran you queryresults: aKey vText Charac...
110 Jan 2006 @ 06:01 PSTDatabaseTopicMultiload (out of Range error)Hello all,Is there a good way to handle invalid data when using multiloadie :-( ......)coming in on an MVS flat file.some records return 'out of range error' on one particular field,and others have...