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: firstname.lastname@example.org 04/17/2002 08:24 AM Please respond to domino400 To: email@example.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: DOMINO400firstname.lastname@example.org Before posting, please take a moment to review the archives at http://archive.midrange.com/domino400.