iSeries Navigator – Run SQL Scripts

5 pts.
Tags:
AS/400
I normally use ISQL to execute my DML statements and to run simple queries, but I am trying to use the "Run SQL Scripts" function of iSeries Navigator. I have coded a simple Select * statement on one of our database files, but the character data is returned in hex. How can I see the text representation? My version of the application is V5R3M0. Thanks for any guidance that anyone can provide.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I stumbled onto my own answer and I just wanted to put it out here in case anyone else should ever run into it. The answer lies in the JDBC setup. Externally defined database files are stored using a CCSID of 65535 rather than the default of 37. To change it, go into the JDBC Setup under the Connection pull-down menu. Select “Translate CCSID 65535″ on the Translation tab. That will display AS/400 files in the format we all know and love.

==================================================================

More accurately, <b>your</b> externally defined database files are stored using CCSID 65535. They shouldn’t be, but that’s the way your system is set up — to use 65535.

Change your QCCSID system value from 65535 to a more useful setting such as 37. Create your data tagged as something other than binary (65535), and CCSID conversions between systems can happen automatically without needing to tweak settings for every PC and every application.

I know you didn’t create the situation. But you have the opportunity to research it and correct it.

Tom

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • BrentSheets
    JasonWV, thanks for having the community spirit and posting back the answer you discovered -- so others can benefit.
    6,925 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following