#DateForumTypeThreadPost
919 Jul 2016 @ 06:09 PDTDatabaseReplyConvert the data in the Table into XML formatTried that as well. But doesn't help...
818 Jul 2016 @ 07:07 PDTDatabaseTopicConvert the data in the Table into XML formatHI All, I'm trying to convert the data in a table to XML format for an application. And the output I get is <Error>. Also , when i try to run the below statement i am gettting the same:...
721 Apr 2016 @ 07:45 PDTDatabaseReplyFetching maximum value from a VarChar Fieldmany thanks dieter... We are facing this issue while comparing the reports when executed from TD and DB2.  But changing the collation setting will that affect the data set pulled.   -...
620 Apr 2016 @ 09:01 PDTDatabaseTopicFetching maximum value from a VarChar FieldHi All, We are trying to pull the maximum value from a varchar column which is case specific. TD output is compared to DB2 ouput and both differs. We need to match with DB2 output and we are goin...
517 Jul 2013 @ 04:01 PDTPrivate Forum
416 May 2013 @ 12:04 PDTDatabaseReplyCan someone guide me in calculating the sum in the casethanks for the info Fred... Got the desired o/p.
315 May 2013 @ 10:26 PDTDatabaseReplyCan someone guide me in calculating the sum in the casethis one might give a better picture than the previous one   Sys Num, ID, Descr 0001, 10, Provider 0001, 10, Pro 0002...
215 May 2013 @ 07:12 PDTDatabaseTopicCan someone guide me in generating the Seq number?i/p data Sys Num, ID, Descr, 0001, 10, Provider 0001, 10, Pro 0002, 84, Service 0003, 24, Buisness 0003, 24, Admin ...
115 May 2013 @ 03:24 PDTDatabaseTopicCan someone guide me in calculating the sum in the caseTable data Sys Num Id  Descr 0001 10 Provider 0001 10 Pro 0...