嵌入式sql.c

这个是sql嵌入到c语言中的例子 原来：EXEC SQL CONNECT TO SKY.exp USER sa.sa //连接到数据库 更改：EXEC SQL CONNECT TO 8BC1D82

/* ===== b.c =====*/


/* ===== NT doesn't need the following... */
#ifndef WIN32
#define WIN32
#endif
#define _loadds
#define _SQLPREP_
#include <sqlca.h>
#include <sqlda.h>
#include <string.h>
#define SQLLENMAX(x)      ( ((x) > 32767) ? 32767 : (x) )
short ESQLAPI _loadds sqlaaloc(
	unsigned short usSqlDaId,
	unsigned short sqld,
	unsigned short stmt_id,
	void far *spare);

short ESQLAPI _loadds sqlxcall(
	unsigned short usCallType,
	unsigned short usSection,
	unsigned short usSqldaInId,
	unsigned short usSqlDaOutId,
	unsigned short usSqlTextLen,
	char far *lpszSQLText);

short ESQLAPI _loadds sqlacall(
	unsigned short usCallType,
	unsigned short usSection,
	unsigned short usSqldaInId,
	unsigned short usSqlDaOutId,
	void far *spare);

short ESQLAPI _loadds sqladloc(
	unsigned short usSqldaInId,
	void far *spare);

short ESQLAPI _loadds sqlasets(
	unsigned short cbSqlText,
	void far *lpvSqlText,
	void far *spare);

short ESQLAPI _loadds sqlasetv(
	unsigned short usSqldaInId,
	unsigned short sqlvar_index,
	unsigned short sqltype,
	unsigned short sqllen,
	void far *sqldata,
	void far *sqlind,
	void far *spare);

short ESQLAPI _loadds sqlastop(
	void far *spare);

short ESQLAPI _loadds sqlastrt(
	void far *pid,
	void far *spare,
	void far *sqlca);

short ESQLAPI _loadds sqlausda(
	unsigned short sqldaId,
	void far *lpvSqlDa,
	void far *spare);

extern struct tag_sqlca far sql_sqlca;
extern struct tag_sqlca far *sqlca;
struct sqla_program_id2 { 
unsigned short length; 
unsigned short rp_rel_num; 
unsigned short db_rel_num; 
unsigned short bf_rel_num; 
unsigned char  sqluser[30]; 
unsigned char  sqlusername[30];
unsigned char  planname[256]; 
unsigned char  contoken[8]; 
unsigned char  buffer[8]; 
}; 
static struct sqla_program_id2 program_id = 
		{340,2,0,0,"                              ","","b","yyy0WcLu","        "};
static void far* pid = &program_id;
#line 1 "b.sqc"
#line 1 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"















#pragma once
#line 18 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"






#line 25 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"







#pragma pack(push,8)
#line 34 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"














#line 49 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"
#line 50 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"






#line 57 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"








#line 66 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"
#line 67 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"



typedef unsigned int size_t;

#line 73 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"




typedef unsigned short wchar_t;

#line 80 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"



typedef wchar_t wint_t;
typedef wchar_t wctype_t;

#line 87 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"
#line 88 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"









typedef char *  va_list;
#line 99 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"

#line 101 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"






#line 108 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"

#line 110 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"






























#line 141 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"





struct _iobuf {
        char *_ptr;
        int   _cnt;
        char *_base;
        int   _flag;
        int   _file;
        int   _charbuf;
        int   _bufsiz;
        char *_tmpfname;
        };
typedef struct _iobuf FILE;

#line 159 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"












#line 172 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"












#line 185 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"




























#line 214 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"
#line 215 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"





 extern FILE _iob[];
#line 222 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"









#line 232 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"


typedef __int64 fpos_t;







#line 243 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"
#line 244 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"


#line 247 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"




























 int __cdecl _filbuf(FILE *);
 int __cdecl _flsbuf(int, FILE *);




 FILE * __cdecl _fsopen(const char *, const char *, int);
#line 283 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"

 void __cdecl clearerr(FILE *);
 int __cdecl fclose(FILE *);
 int __cdecl _fcloseall(void);




 FILE * __cdecl _fdopen(int, const char *);
#line 293 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"

 int __cdecl feof(FILE *);
 int __cdecl ferror(FILE *);
 int __cdecl fflush(FILE *);
 int __cdecl fgetc(FILE *);
 int __cdecl _fgetchar(void);
 int __cdecl fgetpos(FILE *, fpos_t *);
 char * __cdecl fgets(char *, int, FILE *);




 int __cdecl _fileno(FILE *);
