Compile a procedure via command line and not inside Procedure Editor

[Kopperton]

Dear all,

I need to run 5 lines procedure via cron, before I run an application also via cron.
I use Sx.enterprise and sxee for procedure editor

How to do it via command and not inside Procedure editor window?

thank you

 

[Kopperton]

I am tring to run a 5 line procedure, my.p content of which runs fine from inside procedure editor via shell script to run under cron. I need to run this procedure 2twice a day 2 minutes before another program.p kicks in.

DLC=/dlc;
export DLC
PROPATH=/rd/lib/nxt.pl:/rd/exec::/rd/cust:/rd/src:$DLC/;
export PROPATH
PATH=$DLC/bin:/rd/bin:$PATH;
export PATH
PROTERMCAP=/rd/opsys/rdtermcap;
export PROTERMCAP
PROMSGS=/dlc/promsgs
export PROMSGS
$DLC/bin/pro -p /rd/bin/my.p -U progressadmin -P mypass

I get compilation error as

Unknown or ambiguous table pv_user. (725)
** /rd/bin/my.p Could not understand line 1. (196)

Here is the problem, the procedure my.p runs fine when run from inside procedure editor, via command line or cron gives me these errors,

what am I missing?
Thank you all

 

[Kopperton]

even mpro when database is multiuser mode which is one I must use gives me this error also/ please help, am I starting it wrong?

 

[TomBascom]

Yes. You're starting it wrong. You need to specify the database name. Where you have:

$DLC/bin/pro -p /rd/bin/my.p -U progressadmin -P mypass

You need to have something more like:

$DLC/bin/pro /db/nxt -p /rd/bin/my.p -U progressadmin -P mypass

 

[Kopperton]

TomBascom thank you that was it!