#DateForumTypeThreadPost
209 Jul 2014 @ 09:18 PDTUDAReplyCheck newline character in a text columnYes you can replace NEWLINE using the OREPLACE function in SELECT. --removing \r\n SEL OREPLACE(OREPLACE(yourcolumn , X'0d' , ' ') , X'0a' , ' ') yourcolumn FROM...
116 Nov 2011 @ 02:14 PSTDatabaseReplyDifference between a TDPID and a USERID Hi, Case 1: When you access the Teradata server through FICON channel from IBM mainframe environment then we have to use TDPID to logon.  EX:  .logon TDPA/USERID,passwo...