#DateForumTypeThreadPost
2930 Oct 2014 @ 05:59 PDTDatabaseTopicUsing SI in view with analitical functionHi All, I've got a problem with performance whilst reading from view. I need to present state of contracts on each day. To avoid storing same information in table for every day a created table...
2808 Jan 2014 @ 03:04 PSTDatabaseTopicotranslate - strange behaviourWe'we got a strange problem. We use otranslate function to detect non-number characters in a column like this: otranslate(text_column,'a1234567890','a') and then convert to dec...
2730 Mar 2012 @ 03:16 PDTToolsReplytpump, fastexport, insert into ... - problem with charset Hi Ok, I solved this 1. I had to Convert text file to UTF8 using unix iconv command 2. Changed default character set for my teradata user from LATIN to UNICODE 3. Used tpump and ...
2628 Mar 2012 @ 01:42 PDTToolsTopictpump, fastexport, insert into ... - problem with charset Hi all I've got a problem with character encoding(polish letters in this case). I've two tables, both have varchar columns character set unicode , let say A and B.  Process ...
2509 Jan 2012 @ 05:32 PSTDatabaseTopictimestamp of commit Hi all Is there a possibility to track when the record was commited ? I mean something like system column may be something similar to SCN in oracle.   thanks for help &n...
2407 Dec 2011 @ 08:11 PSTDatabaseTopic_UNICODE in comments - procedures Hi All When I compile my procedure which contains comments, some(not all) comments are changed to /*_UNICODE '002A002A002A*/ I don't use special characters - just simple letters....
2330 Nov 2011 @ 02:30 PSTGeneralReplyStored Procedures - how to handle dynamic result set Thanks Dieter, This is what I was afraid of
2230 Nov 2011 @ 12:20 PSTGeneralReplyStored Procedures - how to handle dynamic result set Hi NetFx, The second procedure is just an example it just pass result set from first procedure to client but in fact I want do something with result set returned from first procedure and the...
2129 Nov 2011 @ 07:40 PSTGeneralTopicStored Procedures - how to handle dynamic result set Hi all, I've got the following problem: how to handle dynamic result sets from calling procedure in a caller in TD12? replace procedure test_result_set() dynamic result sets 1 be...
2001 Jul 2011 @ 12:04 PDTToolsReplyJava Teradata SQL Assistant - Sample ContentsThank You very much
1930 Jun 2011 @ 12:24 PDTToolsReplyJava Teradata SQL Assistant - Sample ContentsThanks for reply Chuckbert The most important thing for me is: Does this operation causes the same system load as the ordinary "Select * from database.table"? As You wrote all results are spool...
1829 Jun 2011 @ 01:34 PDTToolsTopicJava Teradata SQL Assistant - Sample ContentsHi All Perform "Sample Contents" on a table causing insert record into dbc.QryLog with SQLText "Select * from database.table". My question Is : Is somewhere information about number of rows tra...
1717 Jun 2011 @ 05:23 PDTDatabaseReplyNeed different values for same column You can just use: case when RNK=2 then 0 else SUB.VIEW_LENGTH end as VIEW_LENGTH, instead of SUB.VIEW_LENGTH , in select clause
1616 Jun 2011 @ 02:38 PDTDatabaseTopicProblem with charset UTF-8Hi All, I,ve got a problem with character encoding. I connect to teradata(TD12(AIX)) using UTF-8(no matter assistant or bteq) and have a problem with polish letters. examples from bteq: *...
1511 Apr 2011 @ 08:16 PDTDatabaseReplyTIMESTAMP: FORMAT - TimeZoneHi I've tried to find that format but I'm affraid there is no such format. May be someone knows better. I don't know what You exactly need but if You just need name of time zone like Pacifi...
1411 Apr 2011 @ 05:47 PDTDatabaseReplyDynamic SQL fetch sql Statements from tablesProvide more info please. Give a table/tables with some example records and write the goal You want to achieve cheers
1301 Apr 2011 @ 02:13 PDTDatabaseReplyLinux - Bteq - Logging On in Batch ModeYou can set database just after logon database YOUR_DATABASE; You can always pass database name as a parameter if You need.
1230 Mar 2011 @ 07:38 PDTDatabaseReplyTable metadata inspectionHi - Sequences attached to a column: select * from dbc.columns where DatabaseName='YOUR_DATABASE' and TableName='YOUR_TABLE'; in ColumnName You have columns in the table and in the IdColT...
1129 Mar 2011 @ 04:18 PDTDatabaseReplyIs a strict mode for inserting strings possibleHi You have to change transaction semantics from teradata to ANSI in bteq, before logon: .set session transaction ANSI;
1025 Mar 2011 @ 02:21 PDTDatabaseReplyFind the first occurance of Number in a stringHi, I've got some idea We know that numeric characters have a values from 0030-0039 in hexadecimal code(UTF8) - i checked this on teradata (windows an unix platforms). So my idea is to convert ...
924 Mar 2011 @ 04:38 PDTDatabaseReplyBteq script - error handling not working, need helpHi I suppose thet you run this bteq script within another script(shell)?. So the problem is with: bteq >> ../log/spend_analysis.log < 0 THEN .GOTO SCRIPT_FAILED; You have to implement error ha...
816 Mar 2011 @ 05:56 PDTDatabaseReplyLink tables and timestamp dateHi, check this and say does it satisfy You create table table1 ( Cust_Ref integer, load_date timestamp ) insert into table1 values(3,'2011-01-31 00:00:00'); insert into table1 values(4,'20...
713 May 2010 @ 06:25 PDTDatabaseReplyHow to create records from a defined rangeCarlos thanks a lot. I've got one more question. Joining with calendar causes product join. Because my main table has thousands records the spool table(joining with calendar) has over than 100 m...
629 Apr 2010 @ 01:13 PDTDatabaseReplyHow to create records from a defined rangeThanks for reply Carlos :-) Very clever solution, but there is one big barrier which causes that I can't use it. Calendar contains days from years 1900-2100 so max. value of day_of_calendar is ...
527 Apr 2010 @ 02:11 PDTDatabaseTopicHow to create records from a defined rangeHi All I've got a problem to resolve. Table contains an ID and two columns(lo,hi) defining range of numbers. I need output(table) that will contain as many records as are defined in a range for ...

Pages