RE: Client - Server

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Raul A. Jager W.
Sent: Friday, June 29, 2007 8:47 AM
To: Midrange Systems Technical Discussion
Subject: Client - Server

Recently I got a beatifull (Looking) visual basic program to
enter/maintain purchase orders using ODBC to the iSeries.

For this program to work I had to give the user *CHANGE
access to the "order_header" and "order_detail" tables.

Now I have to questions:

1- How can I keep this user from reading the tables from
other programs like exel?

You can't really. Nor can you keep them from changing the data.

Instead of allowing the user to sign on with there own profile, you could have
the application use its
own specific profile.

Another option, your application could call stored procedures instead of
accessing the data directly.

There are of course other options.

2- How can I define "commitment control" to avoid "half trasactions"
when the program fails?

OBDC driver uses commitment control by default. Unless you've turned it off,
you are using commitment
control. However, it is probably working per automatically "statement" instead
of the per transaction
you want.

While I don't recall the specifics off the top of my head, you need to set a
property on the
connection that turns off auto-commit and allows your application to issue the
commits as appropriate.

HTH,
Charles



This e-mail transmission contains information that is intended to be
confidential and privileged. If you receive this e-mail and you are not a
named addressee you are hereby notified that you are not authorized to read,
print, retain, copy or disseminate this communication without the consent of
the sender and that doing so is prohibited and may be unlawful. Please reply
to the message immediately by informing the sender that the message was
misdirected. After replying, please delete and otherwise erase it and any
attachments from your computer system. Your assistance in correcting this
error is appreciated.