RE: Odp: QUERY broken (V5R1)

["Ritsema, Doug B" <Doug.Ritsema@xxxxxxxxx>]

I'll try the RCLSTG after 5pm.  

What is odd is that I have found one or two queries that run fine.  In one
case I have a query that selects records (this works) and a second query
that is a duplicate except that it summarizes the records (this doesn't
work).  I've tried creating a new/scratch query and played with
summarization/breaks but note of them worked.

Doug

-----Original Message-----
From: Al Barsa [mailto:barsa@xxxxxxxxxxxxxxxxxxx]
Sent: Monday, August 25, 2003 10:45 AM
To: Midrange Systems Technical Discussion
Subject: Re: Odp: QUERY broken (V5R1)

Hi,

I had a reaction when I read the first post on this, but decided to stifle
it.

My suspicion is that you have some sort of subtle database damage.  I would
ask when your last RCLSTG occurred, and might likely suggest that you try
that if it hadn't been a long time.

I have always been a proponent of doing a RCLSTG after any abnormal
termination of the operating system.  When I said that publically on this
forum, I took grief from IBM.  After 8/14's blackout, as I have seen
database damage, RCLSTG seems to always to the right thing.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com



                                                                           
             "Bociek"                                                      
             <rlazarz@xxxxxxxx                                             
             net.pl>                                                    To 
             Sent by:                  "Midrange Systems Technical         
             midrange-l-bounce         Discussion"                         
             s@xxxxxxxxxxxx            <midrange-l@xxxxxxxxxxxx>           
                                                                        cc 
                                                                           
             08/25/2003 10:01                                      Subject 
             AM                        Odp: QUERY broken (V5R1)            
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@xxxxx                                             
                 nge.com>                                                  
                                                                           
                                                                           




I have a V5R1 in my box with the last CUM, HIPER  and DB PTF and all works
good. Maybe that is the problem of software. The status in LICPGM is ok ???

Robert
----- Original Message -----
From: Ritsema, Doug B <Doug.Ritsema@xxxxxxxxx>
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxx>
Sent: Monday, August 25, 2003 3:31 PM
Subject: QUERY broken (V5R1)


> I just applied the latest CUM and Hipers for V5R1.  Now Query is giving
me:
>
> MCH3402    Escape                  40    08/24/03   23:14:40   #aicallm
> 000258   QQURE        QSYS         00C1
> Message . . . . :   Tried to refer to all or part of an object that no
> longer exists.
>
> If I go into the query I can display but when I run the query interactive
or
> in batch I get the error.  Any ideas as to what is missing/ no longer
exist?
> I don't see any PTF's that where for Query.
>
> TIA
>
> Doug Ritsema
> Holland American Wafer Co.
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.