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

["Jaime Lopez Ortega" <jaimosky@xxxxxx>]

Thank you for your answers.
I compiled the programm with option COMMIT(*NONE) and it 
did the job.
Jaime

-----Ursprüngliche Nachricht-----
Von: Jaime JLO. López Ortega 
Gesendet: Dienstag, 25. Februar 2003 14:47
An: c400-l@xxxxxxxxxxxx
Betreff: [C400-L] SQLCODE Error in ILE C

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

_______________________________________________
This is the C programming iSeries / AS400 (C400-L) mailing 
list
To post a message email: C400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/c400-l
or email: C400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the 
archives
at http://archive.midrange.com/c400-l.

--------------------------------------------------
Nuevo Depósito a 1 mes 6% TAE, contrátalo:
http://ingdirect.ozu.es
--------------------------------------------------
Correo enviado desde http://www.ozu.es