ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Search

 Search found 5 matches
Author Message
  Topic: How to Convert ROW to CHARACTER?
mrch1

Replies: 9
Views: 6483
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue Dec 01, 2009 1:12 am   Subject: How to Convert ROW to CHARACTER?
thanks for all replies!
It seems that there's no way that convert ROW type to CHARACTER directly.I've solved the problem indirectly.here is the way:
1.convert the ROW type to BLOB using ASBITSTREAM. ...
  Topic: How to Convert ROW to CHARACTER?
mrch1

Replies: 9
Views: 6483
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Sun Nov 29, 2009 10:28 pm   Subject: How to Convert ROW to CHARACTER?
Currently i've tried using CAST(ROW AS CHARACTER),but it doesn't work;
I searched the manual and i found the CAST function doesn't support the ROW type.
I just tried using ASBITSTREAM to convert a X ...
  Topic: MD5 hash and esql
mrch1

Replies: 2
Views: 7485
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Sun Nov 29, 2009 7:05 pm   Subject: MD5 hash and esql
i'm doing this in an easy way:
if you're using ORACLE database,create a storedproc called md5,so you can just use the sql "select md5(?) from dual" and passthru the sql you need with a para ...
  Topic: How to Convert ROW to CHARACTER?
mrch1

Replies: 9
Views: 6483
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Sun Nov 29, 2009 6:55 pm   Subject: How to Convert ROW to CHARACTER?
hi,I'm currently using WMB 6.1.0.4 and i have an issue like this:
There is a ROW struct for example:
<row>
<col>111</col>
<col>222</col>
<col>333& ...
  Topic: UTF 16 Chinese Characters
mrch1

Replies: 3
Views: 5227
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Sun Nov 29, 2009 6:37 pm   Subject: UTF 16 Chinese Characters
Hi!
I think you can try set the CCSID to 1381 or 1386
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.