SQL Assistant

6 views

Skip to first unread message

NJensen

unread,

Dec 2, 2011, 1:14:38 PM12/2/11

to Web Object Wizard Community PlanetJ

This technology preview allows System i data to be accessed with zero
install and without 5722ST1. Requirements: Java enabled browswer,
Network access to your System i.

This is an overview of how to use the IBM i SQL Assistant from the
PlanetJ website. http://www.youtube.com/watch?v=TnTHjERz93I

The SQL Assistant can be found at http://www.planetjavainc.com/sqlAssistantAlpha.html

Travis Torgerson

unread,

Dec 15, 2011, 12:36:08 PM12/15/11

to Web Object Wizard Community PlanetJ

Some people may be experiencing data issues with our SQL Assistant.
If you are having issues with fields showing correct data (binary
fields not showing up properly), you can try to add these properties
to the end of your connection string:
;trace=false;prompt=false;translate binary=true

Note the position of the semicolons. Your connection should then look
something like:
<ip of your AS400>;trace=false;prompt=false;translate binary=true

On Dec 2, 12:14 pm, NJensen <njen...@planetjavainc.com> wrote:
> This technology preview allows System i data to be accessed with zero
> install and without 5722ST1. Requirements: Java enabled browswer,
> Network access to your System i.
>
> This is an overview of how to use the IBM i SQL Assistant from the