If you use Commitment Control, you need to journal the file(s) you wish to 
alter.  Else, lose the COMMIT statement and compile with Commitment Control = 

Vince Rowe
Marietta Corp

On Tuesday 25 February 2003 08:47 am, you wrote:
> Hi!
> I have started for a short time to programm with ILE C and embedded SQL.
> I want to insert/update in one table whatever I do (Update/insert) I get
> the following SQLCODE = -7008. I had a look to the SQL Classes and Codes
> and it says "The table is in an invalid state for the operation". The code
> looks something like that:
>  #include <stdio.h>
>  #include "mystuff.h"
>  int main(int argc, char* argv[])
>  {
>     int  i;
>     EXEC SQL
>          VALUES ('name', 'VALUE');
>     if (SQLCODE == 0)
>     {
>        printf("It works");
>     }
>    else
>     {
>        printf("ERROR SQLCODE=%d \n",SQLCODE);
>     }
>     EXEC SQL
>       COMMIT;
>     printf("End");
> }
> Thanks for any ideas and yout time.
> jaime

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