RE: SQL System Error -- MIDRANGE-L

Glen,

Running V5R2M0 and at cume C3364 with the latest group & hipers installed
the end of January.

TL03364 is the ptf (cume C3364)

Here is what WRKPTFGRP displays:

Opt  PTF Group             Level  Status    
      SF99519                  90  Installed 
      SF99502                  11  Installed 
      SF99169                  15  Installed 
      SF99039                   2  Installed 
                                             

Thanks - Dennis.

Dennis Munro

"I love deadlines. I especially like the whooshing sound they make as they
go flying by."
Dilbert's Words Of Wisdom

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@xxxxxxxxxxxxxxxxxxxx
(920) 361-2388   Ext.141

-----Original Message-----
From: Orsburn, Glen O [mailto:orsburn@xxxxxxxx]
Sent: Tuesday, February 17, 2004 9:17 AM
To: Midrange Systems Technical Discussion
Subject: RE: SQL System Error

Dennis,

What release and ptf do you have? 

Glen

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dennis Munro
Sent: Tuesday, February 17, 2004 9:07 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL System Error


Low & behold I still had the premiere database on my system & I ran the
statement as you have it coded & it ran just fine.  The columns names
have changed & the data has been refreshed but other than that the
statement ran as you had coded it.

Thanks - Dennis.

Dennis Munro

"I love deadlines. I especially like the whooshing sound they make as
they go flying by." Dilbert's Words Of Wisdom

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@xxxxxxxxxxxxxxxxxxxx
(920) 361-2388   Ext.141

-----Original Message-----
From: Orsburn, Glen O [mailto:orsburn@xxxxxxxx]
Sent: Tuesday, February 17, 2004 8:35 AM
To: Midrange Systems Technical Discussion
Subject: SQL System Error
ny suggests or help on this one would be appreciated:

When we run subquery interactively in SQL this is the error: (if I
should run each Select statement by it self no error occurs)

 <<Picture (Metafile)>> SELECT customer_num, customer_name
  FROM premiere/customer
WHERE customer_num in (select customer_num from premiere/orders where
                order_date = '10/20/2003')

I'm getting the following error when we run a interactive SQL statement
above:

Message ID . . . . . . :   SQL0901       Severity . . . . . . . :   50
Message type . . . . . :   Diagnostic

Message . . . . :   SQL system error.
Cause . . . . . :   An SQL system error has occurred.  The current SQL
  statement cannot be completed successfully.  The error will not
prevent
  other SQL statements from being processed. Previous messages may
indicate
  that there is a problem with the SQL statement and SQL did not
correctly
  diagnose the error. The previous message identifier was CPF4204.
Internal
  error type 3109 has occurred. If precompiling, processing will not
continue
  beyond this statement.

When I dig in a little deeper it has the following message:

System object ORDERS    ORDERS partially damaged. Internal dump ID .
Error
  class 0, device number X'0000'.
Internal failure occurred in query processor.
File QAP0ZDMP created in library QTEMP.
Member QP0Z110085 added to file QAP0ZDMP in QTEMP.
User Trace data for job 110085/GOSQL225/QPADEV000D dumped to member
  QP0Z110085 in file QAP0ZDMP in library QTEMP.
27 records copied from member QP0Z110085.
1 User Trace buffer(s) deleted.
SQL system error.


Glen
FVTC Instructor


"Give a man a fish and he'll eat for a day. Teach a man to fish and
he'll eat for a lifetime.".
_______________________________________________
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.
The information contained in this e-mail message is confidential
information intended only for the use of the individual or entity named
above. If the reader of this message is not the intended recipient, or
the employee or agent responsible to deliver it to the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this communication is strictly prohibited. If you have
received this communication in error, please immediately notify us by
telephone, and return the original message to us at the below address
via the U.S. Postal Service, and delete it from your computer.  Badger
Mining Corporation  P.O. Box 328  Berlin, WI 54923  920-361-2388
_______________________________________________
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.
The information contained in this e-mail message is confidential information
intended only for the use of the individual or entity named above. If the
reader of this message is not the intended recipient, or the employee or
agent responsible to deliver it to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please immediately notify us by telephone, and
return the original message to us at the below address via the U.S. Postal
Service, and delete it from your computer.  Badger Mining Corporation  P.O.
Box 328  Berlin, WI 54923  920-361-2388