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

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 mailing list archive is Copyright 1997-2024 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.