
if test "$1" = "-convert"; then
    cp datanew.sql .. 
    cd .. 
    rm -rf actnew.dbs
    fxsql datanew
    FXDATA=`pwd`/actnew.dbs; export FXDATA
    cd bin
else
    cp database.sql .. 
    cd .. 
    rm -rf act.dbs
    fxsql database
    cd bin
fi

# use fxsql2 and run the following statements if grant does not work
# delete from sysusers where username = "public";
# insert into sysusers (username,usertype,priority) values("public", "D", "5");
# OR   fxsql2 grant2 
    fxsql grant 
    fxsql menu 
    fxsql menu2
    fxsql web 
    fxsql email
    fxsql sysfile
    fxsql psmctl  
    fxsql ccmctl 
    fxsql bmmctl 
    fxsql sysform
    fxsql que 
    fxsql tbmzip
    fxsql tbmstate
    fxsql tbmcntry
    fxsql tbmprd
    fxsql tbdprd
    fxsql tbmdiv
    fxsql tbmwhs
    fxsql tbmjob
    fxsql tbdjob
    fxsql tbmcard
    fxsql tbmrept
    fxsql tbdrept
    fxsql tbmpost
    fxsql glbinv
    fxsql glminv
    fxsql gldinv
    fxsql glmrec
    fxsql gldrec
    fxsql glmcoa
    fxsql gldcoa
    fxsql glpcoa
    fxsql glmcat
    fxsql glmsub
    fxsql glmform
    fxsql glbrpt
    fxsql gltemp
    fxsql glmreg
    fxsql glmact


    fxsql inmven      
    fxsql inwven
    fxsql insven
    fxsql innven      
    fxsql incven      
    fxsql inuven      
    fxsql inbadj
    fxsql indadj
    fxsql insadj
    fxsql inbtfr
    fxsql indtfr
    fxsql instfr
    fxsql inbphy
    fxsql indphy
    fxsql insphy
    fxsql inwhis
    fxsql inshis
    fxsql inmunit
    fxsql inmcat
    fxsql inmgrp
    fxsql inmgl
    fxsql inmprc
    fxsql indprc
    fxsql incprc
    fxsql iniprc
    fxsql inddiv

    fxsql bmmbom
    fxsql bmdbom
    fxsql bmobom
    fxsql bmnbom
    fxsql bmmord
    fxsql bmdord
    fxsql bmsord
    fxsql bmcord
    fxsql bmnord
    fxsql bmminv
    fxsql bmdinv
    fxsql bmsinv
    fxsql bmcinv
    fxsql bmninv
    fxsql bmmest
    fxsql bmdest

    fxsql slmrec    
    fxsql sldrec  
    fxsql slcrec
    fxsql slnrec  
    fxsql slmord     
    fxsql sldord    
    fxsql slsord
    fxsql slcord
    fxsql slnord   
    fxsql slminv     
    fxsql sldinv    
    fxsql slsinv
    fxsql slcinv
    fxsql slninv   
    fxsql slminc     
    fxsql sldinc    
    fxsql slcinc    
    fxsql slninc  
    fxsql slmtax     
    fxsql sldtax     
    fxsql slmterm     
    fxsql slmcary     
    fxsql slmsale     
    fxsql slmship    
    fxsql slddiv
    fxsql slgregn
    fxsql slmregn
    fxsql sldregn
    fxsql slxregn
    fxsql extps.sql

    fxsql armcus
    fxsql arpcus
    fxsql arscus
    fxsql arncus
    fxsql arfcus
    fxsql arccus
    fxsql armlist
    fxsql arbopen
    fxsql armopen
    fxsql ardopen
    fxsql arbinv
    fxsql arminv
    fxsql ardinv
    fxsql arbadj
    fxsql armadj
    fxsql ardadj
    fxsql arbchk
    fxsql armchk
    fxsql artchk
    fxsql ardchk
    fxsql armrec
    fxsql ardrec
    fxsql arstmnt
    fxsql archeck
    fxsql armreg
    fxsql ardreg
    fxsql armsrc
    fxsql arddiv
    fxsql argcom

    fxsql cfmap
    fxsql cfmar

    fxsql pomrec
    fxsql podrec
    fxsql ponrec
    fxsql pomord
    fxsql podord
    fxsql posord
    fxsql pojord
    fxsql ponord
    fxsql pomrcv
    fxsql podrcv
    fxsql pojrcv
    fxsql posrcv
    fxsql pominv
    fxsql podinv
    fxsql pojinv
    fxsql pomterm    
    fxsql pomship    
    fxsql pombuy     
    fxsql poddiv

    fxsql apmven
    fxsql apsven
    fxsql apnven
    fxsql apfven
    fxsql apbopen
    fxsql apmopen
    fxsql apdopen
    fxsql apbinv
    fxsql apminv
    fxsql apdinv
    fxsql apbadj
    fxsql apmadj
    fxsql apdadj
    fxsql apbchk
    fxsql apmchk
    fxsql aptchk
    fxsql apdchk
    fxsql apmrec
    fxsql apdrec
    fxsql apstmnt
    fxsql apcheck
    fxsql apmreg
    fxsql apcreg
    fxsql apdreg
    fxsql apddiv
    fxsql apm1099
    fxsql apm1096

fxsql ptbtime
fxsql ptmtime
fxsql ptdtime

fxsql pymdiv
fxsql pymsub
fxsql pymgl
fxsql pymtax
fxsql pympto
fxsql pyttax
fxsql pyfe94
fxsql pyfe06
#fxsql pyst94ca
fxsql pyst06ca
#fxsql pyst98wa
#fxsql pyst06wa
fxsql pymded  
fxsql pymearn 
fxsql pymtype
fxsql pymgrp
fxsql pymemp    
fxsql pyiemp    
fxsql pycemp    
fxsql py4emp    
fxsql pyaemp    
fxsql pyanemp    
fxsql pyeemp    
fxsql pydemp    
fxsql pyyemp    
fxsql pynemp    
fxsql pyiemp    
fxsql pybchk
fxsql pymchk
fxsql pytchk
fxsql pymw2
fxsql pymw3
fxsql pymhis
fxsql pydhis
fxsql pythis
fxsql pymreg
fxsql glmcoa
fxsql pydata

fxsql jcbmtl
fxsql jcdmtl
fxsql jcsmtl
fxsql jcblbr
fxsql jcdlbr
fxsql jcddiv

fxsql brminv
fxsql brdinv
fxsql brmreg

# fi

