returning values to os level using "dbaccess - filename.sql" in a n nt
> Hi there,
> i'm new to informix and i want to run dbaccess to get smi values back to
> the calling command file (like errorlevel) using windows nt scripting. i
> don't want to use any addiional tools like perl-scripting or an other
> programming language. unfortunantely there is no hint in the documentation
> how to do this.
>
> regards
> marco
>
> example how i like to do this :
>
> rem ----------------------------------------------------------
> rem test.cmd
> dbaccess - testit.sql
> if returnvalue > 50 goto doit
> exit
> :doit
> net send mypc value is greater than 50
> exit
> rem ----------------------------------------------------------
>
> -- this is testit.sql
> database stores7;> select into variable count(lname) from customer;
return variable
> -- end of testit.sql