Monday, June 25, 2012

Manage JDBC Adapters in webMethods

Manager JDBC Adapters in webMethods

Package: WmART

1. Fucntion: WmART:pub.art.listRegisteredAdapters
List all registered adapters in webMethods server. It takes no input and return a list with adapterTypeName and adapterDisplayName. The adapterDisplayName is the name you see in the Connection Type column of the Connections table from IS Adapters > JDBC Adapter > Connections window. The adapterTypeName is the name to use for listAdapterConnections function.

2. Function: WmART:pub.art.connection.listAdapterConnections
List registered adapters in webMethods server. It takes one input, adpaterTypeName, i.e. "JDBCAdapter" for JDBC Adapter Connections.

3. Function: WmART: put.art.connection.disableConnection
It takes one input, connectionAlias, which is the name in Connection Name column of the Connections table on IS Adapters > JDBC Adapter > Connections window.

4. Function: WmART: put.art.connection.enableConnection
It takes one input, connectionAlias, which is the name in Connection Name column of the Connections table on IS Adapters > JDBC Adapter > Connections window.

Thursday, March 22, 2012

Manage names by using the Name Manager dialog box

Use the Name Manager dialog box to work with all of the defined names and table names in the workbook. For example, you may want to find names with errors, confirm the value and reference of a name, view or edit descriptive comments, or determine the scope. You can also sort and filter the list of names, and easily add, change, or delete names from one location.

To open the Name Manager dialog box, on the Formula tab, in the Defined Names group, click Name Manager

Sunday, February 19, 2012

三寸天堂 v.s. 夢のしずく v.s. Braveheart - 聽得出來嗎? (C調)



第一次聽到 严艺丹的《三寸天堂》 是有那麼一點似曾相識的感覺。 但批評人家抄襲, 我認為這些人有點酸葡萄心理。
http://www.wenzhousx.com/yule/yulebagua/39426.html

我倒覺得 严艺丹《三寸天堂》 和 松たか子《夢のしずく》 是有那麼一點學 Horner為影片《Braveheart》所做的配樂。

《三寸天堂》中的中國胡琴演奏增添了中國古典風味 與 《Braveheart》的蘇格蘭風笛 有著異曲同工之妙。
讓人覺得 严艺丹《三寸天堂》 有那麼一點點奧斯卡的味道。 難怪聽了以後, 感覺餘音繞樑, 久久不能忘記。
而 松たか子《夢のしずく》 就是一般流行歌曲, 感覺遜色的多了。

严艺丹《步步惊心》片尾曲《三寸天堂》【抄袭原曲-松隆子《梦的点滴》】? 這些網路上的批評文章 真的有點好笑。

P.S.
Braveheart Soundtrack: http://www.youtube.com/watch?v=9AN04imFDK8
严艺丹《三寸天堂》: http://www.youtube.com/watch?v=HKryDrp2Nds
松たか子《夢のしずく》: http://www.youtube.com/watch?v=wWnu-1gChko

Thursday, January 26, 2012

Awk Sed Sort Command Sample

Get the strings you need from a file, sort the strings, and then save it into another file.

cat 10000ACRB_wm_pdf.xsl | sed 's/RefID/RefID\n/' | 
grep RefType | sed 's/.*RefType/RefType/' | 
sed 's/RefType=./RT_/' | sed 's/.].*//' | 
sort | tee ACRB_RefTypes.txt

Read the new file line by line and then add strings you need.

while read line
do
if echo ${line} | grep -q ${preline}
then
equal=${line}
else
preline=${line}
echo ${line}
fi
done < ./ACRB_RefTypes.txt |
sed 's/RT_//' |
awk '{print "Map(XPath(\"/PmtRec/*s/RefInfo/*s/RefID\"), XPath(\"/DocMap/*s/ACRB_RefTypes/*s/RT_"
   $0
   "\"), [], \""
   $0
   "\")," }'