Relational databases/ OBDC connections...

[Bob Deskin]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20130611/95c29abc/attachment.htm>