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 » WebSphere Message Broker (ACE) Support » Length function Issue

Post new topic  Reply to topic
 Length function Issue « View previous topic :: View next topic » 
Author Message
vspprasad
PostPosted: Sat Dec 13, 2014 2:59 pm    Post subject: Length function Issue Reply with quote

Newbie

Joined: 18 Dec 2012
Posts: 4
Hello,

We are using below Length function to calculate BLOB Msg Size but its not able to give below blob msg size . Could you please any one help on this ?

SET blob_data_size = LENGTH(blob_data);
Here is the blob data :
------------

3c53204e3d225330303330303752223e3c4f3e3c46204e3d2237522d45422d
494e442220563d2259222f3e3c46204e3d224349532d5355422d424f2d3036
2220563d223836222f3e3c53204e3d225330303330303751223e3c4f3e3c46
204e3d2250524f502d4c4f432d4e4f2220563d22303031222f3e3c46204e3d2
237512d42434547532220563d223036222f3e3c46204e3d2237512d454646
2d424c44472d594541522220563d2231393938222f3e3c46204e3d2237512d
594541522d424c542220563d2231393938222f3e3c46204e3d2237512d464c
4f4f52532220563d2231222f3e3c46204e3d224c4f432d544552522d4344222
0563d2234393130222f3e3c46204e3d224c4f432d524154494e472d504c414
e2220563d22504744222f3e3c46204e3d2250524f502d53542d43442220563
d223133222f3e3c46204e3d224c53532d494e434d2d494e442220563d22592
22f3e3c46204e3d22504552532d50524f502d494e442220563d2259222f3e3
c46204e3d2237512d5350522d494e442220563d224e222f3e3c46204e3d223
7512d4c50522d494e442220563d224e222f3e3c46204e3d225245414c2d505
24f502d494e442220563d2259222f3e3c46204e3d224c4f432d50524f542d43
4c53532d43442220563d2234222f3e3c46204e3d2250524f502d474152442d
494e442220563d2252222f3e3c46204e3d224c4f432d53504b4c2d494e4422
20563d224e222f3e3c46204e3d224c4f432d45432d434e53542d4344222056
3d2231222f3e3c46204e3d224c4f432d434e53542d43442220563d2231222f
3e3c46204e3d2237512d4d4953432d4c494d4954532220563d2230222f3e3c
46204e3d224c4f432d4d4f442d494e442220563d224e222f3e3c53204e3d22
5330303330303753223e3c4f3e3c46204e3d2239392d50522d434f562d5052
4c2d4b45592220563d2231222f3e3c46204e3d22464952452d582d53544b2d
434f2d494e532d5043542220563d2230222f3e3c46204e3d22464952452d58
2d53544b2d4445442d414d542220563d2235303030222f3e3c46204e3d224
64952452d582d53544b2d4c4d542d414d542220563d223733373530303022
2f3e3c46204e3d22464952452d582d53544b2d4445442d43522d504354222
0563d22302e3834222f3e3c2f4f3e3c4f3e3c46204e3d2239392d50522d434f
562d50524c2d4b45592220563d2232222f3e3c46204e3d2245432d434f2d49
4e532d5043542220563d2230222f3e3c46204e3d22464952452d582d53544
b2d434f2d494e532d5043542220563d2230222f3e3c46204e3d22464952452
d582d53544b2d4445442d414d542220563d2235303030222f3e3c46204e3d
22464952452d582d53544b2d4c4d542d414d542220563d223335363030303
030222f3e3c46204e3d22464952452d582d53544b2d4445442d43522d5043
542220563d22302e3834222f3e3c2f4f3e3c2f533e3c53204e3d22533030333
0305445223e3c4f3e3c46204e3d2239392d50522d54452d4b45592220563d2
231222f3e3c46204e3d2254452d434f2d494e532d5043542220563d2230222
f3e3c46204e3d2254452d4c4d542d4f462d494e532220563d2231313437353
03030222f3e3c2f4f3e3c2f533e3c2f4f3e3c4f3e3c46204e3d2250524f502d4c
4f432d4e4f2220563d22303032222f3e3c46204e3d2237512d424345475322
20563d223939222f3e3c46204e3d2237512d4546462d424c44472d59454152
2220563d2231393935222f3e3c46204e3d2237512d594541522d424c542220
563d2231393935222f3e3c46204e3d2237512d464c4f4f52532220563d2231
222f3e3c46204e3d224c4f432d544552522d43442220563d2234393130222f
3e3c46204e3d224c4f432d524154494e472d504c414e2220563d2250474422
2f3e3c46204e3d2250524f502d53542d43442220563d223133222f3e3c4620
4e3d224c53532d494e434d2d494e442220563d2259222f3e3c46204e3d2250
4552532d50524f502d494e442220563d2259222f3e3c46204e3d2237512d53
50522d494e442220563d224e222f3e3c46204e3d2237512d4c50522d494e44
2220563d224e222f3e3c46204e3d225245414c2d50524f502d494e44222056
3d2259222f3e3c46204e3d224c4f432d50524f542d434c53532d43442220563
d2234222f3e3c46204e3d2250524f502d474152442d494e442220563d22522
22f3e3c46204e3d224c4f432d53504b4c2d494e442220563d224e222f3e3c46
204e3d224c4f432d45432d434e53542d43442220563d2231222f3e3c46204e
3d224c4f432d434e53542d43442220563d2231222f3e3c46204e3d2237512d
4d4953432d4c494d4954532220563d2230222f3e3c46204e3d224c4f432d4d
4f442d494e442220563d224e222f3e3c53204e3d225330303330303753223e
3c4f3e3c46204e3d2239392d50522d434f562d50524c2d4b45592220563d22
32222f3e3c46204e3d22464952452d582d53544b2d4445442d43522d50435
42220563d22302e3834222f3e3c2f4f3e3c2f533e3c53204e3d225330303330
305445223e3c4f3e3c46204e3d2239392d50522d54452d4b45592220563d22
31222f3e3c46204e3d2254452d4c4d542d4f462d494e532220563d2230222f
3e3c2f4f3e3c2f533e3c2f4f3e3c4f3e3c46204e3d2250524f502d4c4f432d4e4f
2220563d22303033222f3e3c46204e3d2237512d42434547532220563d223
035222f3e3c46204e3d2237512d4546462d424c44472d594541522220563d2
232303030222f3e3c46204e3d2237512d594541522d424c542220563d22323
03030222f3e3c46204e3d2237512d464c4f4f52532220563d2231222f3e3c46
204e3d224c4f432d544552522d43442220563d2234383030222f3e3c46204e
3d224c4f432d524154494e472d504c414e2220563d22504744222f3e3c4620
4e3d2250524f502d53542d43442220563d223133222f3e3c46204e3d224c53
532d494e434d2d494e442220563d2259222f3e3c46204e3d22504552532d5
0524f502d494e442220563d2259222f3e3c46204e3d2237512d5350522d494
e442220563d224e222f3e3c46204e3d2237512d4c50522d494e442220563d224e222f3e3c46204e3d225245414c2d50524f502d494e442220563d2259222
f3e3c46204e3d224c4f432d50524f542d434c53532d43442220563d2235222f
3e3c46204e3d2250524f502d474152442d494e442220563d2252222f3e3c46
204e3d224c4f432d53504b4c2d494e442220563d224e222f3e3c46204e3d22
4c4f432d45432d434e53542d43442220563d2231222f3e3c46204e3d224c4f4
32d434e53542d43442220563d2231222f3e3c46204e3d2237512d4d495343
2d4c494d4954532220563d2230222f3e3c46204e3d224c4f432d4d4f442d494
e442220563d224e222f3e3c53204e3d225330303330303753223e3c4f3e3c4
6204e3d2239392d50522d434f562d50524c2d4b45592220563d2232222f3e3
c46204e3d22464952452d582d53544b2d4445442d43522d5043542220563d
22302e3834222f3e3c2f4f3e3c2f533e3c53204e3d225330303330305445223
e3c4f3e3c46204e3d2239392d50522d54452d4b45592220563d2231222f3e3
c46204e3d2254452d4c4d542d4f462d494e532220563d2230222f3e3c2f4f3e
3c2f533e3c2f4f3e3c4f3e3c46204e3d2250524f502d4c4f432d4e4f2220563d2
2303034222f3e3c46204e3d2237512d42434547532220563d223035222f3e3
c46204e3d2237512d4546462d424c44472d594541522220563d2231393939
222f3e3c46204e3d2237512d594541522d424c542220563d2231393939222f
3e3c46204e3d2237512d464c4f4f52532220563d2234222f3e3c46204e3d224
c4f432d544552522d43442220563d2232313030222f3e3c46204e3d224c4f43
2d524154494e472d504c414e2220563d22504744222f3e3c46204e3d225052
4f502d53542d43442220563d223132222f3e3c46204e3d224c53532d494e43
4d2d494e442220563d2259222f3e3c46204e3d22504552532d50524f502d49
4e442220563d2259222f3e3c46204e3d2237512d5350522d494e442220563
d224e222f3e3c46204e3d2237512d4c50522d494e442220563d224e222f3e3
c46204e3d225245414c2d50524f502d494e442220563d2259222f3e3c46204
e3d224c4f432d50524f542d434c53532d43442220563d2233222f3e3c46204e
3d2250524f502d474152442d494e442220563d2252222f3e3c46204e3d224c
4f432d53504b4c2d494e442220563d2259222f3e3c46204e3d224c4f432d454
32d434e53542d43442220563d2233222f3e3c46204e3d224c4f432d434e535
42d43442220563d2233222f3e3c46204e3d2237512d4d4953432d4c494d495
4532220563d2230222f3e3c46204e3d224c4f432d4d4f442d494e442220563
d224e222f3e3c53204e3d225330303330303753223e3c4f3e3c46204e3d223
9392d50522d434f562d50524c2d4b45592220563d2232222f3e3c46204e3d2
2464952452d582d53544b2d4445442d43522d5043542220563d22302e3834
222f3e3c2f4f3e3c2f533e3c53204e3d225330303330305445223e3c4f3e3c46
204e3d2239392d50522d54452d4b45592220563d2231222f3e3c46204e3d2
254452d4c4d542d4f462d494e532220563d2230222f3e3c2f4f3e3c2f533e3c2
f4f3e3c4f3e3c46204e3d2250524f502d4c4f432d4e4f2220563d22303035222
f3e3c46204e3d2237512d42434547532220563d223939222f3e3c46204e3d2
237512d4546462d424c44472d594541522220563d2231393938222f3e3c462
04e3d2237512d594541522d424c542220563d2231393938222f3e3c46204e3
d2237512d464c4f4f52532220563d2231222f3e3c46204e3d224c4f432d5445
52522d43442220563d2235303530222f3e3c46204e3d224c4f432d52415449
4e472d504c414e2220563d22504744222f3e3c46204e3d2250524f502d5354
2d43442220563d223132222f3e3c46204e3d224c53532d494e434d2d494e44
2220563d2259222f3e3c46204e3d22504552532d50524f502d494e44222056
3d2259222f3e3c46204e3d2237512d5350522d494e442220563d224e222f3e
3c46204e3d2237512d4c50522d494e442220563d224e222f3e3c46204e3d22
5245414c2d50524f502d494e442220563d2259222f3e3c46204e3d224c4f432
d50524f542d434c53532d43442220563d2234222f3e3c46204e3d2250524f5
02d474152442d494e442220563d2252222f3e3c46204e3d224c4f432d53504
b4c2d494e442220563d224e222f3e3c46204e3d224c4f432d45432d434e535
42d43442220563d2231222f3e3c46204e3d224c4f432d434e53542d4344222
0563d2231222f3e3c46204e3d2237512d4d4953432d4c494d4954532220563
d2230222f3e3c46204e3d224c4f432d4d4f442d494e442220563d224e222f3e
3c53204e3d225330303330303753223e3c4f3e3c46204e3d2239392d50522d
434f562d50524c2d4b45592220563d2232222f3e3c46204e3d22464952452d
582d53544b2d4445442d43522d5043542220563d22302e3834222f3e3c2f4f
3e3c2f533e3c53204e3d225330303330305445223e3c4f3e3c46204e3d2239
392d50522d54452d4b45592220563d2231222f3e3c46204e3d2254452d4c4d
542d4f462d494e532220563d2230222f3e3c2f4f3e3c2f533e3c2f4f3e3c4f3e3
c46204e3d2250524f502d4c4f432d4e4f2220563d22303036222f3e3c46204e
3d2237512d42434547532220563d223939222f3e3c46204e3d2237512d454
6462d424c44472d594541522220563d2231393934222f3e3c46204e3d22375
12d594541522d424c542220563d2231393934222f3e3c46204e3d2237512d4
64c4f4f52532220563d2233222f3e3c46204e3d224c4f432d544552522d4344
2220563d2230373030222f3e3c46204e3d224c4f432d524154494e472d504c
414e2220563d22504744222f3e3c46204e3d2250524f502d53542d43442220
563d223234222f3e3c46204e3d224c53532d494e434d2d494e442220563d22
59222f3e3c46204e3d22504552532d50524f502d494e442220563d2259222f
3e3c46204e3d2237512d5350522d494e442220563d224e222f3e3c46204e3d
2237512d4c50522d494e442220563d224e222f3e3c46204e3d225245414c2d
50524f502d494e442220563d2259222f3e3c46204e3d224c4f432d50524f542
d434c53532d43442220563d2233222f3e3c46204e3d2250524f502d4741524
42d494e442220563d2252222f3e3c46204e3d224c4f432d53504b4c2d494e4
42220563d2259222f3e3c46204e3d224c4f432d45432d434e53542d4344222
0563d2232222f3e3c46204e3d224c4f432d434e53542d43442220563d22322
22f3e3c46204e3d2237512d4d4953432d4c494d4954532220563d2230222f3
e3c46204e3d224c4f432d4d4f442d494e442220563d224e222f3e3c53204e3d
225330303330303753223e3c4f3e3c46204e3d2239392d50522d434f562d50
524c2d4b45592220563d2232222f3e3c46204e3d22464952452d582d53544b
2d4445442d43522d5043542220563d22302e3834222f3e3c2f4f3e3c2f533e3
c53204e3d225330303330305445223e3c4f3e3c46204e3d2239392d50522d5
4452d4b45592220563d2231222f3e3c46204e3d2254452d4c4d542d4f462d4
94e532220563d2230222f3e3c2f4f3e3c2f533e3c2f4f3e3c4f3e3c46204e3d22
50524f502d4c4f432d4e4f2220563d22303037222f3e3c46204e3d2237512d4
2434547532220563d223036222f3e3c46204e3d2237512d4546462d424c444
72d594541522220563d2231393937222f3e3c46204e3d2237512d59454152
2d424c542220563d2231393937222f3e3c46204e3d2237512d464c4f4f52532
220563d2231222f3e3c46204e3d224c4f432d544552522d43442220563d223
3363530222f3e3c46204e3d224c4f432d524154494e472d504c414e2220563
d22504744222f3e3c46204e3d2250524f502d53542d43442220563d2232342
22f3e3c46204e3d224c53532d494e434d2d494e442220563d2259222f3e3c4
6204e3d22504552532d50524f502d494e442220563d2259222f3e3c46204e3
d2237512d5350522d494e442220563d224e222f3e3c46204e3d2237512d4c5
0522d494e442220563d224e222f3e3c46204e3d225245414c2d50524f502d4
94e442220563d2259222f3e3c46204e3d224c4f432d50524f542d434c53532d
43442220563d2233222f3e3c46204e3d2250524f502d474152442d494e4422
20563d2252222f3e3c46204e3d224c4f432d53504b4c2d494e442220563d22
4e222f3e3c46204e3d224c4f432d45432d434e53542d43442220563d223122
2f3e3c46204e3d224c4f432d434e53542d43442220563d2231222f3e3c46204
e3d2237512d4d4953432d4c494d4954532220563d2230222f3e3c46204e3d2
24c4f432d4d4f442d494e442220563d224e222f3e3c53204e3d22533030333
0303753223e3c4f3e3c46204e3d2239392d50522d434f562d50524c2d4b455
92220563d2232222f3e3c46204e3d22464952452d582d53544b2d4445442d
43522d5043542220563d22302e3834222f3e3c2f4f3e3c2f533e3c53204e3d2
25330303330305445223e3c4f3e3c46204e3d2239392d50522d54452d4b455
92220563d2231222f3e3c46204e3d2254452d4c4d542d4f462d494e5322205
63d2230222f3e3c2f4f3e3c2f533e3c2f4f3e3c4f3e3c46204e3d2250524f502d
4c4f432d4e4f2220563d22303038222f3e3c46204e3d2237512d4243454753
2220563d223939222f3e3c46204e3d2237512d4546462d424c44472d594541
522220563d2231393935222f3e3c46204e3d2237512d594541522d424c5422
20563d2231393935222f3e3c46204e3d2237512d464c4f4f52532220563d22
31222f3e3c46204e3d224c4f432d544552522d43442220563d223330353022
2f3e3c46204e3d224c4f432d524154494e472d504c414e2220563d22504744
222f3e3c46204e3d2250524f502d53542d43442220563d223132222f3e3c46
204e3d224c53532d494e434d2d494e442220563d2259222f3e3c46204e3d22
504552532d50524f502d494e442220563d2259222f3e3c46204e3d2237512d
5350522d494e442220563d224e222f3e3c46204e3d2237512d4c50522d494e
442220563d224e222f3e3c46204e3d225245414c2d50524f502d494e442220
563d2259222f3e3c46204e3d224c4f432d50524f542d434c53532d434422205
63d2234222f3e3c46204e3d2250524f502d474152442d494e442220563d225
2222f3e3c46204e3d224c4f432d53504b4c2d494e442220563d224e222f3e3c
46204e3d224c4f432d45432d434e53542d43442220563d2231222f3e3c4620
4e3d224c4f432d434e53542d43442220563d2231222f3e3c46204e3d223751
2d4d4953432d4c494d4954532220563d2230222f3e3c46204e3d224c4f432d
4d4f442d494e442220563d224e222f3e3c53204e3d22533030333030375322
3e3c4f3e3c46204e3d2239392d50522d434f562d50524c2d4b45592220563d
2232222f3e3c46204e3d22464952452d582d53544b2d4445442d43522d504
3542220563d22302e3834222f3e3c2f4f3e3c2f533e3c53204e3d2253303033
30305445223e3c4f3e3c46204e3d2239392d50522d54452d4b45592220563d
2231222f3e3c46204e3d2254452d4c4d542d4f462d494e532220563d223022
2f3e3c2f4f3e3c2f533e3c2f4f3e3c4f3e3c46204e3d2250524f502d4c4f432d4e
4f2220563d22303039222f3e3c46204e3d2237512d42434547532220563d22
3036222f3e3c46204e3d2237512d4546462d424c44472d594541522220563d
2232303036222f3e3c46204e3d2237512d594541522d424c542220563d2232
303036222f3e3c46204e3d2237512d464c4f4f52532220563d2234222f3e3c4
6204e3d224c4f432d544552522d43442220563d2233363530222f3e3c46204
e3d224c4f432d524154494e472d504c414e2220563d22504744222f3e3c462
04e3d2250524f502d53542d43442220563d223234222f3e3c46204e3d224c5
3532d494e434d2d494e442220563d2259222f3e3c46204e3d22504552532d
50524f502d494e442220563d2259222f3e3c46204e3d2237512d5350522d49
4e442220563d224e222f3e3c46204e3d2237512d4c50522d494e442220563d
224e222f3e3c46204e3d225245414c2d50524f502d494e442220563d225922
2f3e3c46204e3d224c4f432d50524f542d434c53532d43442220563d2233222
f3e3c46204e3d2250524f502d474152442d494e442220563d2252222f3e3c4
6204e3d224c4f432d53504b4c2d494e442220563d2259222f3e3c46204e3d2
24c4f432d45432d434e53542d43442220563d2231222f3e3c46204e3d224c4f
432d434e53542d43442220563d2231222f3e3c46204e3d2237512d4d49534
32d4c494d4954532220563d2230222f3e3c46204e3d224c4f432d4d4f442d49
4e442220563d224e222f3e3c53204e3d225330303330303753223e3c4f3e3c
46204e3d2239392d50522d434f562d50524c2d4b45592220563d2232222f3e
3c46204e3d22464952452d582d53544b2d4445442d43522d5043542220563
d22302e3834222f3e3c2f4f3e3c2f533e3c53204e3d22533030333030544522
3e3c4f3e3c46204e3d2239392d50522d54452d4b45592220563d2231222f3e
3c46204e3d2254452d4c4d542d4f462d494e532220563d2230222f3e3c2f4f3
e3c2f533e3c2f4f3e3c2f533e3c53204e3d225330303330304c37223e3c4f3e3
c46204e3d225349462d52542d4e4f2220563d22303031222f3e3c46204e3d2
24c372d42434547532220563d223036222f3e3c46204e3d225349462d43535
02d544552522220563d2234393130222f3e3c46204e3d225349462d435354
2d43442d46492220563d2231222f3e3c46204e3d225349462d4353542d434
42d45432220563d2231222f3e3c46204e3d224c372d4546462d424c44472d5
94541522220563d2231393938222f3e3c46204e3d224c372d594541522d424
c542220563d2231393938222f3e3c46204e3d224c372d464c4f4f5253222056
3d2231222f3e3c46204e3d225349462d504552494c2d4e45572220563d2230
3335222f3e3c46204e3d225349462d50524f502d474152442d504c414e2220
563d2252222f3e3c46204e3d225349462d524154494e472d504c414e222056
3d22504744222f3e3c46204e3d225349462d50524f542d434c53532220563d
2234222f3e3c46204e3d225349462d434f562d444553432220563d22435249
534953204d414e4147454d454e5420455854454e53494f4e2031343336323
3222f3e3c46204e3d225349462d434f562220563d22544d222f3e3c46204e3
d225349462d4c4d542220563d223235303030222f3e3c46204e3d225349462
d4c4f432220563d22303031222f3e3c46204e3d225349462d53542220563d2
23133222f3e3c46204e3d225349462d41444a2d465245512220563d223022
2f3e3c2f4f3e3c2f533e3c53204e3d225330303330324b34223e3c4f3e3c4620
4e3d2245422d52542d4b45592220563d2231222f3e3c46204e3d2245422d5
6454e444f522d4c4d542d4c4941422220563d223534343530303030222f3e3
c46204e3d2245422d434f562d434f44452220563d22485342222f3e3c2f4f3e
3c2f533e3c2f4f3e3c2f533e
-----------------------

Is there any restrictions on Length function.... ?
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Sat Dec 13, 2014 6:24 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
Well I'd say It really depends on what you are considering the size of the BLOB...

The size of the byte array or the size of the BLOB as it is written out in hex?

Have fun
_________________
MQ & Broker admin

Last edited by fjb_saper on Sun Dec 14, 2014 5:29 am; edited 1 time in total
Back to top
View user's profile Send private message Send e-mail
rekarm01
PostPosted: Sun Dec 14, 2014 4:09 am    Post subject: Re: Length function Issue Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 1415
This looks like a question for the broker forum.

vspprasad wrote:
We are using below Length function to calculate BLOB Msg Size but its not able to give below blob msg size.

Code:
SET blob_data_size = LENGTH(blob_data);

What does it do instead?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Length function Issue
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


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

Copyright © MQSeries.net. All rights reserved.