With Data Studio, I was able to open and view the BLOB data of approximately size of 18,718 in size.
Edmund,
Thanks! I forgot about that, only a few month ago! Not long at all, but forgot...
This last Service pack has been great, resolve almost all my problems. Except for the Filter on the find not working. Still have to click to activate the filter approximately 50% of the time. Oh well...
I have finally re-installed IBM Data Studio 4.1.2, and did sql on a large db2 table with HUGE fields.
When I double click on the result table, I was able to open this large BLOB in a text box with SCROLL-BARs! Wow! What a concept! <Evil Smirk>
And I was able to scroll through a XML field defined as 32,000 bytes. Because it has Scroll-bars! <Big smile>
SquirrelSQL.org also have scroll-bars. <Joy Joy> But, Squirrel does not show me "BLOB" fields. <sad face>
I only hope that sometime in the future that RDI can do the same! <smirk>
When it is under 4,095, I cut & paste into NotePad++ to view the data. Since the monitor variable has no scroll bars. What a "novel" concept to have scroll-bars for larger data... <shock>
I guess I am a rare developer that need to examine large data returned from vendor web-services, and report back errors, because their stinking software does not work. Whoops, I am venting, because that is why I need to see the large strings... <frown> Otherwise, it would probably be a "Non-Issue" for me... <smirk>
-Ken Killian-
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Edmund Reinhardt
Sent: Wednesday, January 6, 2016 4:57 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] RDI 9.5.0.2 cannot display Large variable like Green Screen... <shock>
The RFE already exists
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=77798
Just vote for it.
From: Buck Calabro <kc2hiz@xxxxxxxxx>
To: wdsci-l@xxxxxxxxxxxx
Date: 01/06/2016 01:38 PM
Subject: Re: [WDSCI-L] RDI 9.5.0.2 cannot display Large variable like
Green Screen... <shock>
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>
On 1/6/2016 11:56 AM, Ken Killian wrote:
Working with a Microsoft Developer, and I am trying to see data
returned
from a web-service that is over 32K in size....
Using Microsoft, he is getting back the correct data, but trying debug
the using RDI 9.5.0.2 I am limited to 1,024 bytes....
I try doing a monitor "MyVariable:C 5000" and only returns a maximum
of
4,095. <Perplexed Look>
Same.
9.5.0.2, Win 7 32-bit
dcl-s bigfield char(65000) inz(*all'1234567890'); monitor bigfield:c 5000 The Monitors View does not show 5k characters. Too lazy to count them.
Double click it, to be able to change the value. This window says
Offset: 0 Length: 4095 and in fact, the last characters shown are '12345' so I believe that it really is truncated to 4095 bytes.
I have similar behaviour with bigfield:c 10000; the change window stops at 4095 bytes.
monitor %substr(bigfield 5001 10) shows 1234567890 as expected.
Double click to change shows what seems to be the right characters, but actually changing them results in Server: CPF7E12 Identifier does not exist.
Sounds like a bug (for the truncation) and maybe an RFE (to be able to change a substring).
--
--buck
Visit wiki.midrange.com and register for an account. Edit a page that helps you, and because it's public, you'll help someone else, too!
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
midrange.com
