#DateForumTypeThreadPost
3005 Nov 2014 @ 10:16 PSTDatabaseTopiccoalesec((min(start_dt) over(partition by a_id, b_id order by start_dt asc rows between 1 following and 1 following ))-1,'9999-0Hi ,   Getting error when i run below stmt ... Plzz help on this , if it wont work i need to write update separately to update null recs i want to avoid it...   coalesec((min(start_dt...
2931 Oct 2014 @ 04:26 PDTDatabaseTopicSize of a data type : Hi , Can we get size of a data type from database ? for ex : for integer : 4 Bytes   Can we get this info from any dbc tables or any other way ?....   Thanks, Rajendra Reddy
2817 Oct 2014 @ 06:24 PDTDatabaseReplyTD 14 UDFS/ORACLE EQIVALeNT FUNCTIONS Thanks Max...
2714 Oct 2014 @ 04:02 PDTDatabaseTopicTD 14 UDFS/ORACLE EQIVALeNT FUNCTIONS Hi Gurus,   Can you please tell where can i get new TD14 functions list and usage about those.   Thnaks in Adv... Rajendra
2611 Oct 2014 @ 01:09 PDTDatabaseReplyAnalytic functionHi try like this, count(empl_id) over(partition by empl_id,date order by date rows between 1 preceding and 1 preceding)  
2509 Oct 2014 @ 04:10 PDTDatabaseReplysimplest way to search substring and set flaglserlohn2 , its working for me try once .......   select '000, 111, 123' as List , case when POSITION('000' IN  List)>0 then 1 end  FLG1     ...
2422 Sep 2014 @ 06:55 PDTDatabaseReplyOn a Db object which all are the users having access?Its really helpful , Thanks Rglass....:)  
2319 Sep 2014 @ 05:44 PDTDatabaseTopicOn a Db object which all are the users having access?hi , could you please tell me how to find which all are the users having access On a Db object?.   ex : i have a table user_sales_table , i would like to know the users list who has access ...
2212 Sep 2014 @ 07:46 PDTDatabaseReplyPass single quote as parameter in stored procedureHopefully here is ur solution .......Plz check once replace procedure proc1 (in oprList varchar(500)) begin declare ssql1 varchar(1000); set ssql1=' create table table12 ( ' || oprLi...
2109 Sep 2014 @ 02:54 PDTGeneralReplyGeneral QuestionMultiLoad along with MULTISET table will be better in your case.If u dont want duplucates then go for FASTLOAD&multiset table  combination.
2009 Sep 2014 @ 02:49 PDTGeneralReplyDATA TYPE FOR EMAIL ADDRESSi think varchar should be fine for email address...
1909 Sep 2014 @ 02:40 PDTDatabaseReplyHow to resolve blocking of sessionsPlz try like dis..... Lock Table UDAMLDEV.GDW_STG_ACCT_CLIST for ACCESS nowait Select * from UDAMLDEV.GDW_STG_ACCT_CLIST; if u get below msz Then the table is locked. 7423, "Object alr...
1809 Sep 2014 @ 02:28 PDTUDAReplyProblem Using UPSERTHi , I have flat file with two columns data : id  name -- ------- 1 raj     and if i try to do only  update will it allow ? bcz id=2 not avail in table as well. update ...
1709 Sep 2014 @ 02:01 PDTDatabaseReplyHow do I convert a date or timestamp to a string in Teradataplease try this........ select cast(current_timestamp(0) as timestamp(0) format 'YYYYMMDDHHMISS') ;  *** Query completed. One row found. One column returned.  *** Total ...
1613 Aug 2014 @ 09:08 PDTDatabaseReplyswap values in two columns using update SQLGlass , Its awesome . I couldn't expect that solution is this much Easy....
1513 Aug 2014 @ 02:47 PDTDatabaseReplyUnicode dataCarlosal, My session char set is ASCII , could you please tell me how to change it to unicode.
1413 Aug 2014 @ 01:04 PDTDatabaseReplyUnicode dataCarlosal, here below am providing example with some data wil give better explanation of my requirement. ex: col1 ------- abc 漢字; abc漢 in col1 i have data like above . Bu...
1313 Aug 2014 @ 12:47 PDTDatabaseReplyTranspose columns to row in a single queryMOUSUSI, sel  max(case when rn=1 then ref.a end) as X,          max(case when rn=2 then ref.a end)  as y,          m...
1213 Aug 2014 @ 12:25 PDTDatabaseReplyUnicode dataCarlosal, I think TRANSLATE_CHK() will do chk on un translatable char's . I would like to determine wether unicode data is present or not ?. I am not bothering about untranslatable chars. D...
1113 Aug 2014 @ 12:22 PDTDatabaseReplyDelete duplicate in a single querysel A,B,C FROM table group by A,B,C .    
1012 Aug 2014 @ 11:36 PDTDatabaseTopicUnicode dataHi , can some one help me to find out sol...   How to determine one column has unocode data or not ? is there any function avail??   Reason :: I have one table , it has huge data. On...
909 Aug 2014 @ 06:12 PDTDatabaseReplyStored procedure conversion from Oracle to TeradataDieter , Can you please provide more info. on below stmt. **When you CALL the SP it's actually calling an exported function of that shared object **   While calling exported function o...
809 Aug 2014 @ 05:53 PDTDatabaseReplyBlank space check based on the positionPFB :: sel 'abc def' as str1 ,'abcdef' as str2 ,char(str1) ,char(oreplace(str1,' ','')) ,char(str2) ,case when char(str1)<>char(oreplace(str1,'...
709 Aug 2014 @ 05:52 PDTDatabaseReplyBlank space check based on the positionCan you plase check below code.   sel 'abc def' as str1 ,'abcdef' as str2 ,char(str1) ,char(oreplace(str1,' ','')) ,char(str2) ,case when char(str...
609 Aug 2014 @ 05:23 PDTDatabaseReplyDelete from table allThank u dieter..its really helpful .

Pages