Would the fact that the file that I am inserting to is not being journaled
be an issue.

Thanks,

Dave Bednarcik
Email: DaveBednarcik@WesternUnion.com
Work #: (201)263-5186
Fax # : (201)263-5455



                      rob@dekko.com
                      Sent by:                 To:       domino400@midrange.com
                      domino400-admin@m        cc:
                      idrange.com              Fax to:
                                               Subject:  Re: Script Error

                      04/17/2002 09:48
                      AM
                      Please respond to
                      domino400






This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I did a DSPMSGD RANGE(SQL7008) MSGF(QSQLMSG).  There are numerous things
that could be causing that message.  Look at this message carefully and
investigate all of the possibilities.  You might have to look at the job
log of the server job processing the script to see exactly which error is
occurring.  I am doubting that it is the journal option - code 3.  Because
you are doing an insert and nothing that would cause the described RI
constraints to kick in.  Those would normally kick in during a delete.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




DaveBednarcik@westernunion.com
Sent by: domino400-admin@midrange.com
04/17/2002 08:24 AM
Please respond to domino400


        To:     domino400@midrange.com
        cc:
        Fax to:
        Subject:        Script Error


I am seeing this error message when I am trying to insert a record on  DB2
file via Lotus Script:

04/17/2002 09:08:52 AM  Addin: Agent 'Create Stat' error message: Error:
See SQL7008 for invalid state possibilities.  This error is most common
when the table is not journaled and no indication


Does anyone know how I can indiacte that the file is not Journaled in
Lotus
Script.

THanks,

Dave Bednarcik
Email: DaveBednarcik@WesternUnion.com
Work #: (201)263-5186
Fax # : (201)263-5455

_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list
To post a message email: DOMINO400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/domino400
or email: DOMINO400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.



_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list
To post a message email: DOMINO400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/domino400
or email: DOMINO400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.







As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.