Re: [C400-L] SQLCODE Error in ILE C

[Vince Rowe <vrowe@xxxxxxxxxxxxxxxx>]

Jaime,

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 = 
*NONE.

Vince Rowe
MIS
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 INCLUDE SQLCA;
>
>     EXEC SQL
>       INSERT INTO MARIS/PCS001PF
>          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