RE: References Clause on create table and library list

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

>How the (heck) hard would that have been to test and find out for
yourself?

Rob, come on, don't you think I did try it.

>*SYS naming convention would work.

Sys does indeed work. I had tried it, but I'd also specified the default
collection parameter, assuming that it would use that library as the
library to create the objects in. However, if you specify the default
collection it overrides the naming parameter and uses *SYS no matter
what. Once you said it does work I went back and tried to figure out why
mine wasn't working.

-Walden

------------
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

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


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, January 24, 2006 1:33 PM
To: Midrange Systems Technical Discussion
Subject: Re: References Clause on create table and library list

My first question was going to be "How the (heck) hard would that have
been to test and find out for yourself?"  Then some obscure thought came
to mind.

-- it depends --

*SQL naming convention would not work, unless the referenced object is
in your CURRENT library.
*SYS naming convention would work.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
01/24/2006 12:24 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
References Clause on create table and library list






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