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