Re: List all objects attached to a journal

On 7/2/2015 5:33 PM, Matt Olson wrote:

Any idea why when I select from that file it is all hexadecimal

gibberish when using tools like iSeries navigator run sql scripts?

I can view it fine with strsql from a 5250 session, but still run

into limits of the 5250 session display and paging.

Almost there! Just need to figure out how to get it to display

properly in a "real" query tool like run sql scripts in navigator,
sqldbx, or ibm data studio

Wow, that is ugly.
The reason is that the WRKJRNA command apparently creates each column
with CCSID(65535) - which is 'binary data, do not translate'. That
seems a defect to me, since on my system the default CCSID is 37 - US
English. I'll have to take that up with IBM.

For the moment, if you are using the IBM i Navigator, go to Connection

Temporary JDBC Settings, click the Translate tab and select Translate
CCSID 65535. That should help some, although the columns out on the
end
still look goofy to me.

--
--buck

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.