install.ec

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

   }

   EXEC SQL create table jflhtrans (
        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 jflhtrans failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }


   EXEC SQL create table rjfltrans (
        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 rjfltrans failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

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

   EXEC SQL create table rjflhtrans (
        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,
        reversalflag    char(1),
        flag            char(1),
        old_sign_flag   char(1),
	fill		char(30));
   if (sqlca.sqlcode) {
     printf("\nCreate table rjflhtrans failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table dxtrans (
        dataid          integer,
	transcode	integer,
	proccode	char(3),
	jfltraceno	char(6),
	termno		char(15),
	dxoldtraceno	char(10),
	dxtraceno	char(10),
	transdate	char(8),
	transtime	char(6),
	cardno		char(20),
        phoneno         char(20),
        countno         char(20),
        usrname         char(60),
        realamount      integer,
        totalamount     integer,
        totalznj        integer,
        sfno            char(10),
        startdate       char(6),
        enddate         char(6),
        monthnum        integer,
	retcode		char(3),
	status		integer,
        reversalflag    integer,
        mode            integer,
	fill		char(30));
   if (sqlca.sqlcode) {
     printf("\nCreate table dxtrans failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table dxhtrans (
        dataid          integer,
	transcode	integer,
	proccode	char(3),
	jfltraceno	char(6),
	termno		char(15),
	dxoldtraceno	char(10),
	dxtraceno	char(10),
	transdate	char(8),
	transtime	char(6),
	cardno		char(20),
        phoneno         char(20),
        countno         char(20),
        usrname         char(60),
        realamount      integer,
        totalamount     integer,
        totalznj        integer,
        sfno            char(10),
        startdate       char(6),
        enddate         char(6),
        monthnum        integer,
	retcode		char(3),
	status		integer,
        reversalflag    integer,
        mode            integer,
	fill		char(30));
   if (sqlca.sqlcode) {
     printf("\nCreate table dxhtrans failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table dxrevtrans (
        dataid          integer,
	transcode	integer,
	proccode	char(3),
	jfltraceno	char(6),
	termno		char(15),
	dxoldtraceno	char(10),
	dxtraceno	char(10),
	transdate	char(8),
	transtime	char(6),
	cardno		char(20),
        phoneno         char(20),
        countno         char(20),
        usrname         char(60),
        realamount      integer,
        totalamount     integer,
        totalznj        integer,
        sfno            char(10),
        startdate       char(6),
        enddate         char(6),
        monthnum        integer,
	retcode		char(3),
	status		integer,
        reversalflag    integer,
        mode            integer,
	fill		char(30));

   if (sqlca.sqlcode) {
     printf("\nCreate table dxrevtrans failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table dxhrevtrans (
        dataid          integer,
	transcode	integer,
	proccode	char(3),
	jfltraceno	char(6),
	termno		char(15),
	dxoldtraceno	char(10),
	dxtraceno	char(10),
	transdate	char(8),
	transtime	char(6),
	cardno		char(20),
        phoneno         char(20),
        countno         char(20),
        usrname         char(60),
        realamount      integer,
        totalamount     integer,
        totalznj        integer,
        sfno            char(10),
        startdate       char(6),
        enddate         char(6),
        monthnum        integer,
	retcode		char(3),
	status		integer,
        reversalflag    integer,
        mode            integer,
	fill		char(30));
   if (sqlca.sqlcode) {
     printf("\nCreate table dxhrevtrans failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table usr (
 	usrname		varchar(31),
	passwd		varchar(31));
   if (sqlca.sqlcode) {
     printf("\nCreate table usr failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table id (
        lastid	integer);
   if (sqlca.sqlcode) {
     printf("\nCreate table usr failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }
   
   lastid = 0; 
   EXEC SQL insert into id values (:lastid);
   if (sqlca.sqlcode) {
     printf("\nInsert into usr failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

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

   strcpy(passwd, "000000");
   for (i = 0; i < 6; i++)
     passwd[i] += 0x80;
   EXEC SQL insert into usr values ('super', :passwd);
   if (sqlca.sqlcode) {
     printf("\nInsert into usr failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }
  
   EXEC SQL create table oper (
	usrname		varchar(31),
	action		varchar(21),
	date		char(10),
	time		char(8));
   if (sqlca.sqlcode) {
     printf("\nCreat table oper error, errcode = %d!\n", sqlca.sqlcode);
     exit(-1);
   }

   EXEC SQL create table ybpos (
 	cardno		char(20),
	pin	        char(8));
   if (sqlca.sqlcode) {
     printf("\nCreate table ybpos failure(errcode:%d)\n", sqlca.sqlcode);
     exit(-1);
   }

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

   printf("数据库安装完毕 !!!\n");
/*
   EXEC SQL 	grant dba to "root";
   EXEC SQL     grant dba to "yzgold"; 
*/
}