void main(int argc,char **argv)
{              int          iRet;
               long          pid;
          int          pidNum,pidMax;
for(pidNum=0;pidNum＜pidMax;pidNum++)
        {
                pid=fork();
                if(pid==0)
                {
                        iRet=DealData();
                        exit(0);
                }
                else if(pid>0)
                {
                        continue;
                }
                else
                {
                        printf("\n************************************\n\n");
                        printf("[%s] %ssetup failed:create instance failed[%d][%s].\n",ShowTimer(),PRO_NAME,errno,strerror(errno));                        
                        printf("\n************************************\n\n");
                        break;
                }
        }  
          if((pidNum==pidMax)&&(pid>0))
          {
                  printf("[%s] %ssetup success\n",ShowTimer(),PRO_NAME);
          }else{
                  printf("[%s] %ssetup failed\n",ShowTimer(),PRO_NAME);
          }
}

int DealData()
{
        if((ret=ConnectDatabase())!=0)
        {
            wrtlog("connect db failed\n");
            printf("\n************************************\n\n");
                printf("[%s] %sconnect db failed[%d].\n",ShowTimer(),PRO_NAME,ret);                        
                printf("\n************************************\n\n");
                     logoff();        
            return -1;
        }
        wrttmpdb();
}
int ConnectDatabase( )
{
        EXEC SQL CONNECT :username IDENTIFIED BY :password;
        if ( sqlca.sqlcode )
                printf( "Connect DataBase Fault %ld \n", sqlca.sqlcode );
        return sqlca.sqlcode;
}
int wrttmpdb()
{
EXEC SQL SELECT KEY_SEQ.NEXTVAL INTO :key_seq
                FROM DUAL;
        if(SQLCODE!=0)
                WRTLOGDB,"select key_seq.nextval fail.\n");

}