Hi there anybody knows how to run

[Sachinkhare]

Hi there
anybody knows how to run SQL files (For report purpose) on the menu level by passing SQL statement .????? having all dot matrix printer setting.

i'm currently using HOST command to run the sql. But it creates another session.

thanking you

sachin

 

[sem]

What do you mean by "menu level"?

 

[Sachinkhare]

I want to run report from fomrs menu.....
when u click menu.....in the backend some sql query must be passed and report should get run.....this is what i want

i don't want to actually design the report in report6i......
how we run report....just doing something in SQL> prompt...

thank u
regards
sachin

 

[sem]

You may call run_product built-in from menu code.

 

[Sachinkhare]

see this is my file from which i can create report on SQL? prompt
here the file starts....


set term off;
set verify off;
set feedback off;
set pages 65;
set lines 80;
break on ext_int skip1 on report;
--
column today new_value today noprint;
column lin new_value lin noprint;
--
select sysdate today, rpad('-',80,'-') lin from dual;
--
ttitle skip1 -
lef 'PROCESS_MST.SQL' -
cen 'SSSK COMPANY' -
rig 'DATE : ' today skip1 -
cen 'PROCESS MASTER' -
rig 'PAGE NO : ' format 999 SQL.PNO skip1 lin;
--
column ext_int heading 'EXT|INT';
column proc_long_desc heading 'PROCESS|DESCRIPTION';
--
spool C:/dustbin/process_mst.txt;
--
select ' ',
decode(substr(proc_cd,1,1),'E','EXTERNAL','I','INTERNAL') ext_int,
proc_cd, proc_long_desc
from process_mst
order by proc_cd
;
spool off;
exit;


how can i attach this file in menu so that i can directly get print of report.

this i do on unix and sql prompt
thanking you

sachin

 

[sem]

Did you read about run_product built-in? There's no difference what kind of script you run.