/******************************************************************************
**
** Source File Name = cursor.sqc  1.6
**
** Licensed Materials - Property of IBM
**
** (C) COPYRIGHT International Business Machines Corp. 1995, 1999 
** All Rights Reserved.
**
** US Government Users Restricted Rights - Use, duplication or
** disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
**
**
** PURPOSE: This sample program demonstrates the use of a CURSOR.
**          The CURSOR is processed using static SQL.  This program
**          obtains all managers in the STAFF table of the
**          SAMPLE database and change their job from "Mgr" to
**          "Clerk".  A ROLLBACK is done so that the SAMPLE
**          database remains unchanged.
**
** An external function "check_error" is contained in the file "util.c"
** which must be compiled along with this file.  
**
** EXTERNAL DEPENDENCIES :
**       - Ensure existence of database for precompile purposes.
**       - Precompile with the SQL precompiler (PREP in DB2)
**       - Bind to a database (BIND in DB2)
**       - Compile and link with the IBM Cset++ compiler (AIX and OS/2)
**         or the Microsoft Visual C++ compiler (Windows) 
**         or the compiler supported on your platform.
**
** For more information about these samples see the README file.
**
** For more information on programming in C, see the:
**   -  "Programming in C and C++" section of the Application Development Guide
** For more information on building C applications, see the:
**   -  "Building C Applications" section of the Application Building Guide.
**
** For more information on the SQL language see the SQL Reference.
**
*******************************************************************************/

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include "util.h"

#ifdef DB268K
/* Need to include ASLM for 68K applications */
#include <LibraryManager.h>
#endif

EXEC SQL INCLUDE SQLCA;

#define  CHECKERR(CE_STR)   if (check_error (CE_STR, &sqlca) != 0) return 1;

int main(int argc, char *argv[]) {

   EXEC SQL BEGIN DECLARE SECTION;
      char   job[20];
      char   desc[20];
      short  eid;
      char userid[9];
      char passwd[19];
   EXEC SQL END DECLARE SECTION;

#ifdef DB268K
   /* Before making any API calls for 68K environment,
      need to initial the Library Manager */
	InitLibraryManager(0,kCurrentZone,kNormalMemory);
	atexit(CleanupLibraryManager);
#endif

   printf( "Sample C program: CURSORUPDT \n" );

   if (argc == 1) {
      EXEC SQL CONNECT TO cscd34;
	  CHECKERR ("CONNECT TO CSCD34");
   }
   else if (argc == 3) { 
      strcpy (userid, argv[1]);
      strcpy (passwd, argv[2]);
      EXEC SQL CONNECT TO cscd34 USER :userid USING :passwd;
      CHECKERR ("CONNECT TO CSCD34");
   }
   else {
      printf ("\nUSAGE: cursor [userid passwd]\n\n");
      return 1;
   } /* endif */
   
   EXEC SQL DECLARE c1 CURSOR FOR  /* :rk.1:erk. */
            SELECT eid, description FROM estaf WHERE job='Mgr'
            FOR UPDATE OF job;

   EXEC SQL OPEN c1;  /* :rk.2:erk. */
   CHECKERR ("OPEN CURSOR");

   do {
      EXEC SQL FETCH c1 INTO :eid, :desc;  /* :rk.3:erk. */
      if (SQLCODE != 0) break;

      printf( "%d, whose function is  %s,  will be demoted to Clerk\n",
         eid, desc );
   } while ( 1 );

   EXEC SQL CLOSE c1;  /* :rk.4:erk. */
   CHECKERR ("CLOSE CURSOR");

   EXEC SQL ROLLBACK;
   CHECKERR ("ROLLBACK");
   printf( "\nOn second thought -- changes rolled back.\n" );

   EXEC SQL CONNECT RESET;
   CHECKERR ("CONNECT RESET");
   return 0;
}
/* end of program : CURSOR.SQC */