install.ec

UNIX下INFORMIX的安装—删除程序例子

/*----------------------------------------------------*
 * WRITE FOR ZHENZHOU ICBC GOLD_CARD UTILITY          *
 * TO INSTALL TWO TABLE: GOLDUTIL & GOLDDESC          *
 * ON 1999/06/18                                      *
 * UPDATE                                             *
 * BY SUN YIMIN                                       *
 *----------------------------------------------------*/
             
#include	<stdio.h>

EXEC SQL include  sqlca; 
EXEC SQL include  sqlda;
EXEC SQL include  sqltypes;

#define LOG "./bin/aaa";
void main(void)
{
   int i;
   EXEC SQL BEGIN DECLARE SECTION;
	char passwd[31];
        int  lastid;
   EXEC SQL END DECLARE SECTION;



   printf("开始安装数据库<hbzhcom>,请稍侯. . .");
   EXEC SQL create database hbzhcom WITH LOG;
   if (sqlca.sqlcode) {
     printf("Create database <hbzhcom> failure.(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table merchant( 
     merchno   char(12),
     termno    char(15),
     mackey    char(16),
     pinkey    char(16));
   if (sqlca.sqlcode) {
     printf("\nCreate table <merchant> failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create UNIQUE index uidx_merch ON merchant (termno);
   if (sqlca.sqlcode) {
     printf("\nCreate merchant Index failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }
   
   EXEC SQL create table jflmerchant( 
     merchno   char(12),
     termno    char(15),
     mackey    char(16),
     pinkey    char(16));
   
   if (sqlca.sqlcode) {
     printf("\nCreate table <jflmerchant> failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create UNIQUE index uidx_jflmerch ON jflmerchant (termno);
   if (sqlca.sqlcode) {
     printf("\nCreate jflmerchant Index failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table merchno( 
     merchno   char(12));
   if (sqlca.sqlcode) {
     printf("\nCreate table <merchno> failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table jflmerchno( 
     merchno   char(12));
   if (sqlca.sqlcode) {
     printf("\nCreate table <jflmerchno> failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table terminal(
	merchno		char(12),
	termno		char(15),
	traceno		char(6),
	pinkey		char(16),
	mackey		char(16),
	signflag	char(1));
   if (sqlca.sqlcode) {
     printf("\nCreate table <terminal> failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create UNIQUE index uidx_term ON terminal (termno);
   if (sqlca.sqlcode) {
     printf("\nCreate terminal index failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table jflterminal(
	merchno		char(12),
	termno		char(15),
	traceno		char(6),
	pinkey		char(16),
	mackey		char(16),
	signflag	char(1));
   if (sqlca.sqlcode) {
     printf("\nCreate table <jflterminal> failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create UNIQUE index uidx_jflterm ON jflterminal (termno);
   if (sqlca.sqlcode) {
     printf("\nCreate jflterminal index failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table trans (
        dataid          integer,
	transcode	integer,
	trans_id	integer,
	msgid		char(4),
	proccode	char(6),
	amount		integer,
	sharetraceno	char(6),
	icbctraceno	char(6),
	oldtransdate	char(8),
	transdate	char(8),
	transtime	char(6),
	cardno		char(20),
        trk2len         integer,
        trk2            char(39),
        trk3len         integer,
        trk3            char(109),
        pin             char(8),
	referno		char(12),
	oldreferno	char(12),
	authno		char(6),
	oldauthno	char(6),
	retcode		char(2),
	merchno		char(12),
	oldtermno	char(15),
	termno		char(15),
	status		integer,
        reversalflag    integer,
        old_sign_flag   char(1),
	fill		char(30));
   if (sqlca.sqlcode) {
     printf("\nCreate table trans failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create UNIQUE index idx_trans ON trans (termno, sharetraceno);
   if (sqlca.sqlcode) {
     printf("\nCreate trans index failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }
	
   EXEC SQL create table htrans (
        dataid          integer,
	transcode	integer,
	trans_id	integer,
	msgid		char(4),
	proccode	char(6),
	amount		integer,
	sharetraceno	char(6),
	icbctraceno	char(6),
	oldtransdate	char(8),
	transdate	char(8),
	transtime	char(6),
	cardno		char(20),
        trk2len         integer,
        trk2            char(39),
        trk3len         integer,
        trk3            char(109),
        pin             char(8),
	referno		char(12),
	oldreferno	char(12),
	authno		char(6),
	oldauthno	char(6),
	retcode		char(2),
	merchno		char(12),
	oldtermno	char(15),
	termno		char(15),
	status		integer,
        reversalflag    integer,
        old_sign_flag   char(1),
	fill		char(30));
   if (sqlca.sqlcode) {
     printf("\nCreate table htrans failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table revtrans (
        dataid          integer,
	transcode	integer,
	trans_id	integer,
	msgid		char(4),
	proccode	char(6),
	amount		integer,
	sharetraceno	char(6),
	icbctraceno	char(6),
	oldtransdate	char(8),
	transdate	char(8),
	transtime	char(6),
	cardno		char(20),
        trk2len         integer,
        trk2            char(39),
        trk3len         integer,
        trk3            char(109),
        pin             char(8),
	referno		char(12),
	oldreferno	char(12),
	authno		char(6),
	oldauthno	char(6),
	retcode		char(2),
	merchno		char(12),
	oldtermno	char(15),
	termno		char(15),
	status		integer,
        reversalflag    integer, 
        old_sign_flag   char(1),
	fill		char(30));
   if (sqlca.sqlcode) {
     printf("\nCreate table trans failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create UNIQUE index idx_revtrans ON revtrans (termno, sharetraceno);
   if (sqlca.sqlcode) {
     printf("\nCreate revtrans index failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table hrevtrans (
        dataid          integer,
	transcode	integer,
	trans_id	integer,
	msgid		char(4),
	proccode	char(6),
	amount		integer,
	sharetraceno	char(6),
	icbctraceno	char(6),
	oldtransdate	char(8),
	transdate	char(8),
	transtime	char(6),
	cardno		char(20),
        trk2len         integer,
        trk2            char(39),
        trk3len         integer,
        trk3            char(109),
        pin             char(8),
	referno		char(12),
	oldreferno	char(12),
	authno		char(6),
	oldauthno	char(6),
	retcode		char(2),
	merchno		char(12),
	oldtermno	char(15),
	termno		char(15),
	status		integer,
        reversalflag    integer, 
        old_sign_flag   char(1),
	fill		char(30));
   if (sqlca.sqlcode) {
     printf("\nCreate table trans failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table jfltrans (
        dataid          integer,
	transcode	integer,
	trans_id	integer,
	msgid		char(4),
	proccode	char(6),
	amount		integer,
	jfltraceno	char(6),
	icbctraceno	char(6),
        dxtraceno       char(10),
        countno         char(20),
        sfno            char(10),
        phoneno         char(20),
	transdate	char(8),
	transtime	char(6),
	cardno		char(20),
        trk2len         integer,
        trk2            char(39),
        trk3len         integer,
        trk3            char(109),
        pin             char(8),
	retcode		char(3),
	merchno		char(12),
	termno		char(15),
	status		integer,
        flag            integer,
        reversalflag    integer,
        old_sign_flag   char(1),
	fill		char(30));
   if (sqlca.sqlcode) {
     printf("\nCreate table jfltrans failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create UNIQUE index uidx_jfltrans ON jfltrans (termno, jfltraceno);
   if (sqlca.sqlcode) {
     printf("\nCreate jfltrans index failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);