如何移除DB2上的全形空白

By philipz on January 7, 2011 3:46 PM | No TrackBacks

因Mainframe上的EBCDIC編碼，所以無法直接Replace掉。需先透過vargraphic函數才可以。

Replace(vargraphic(YOURCOL),'　', '')

No TrackBacks

TrackBack URL: http://server.everfine.com.tw/blog/mt-tb.cgi/308

February 2012

Sun Mon Tue Wed Thu Fri Sat
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29      

Archives

Recent Entries

Powered by Movable Type 4.34-en

Search

About this Entry

This page contains a single entry by philipz published on January 7, 2011 3:46 PM.

JavaMail + Google App Engine throw "The API package 'mail' or call 'Send()' was not found." was the previous entry in this blog.

SQL: Update with Subquery is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.