RE: PC tool to access 400 data

["Torres, Wanda" <WTorres@xxxxxxxxxxxx>]

Look at IBM Manual Client Access for Windows 3.1 ODBC  User's Guide,
and AS/400 Client Access Host Server Manual. There is a sample ODBC exit
program. You can control the following functions of ODBC.

*       Whether ODBC is allowed at  all.
*       What functions are allowed for AS/400.
*       What SQL statements are allowed.
*       What information can be retrieved about database server objects.
*       What SQL catalog functions are allowed.
> ---------
> 
Wanda

> <<File: vcard.vcf>>
> Yes, I was freaked out a little at first.  Then I got together with a
> couple of users and
> we ran some tests.  Apparently the users cannot link to any files that
> they are not
> authorized to.  I feel a little bit better now,  However, I was wondering
> if there is any
> way to write an ODBC exit program on the AS/400 to limit who can use ODBC
> for data
> access.  Does anybody know?
> 
> Chuck Lewis wrote:
> 
> > YIKES !!!
> >
> > Doesn't that SCARE YOU TO DEATH ???? !!!!
> >
> > Depending on what type of user this is and what data they are getting
> to, sounds like
> > they have WAY too much authority...
> >
> > Chuck
> >
> > Bob Clark wrote:
> >
> > > Microsoft Access works.  I just became aware that one of my users has
> figured out
> > > how to update AS/400 data directly using an output table generated
> from a
> > > Microsoft Access database containing a linked AS/400 table.  He is
> currently
> > > editing the data directly in the query table but in theory it
> shouldn't be much
> > > harder to set up a form.
> > >
> > > Ashok Dave wrote:
> > >
> > > > Does anyone know of a PC, maybe GUI based, tool that can be used to
> > > > access and update AS400 data ?
> > > > I know the "400 Group" recently presented seminars on how to do this
> > > > with certain packages but I did not have the need to know then. Now
> I do
> > > > !
> > > >
> > > > Thanks.
> > > > Ash
> > > >
> > > > ______________________________________________________
> > > > Get Your Private, Free Email at http://www.hotmail.com
> > > > +---
> > > > | This is the Midrange System Mailing List!
> > > > | To submit a new message, send your mail to
> MIDRANGE-L@midrange.com.
> > > > | To subscribe to this list send email to
> MIDRANGE-L-SUB@midrange.com.
> > > > | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> > > > | Questions should be directed to the list owner/operator:
> david@midrange.com
> > > > +---
> > >
> > >
> ------------------------------------------------------------------------
> > >
> > >   Bob Clark <bclark@ussafety.com>
> > >   Programmer/Analyst
> > >   US Safety
> > >
> > >   Bob Clark
> > >   Programmer/Analyst  <bclark@ussafety.com>
> > >   US Safety
> > >   8101 Lenexa Dr.     Work: 913-599-5555 x274
> > >   Lenexa              Fax: 913-599-1703
> > >   Ks                  Netscape Conference Address
> > >   66214               Netscape Conference DLS Server
> > >   USA
> > >   Additional Information:
> > >   Last Name      Clark
> > >   First Name     Bob
> > >   Version        2.1
> >
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator:
> david@midrange.com
> > +---
> 
> 
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---