× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



All,
 
Is it possible to use the references clause on a create table and have
the library list searched for the table that is referenced? For example,
in:
 
create table ServicePhone (                            
   Service char(6),                                    
   Phone char(13),                                     
   Primary key (Service),                              
   Foreign Key (Service) REFERENCES Rsvphy01 (B4BYCD)  
   )                                                   
 
I'm creating the ServicePhone table in CISLIB, but I want it to find
rsvphy01 in HISDEVGEN. I don't want to hard-code the library names since
this is the development side of the world. As it happens, in production
both ServicePhone and rsvphy01 would be in the same library.
 
-Walden
 
------------
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com
<blocked::blocked::http://www.techsoftinc.com/> 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)

 

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.