The view you create must reside in a database. Create a dummy database and open it before creating your view.

HTH

>I must be doing something wrong....... Here's my code:
>
>CREATE SQL VIEW grid;
> AS SELECT glacnt, gltdes, glamnt, credit, noshow;
> FROM gldent;
> WHERE gldent.batchno = glhent.batchno;
> AND gldent.glseqno = glhent.glseqno;
> ORDER BY gldent.batchno, gldent.glseqno
>
>When the above code is executed, I receive the message - No database is open or set as the current database.