[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Why isn't the "LIS" file being produced?



Hi,

I've written the following test SQR script, but see no LIS file produced after 
the script is executed.  FYI, the table "ps_bas_sched" does exist within an 
Oracle database.

Does anyone have an idea why no LIS file is being produced?  Is there something 
wrong with the program?

Thanks.

-- A.D.

BEGIN SQR SCRIPT

begin-program
        do list_customers
end-program

begin-heading 4
        print 'Name' (1) center
        print 'Sched ID' (3,1)
        print 'Description' (,32)
end-heading

begin-footing 1
        page-number (1,1) 'Page '
        last-page () ' of '
end-footing

begin-procedure list_customers
begin-select
sched_id (,1)
descr (,32)
   position(+1)
from ps_bas_sched
end-select
end-procedure

END SQR SCRIPT


--== Sent via Deja.com http://www.deja.com/ ==--
Before you buy.