#line 307 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"

 int __cdecl _flushall(void);
 FILE * __cdecl fopen(const char *, const char *);
 int __cdecl fprintf(FILE *, const char *, ...);
 int __cdecl fputc(int, FILE *);
 int __cdecl _fputchar(int);
 int __cdecl fputs(const char *, FILE *);
 size_t __cdecl fread(void *, size_t, size_t, FILE *);
 FILE * __cdecl freopen(const char *, const char *, FILE *);
 int __cdecl fscanf(FILE *, const char *, ...);
 int __cdecl fsetpos(FILE *, const fpos_t *);
 int __cdecl fseek(FILE *, long, int);
 long __cdecl ftell(FILE *);
 size_t __cdecl fwrite(const void *, size_t, size_t, FILE *);
 int __cdecl getc(FILE *);
 int __cdecl getchar(void);
 int __cdecl _getmaxstdio(void);
 char * __cdecl gets(char *);
 int __cdecl _getw(FILE *);
 void __cdecl perror(const char *);
 int __cdecl _pclose(FILE *);
 FILE * __cdecl _popen(const char *, const char *);
 int __cdecl printf(const char *, ...);
 int __cdecl putc(int, FILE *);
 int __cdecl putchar(int);
 int __cdecl puts(const char *);
 int __cdecl _putw(int, FILE *);
 int __cdecl remove(const char *);
 int __cdecl rename(const char *, const char *);
 void __cdecl rewind(FILE *);
 int __cdecl _rmtmp(void);
 int __cdecl scanf(const char *, ...);
 void __cdecl setbuf(FILE *, char *);
 int __cdecl _setmaxstdio(int);
 int __cdecl setvbuf(FILE *, char *, int, size_t);
 int __cdecl _snprintf(char *, size_t, const char *, ...);
 int __cdecl sprintf(char *, const char *, ...);
 int __cdecl sscanf(const char *, const char *, ...);
 char * __cdecl _tempnam(const char *, const char *);
 FILE * __cdecl tmpfile(void);
 char * __cdecl tmpnam(char *);
 int __cdecl ungetc(int, FILE *);
 int __cdecl _unlink(const char *);
 int __cdecl vfprintf(FILE *, const char *, va_list);
 int __cdecl vprintf(const char *, va_list);
 int __cdecl _vsnprintf(char *, size_t, const char *, va_list);
 int __cdecl vsprintf(char *, const char *, va_list);








#line 363 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"




 FILE * __cdecl _wfsopen(const wchar_t *, const wchar_t *, int);
#line 369 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"

 wint_t __cdecl fgetwc(FILE *);
 wint_t __cdecl _fgetwchar(void);
 wint_t __cdecl fputwc(wint_t, FILE *);
 wint_t __cdecl _fputwchar(wint_t);
 wint_t __cdecl getwc(FILE *);
 wint_t __cdecl getwchar(void);
 wint_t __cdecl putwc(wint_t, FILE *);
 wint_t __cdecl putwchar(wint_t);
 wint_t __cdecl ungetwc(wint_t, FILE *);

 wchar_t * __cdecl fgetws(wchar_t *, int, FILE *);
 int __cdecl fputws(const wchar_t *, FILE *);
 wchar_t * __cdecl _getws(wchar_t *);
 int __cdecl _putws(const wchar_t *);

 int __cdecl fwprintf(FILE *, const wchar_t *, ...);
 int __cdecl wprintf(const wchar_t *, ...);
 int __cdecl _snwprintf(wchar_t *, size_t, const wchar_t *, ...);
 int __cdecl swprintf(wchar_t *, const wchar_t *, ...);
 int __cdecl vfwprintf(FILE *, const wchar_t *, va_list);
 int __cdecl vwprintf(const wchar_t *, va_list);
 int __cdecl _vsnwprintf(wchar_t *, size_t, const wchar_t *, va_list);
 int __cdecl vswprintf(wchar_t *, const wchar_t *, va_list);
 int __cdecl fwscanf(FILE *, const wchar_t *, ...);
 int __cdecl swscanf(const wchar_t *, const wchar_t *, ...);
 int __cdecl wscanf(const wchar_t *, ...);






 FILE * __cdecl _wfdopen(int, const wchar_t *);
 FILE * __cdecl _wfopen(const wchar_t *, const wchar_t *);
 FILE * __cdecl _wfreopen(const wchar_t *, const wchar_t *, FILE *);
 void __cdecl _wperror(const wchar_t *);
 FILE * __cdecl _wpopen(const wchar_t *, const wchar_t *);
 int __cdecl _wremove(const wchar_t *);
 wchar_t * __cdecl _wtempnam(const wchar_t *, const wchar_t *);
 wchar_t * __cdecl _wtmpnam(wchar_t *);



#line 414 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"
#line 415 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"


#line 418 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"
































 int __cdecl fcloseall(void);
 FILE * __cdecl fdopen(int, const char *);
 int __cdecl fgetchar(void);
 int __cdecl fileno(FILE *);
 int __cdecl flushall(void);
 int __cdecl fputchar(int);
 int __cdecl getw(FILE *);
 int __cdecl putw(int, FILE *);
 int __cdecl rmtmp(void);
 char * __cdecl tempnam(const char *, const char *);
 int __cdecl unlink(const char *);

#line 463 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"






#pragma pack(pop)
#line 471 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"

#line 473 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdio.h"
#line 2 "b.sqc"
#line 1 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdlib.h"
















#pragma once
#line 19 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdlib.h"






#line 26 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdlib.h"







#pragma pack(push,8)
#line 35 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdlib.h"






















#line 58 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdlib.h"










































typedef int (__cdecl * _onexit_t)(void);



#line 105 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdlib.h"

#line 107 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdlib.h"






typedef struct _div_t {
        int quot;
        int rem;
} div_t;

typedef struct _ldiv_t {
        long quot;
        long rem;
} ldiv_t;


#line 125 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdlib.h"












 extern int __mb_cur_max;
#line 139 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdlib.h"





















#line 161 "C:\\PROGRA~1\\MICROS~2\\VC98\\INCLUDE\\stdlib.h"