RE: Specified data space entry 552601 rejected?????

>Are there multiple statements in the RUNSQLSTM source file?

Yup. 

>Can you bust it up by statement?

I could. But why. One of the things I love is the ability to group
related statements into a single source member, almost like a program.
<G>

>Do you have ... Set on.

Not usually. And I didn't on this run.

Actually the messages were removed by the system automatically so it
might be a "normal" part of processing, I just happened to catch a bunch
of them. There are some EVIs over these tables, perhaps it's part of the
bitmap update?

Since everything appears to have completed successfully, and the
messages were removed automatically I'm not too worried about it. But I
hate seeing messages like that that don't have an explanation.

-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, February 28, 2006 3:58 PM
To: Midrange Systems Technical Discussion
Subject: Re: Specified data space entry 552601 rejected?????

Are there multiple statements in the RUNSQLSTM source file?  Can you
bust it up by statement?

Do you have
CHGJOB LOG(4 00 *SECLVL) LOGCLPGM(*YES)
and
STRDBG UPDPROD(*YES)
set on?

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
02/28/2006 03:49 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


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

Fax to

Subject
Specified data space entry 552601 rejected?????






Just saw this is a joblog of a job running some sql statements. Anyone
have any ideas? The sql "appeared" to complete successfully.
 
Message ID . . . . . . :   MCH1848

Date sent  . . . . . . :   02/28/06      Time sent  . . . . . . :
15:29:29
 

Message . . . . :   Specified data space entry 552601 rejected.

 

Cause . . . . . :   You tried to position a cursor to a specific data
space 
  entry, but the retrieval selection criteria rejected the entry.

 
>From program . . . . . . . . . :   DbDsCursor
  Instruction  . . . . . . . . :     00160C 
 
To program . . . . . . . . . . :   QDBGETSQ 
  To library . . . . . . . . . :     QSYS 
  Instruction  . . . . . . . . :     06B2 
 
 
The results of the RUNSQLSTM file:

SQL7956   0       1  Position 1 2276 rows inserted in VISIT in HISPRDDF.

SQL0088   0      12  Position 1 UPDATE applies to entire table.

SQL7957   0      10  Position 1 602415 rows updated in VISIT in
HISPRDDF. 
SQL7957   0      15  Position 1 68 rows updated in VISIT in HISPRDDF.

SQL7957   0      26  Position 1 95714 rows updated in VISIT in HISPRDDF.

                                               Message Summary

Total    Info    Warning    Error    Severe    Terminal

    5      5         0         0         0          0

00 level severity errors found in source


Ideas?

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