× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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

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.