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


  • Subject: Re: Join & Update
  • From: Jim Langston <jlangston@xxxxxxxxxxxxxxxx>
  • Date: Mon, 18 Oct 1999 08:16:05 -0700
  • Organization: Conex Global Logistics Services, Inc.

Updateable joins would make my life *SO*  much simpler.  I have one file
on my system (thank goodness it is only one) that uses a dual format.
Unfortunately,
this is our AR file and is used in something like 1/4 of our programs.  All the
other files have been converted to DDS no problem.  But, this one is the 
problem.

For this one we are still internally describing it, our only other option is to
break it
into two files then go through every single program and change them to use one,
the other, or both files.  Something we just haven't had the time to invest 
into.

An Updateable join would work perfectly, and we wouldn't have to do this.
We could just break it up into two files (which we already have created, by the
way, but can't really use) and then do an Updateable join logical on them, and
all our
programs would still work as written, and then we could change the programs to
use externally described files.

This limitation, to me, has always been the one major drawback to logical joins,
and is the only reason we would want to use one anyway.

Anomalies, smomalies, as long as it works <g>

Regards,

Jim Langston

"R. Bruce Hoffman, Jr." wrote:

> Not a dumb question, but a join operation is not updatable, period. This has
> always been a "future objective" of database, but don't hold your breath.
>
> The reason to design to third normal form is to prevent update anomolies.
> The reason to use joins is to put the data in 2nd normal form for usage.
> Thus, the join form re-introduces update anomolies to the process, hence, no
> update.
>
> -----Original Message-----
> From: Sethuraman <sethu@bc.sympatico.ca>
> To: RPG400-L@midrange.com <RPG400-L@midrange.com>
> Date: Monday, October 18, 1999 2:09 AM
> Subject: Join & Update
>
> >Hi Folks:
> >
> >A join logical file cannot be used for Update.
> >
> >What about SQL?  If a view (with joins) is created using SQL, can this view
> be
> >declared
> >as an "Update"? Or is this a dumb question?
> >
>
> ===========================================================
> R. Bruce Hoffman, Jr.
>  -- IBM Certified AS/400 Professional System Administrator
>  -- IBM Certified AS/400 Professional Network Administrator
>
> "The sum of all human knowledge is a fixed constant.
>     It's the population that keeps growing!"
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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.