How to disconnect from database in batchmode?

[Arunselvan]

Hi All,

I have created on script to connect to database in batch mode and to execute some programs. It is connecting to database successfully. but it is not disconnecting.

Please Help be with this. Is there any command to disconnect mpro session in batch mode? Please let me know asap

d=`date +"%m%d%Y"`
echo "Cron starts `date`" >> $LOGFILE

#Starting adr307

mpro -pf /home/us053999/run.pf -b -p $CRONDIR/adr307.p >> $LOGFILE

sh adr307.rc >> $LOGFILE

echo "Cron ends `date`" >> $LOGFILE

 

[TomBascom]

From the 4gl coding perspective you are looking for the QUIT command.

 

[Arunselvan]

From the 4gl coding perspective you are looking for the QUIT command.

Where I have to use that QUIT command?

 

[TomBascom]

Whenever your .p is ready to disconnect from the db and return control to the OS.