Relational databases/ OBDC connections...

[Brian Stephens]

This is a legacy app that I'm not wanting  to change..

I have a database say a product catalog  that is used throughout the sister
compnaies have identical databases.

I use the same programs But when the user is working on the different
companies they need to hit the DB for the company they are  working..

I need some mechanism to point to the different databases..


There are actually 2 problems
ACCESS PRODUCTS on the HP
becomes
ACCESS  Schema.PRODUCTS in COMPANYA



I can select which OBDC driver is attached..

>         DATABASE COMPANY  &
>         Type ODBC &
>         Open $COMPANY &
>         UserID "********" &
>         Password "********"

It works fine but
the ODBC or DB2 is adding the schema to the table name which takes away the
uniqueness

show files
TEST2.CUSTOMER                                                   IN COMPANYA




On Tue, Jun 11, 2013 at 10:52 AM, Bob Deskin <Bob.Deskin at ca.ibm.com> wrote:

> I may not understand this totally, but if the individual databases can be
> identified on open/attach, you may be able to use environment variables in
> the OPEN in PDL. If the instances are accessed by different users, perhaps
> an OWNER technique would work.
>
> Bob
>
>
>
> From:        Brian Stephens <bws001 at gmail.com>
> To:        powerh-l at lists.sowder.com,
> Date:        2013-06-11 10:22 AM
> Subject:        Relational databases/ OBDC connections...
> Sent by:        powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com
> ------------------------------
>
>
>
> If you had multiple instances or the same database.. and you wanted to
> control that access externally (because you only want to have one copy of
> the program)
> How can you do it... (on the HP sonce the PDL controlled the open a file
> equation it was easy)  But on ODBC i'm trying to wrap my head around how to
> make it work..
>
>
> Our platform is windows and the target database is DB2 on iSeries via
> ODBC..
>
>
> It doesn't appear I can insert a system variable in the ACCESS statement
>
> It appears I can do this in the PDL.. so I may have some rethink of the DB
> architecture unless someone else has some ideas..
>
> PS i'm just a bit fuzzy... taking a week to move and driving 2700 km can
> do that too you..
>
>
>
> --
> Thanks
>
> Brian Stephens --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: 'subscribe' in message body to
> powerh-l-request at lists.sowder.com
> Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to
> powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com powerh-l' to your search terms to search the
> list archive at Google.
>



-- 
Thanks

Brian Stephens
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20130611/7ed8aa8a/attachment.htm>