RE: Client - Server

["Wilt, Charles" <WiltC@xxxxxxxxxx>]

> -----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.