Table Alias'ing

[Peter Bateman]

        Hi John:
 
         I don't see a reason for a second attach.
             
         Your PRIMARY and DESIGNER should be able to share the same attach.
 
         The underlining SQL should be able to handle a second OPEN CURSOR within
         a FETCH NEXT loop.
 
         Regards,
         Peter
         


Date: Thu, 12 Jun 2008 08:33:07 -0700From: resolutebay at yahoo.comSubject: Table Alias'ingTo: powerh-l at lists.sowder.com
Greetings Listers:
 
I am under the impression/assumption that under the following conditions a second attach is made to the database: Powerhouse 7.10e DEC SQL V6.1-13:
 
Example #1:
 
FILE OBLIGATION ALIAS OB
 
I assert that it's (almost) the same as:
 
Example #2:
 
FILE OBLIGATION DESIGNER
 
FILE OBLIGATION designer alias obl
 
where you must have two separate attaches.
 
Can anyone please clear up any misapprehension? A colleague here says that the first is only a 'pointer' (his term) situation and no second attach happens.
 
TIA
 
JP

_________________________________________________________________
Find hidden words, unscramble celebrity names, or try the ultimate crossword puzzle with Live Search Games. Play now!
http://g.msn.ca/ca55/212
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20080616/b031c141/attachment.html