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



This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].