Re: unload in ESQLC
Mark Christmas wrote:
>
> Hari: sadly, the unload sql statement only works within dbaccess (the
> 'DB' tag in the SQL reference manual indicates this). High Performance
> Loader (7.2 and above) will allow you to perform unloads.
>
> Hari Muthuswamy wrote:
> >
> > I am trying to issue the unload statement from ESQLC. My ESQLC compiler
> > does not seem to like it. It says
> > esqlc: "preprocessor.ec", line 62: Error -33200: Invalid statement on
> > symbol 'unload'.
> >
> > The statement was
> > $unload to rptdly select * from rptdaily;
> >
> > My other Sql statements work fine.
> >
> > Can any one help me out on this.
> >
> > Thanks,
> >
> > Hari
>
> --
> +-----------------------------------------------+
> | Mark Christmas mailto:mchristmas@crosskeys.com
> | CrossKeys Systems Corp http://www.crosskeys.com
> | 350 Terry Fox Dr
> | Kanata, ON, Canada K2K 2W5
> | Phone (613) 591-1600 Fax (613) 599-3626
> +-----------------------------------------------+
Havent seen the initial post, but you can write these unload to a
file (from esqlc) and then use:
system ("dbaccess dbname filename");
Slower, more cumbersome, but gets around the problem...
--
Mike Aubury _\\?/_
|O O|
+----------oOOO-\\_/-OOOo---------+-------------------------------+
| Heisenberg may have been here | mike@aubury.demon.co.uk |
| | http://www.aubury.demon.co.uk |
+--------------------------------+-------------------------------+