If you are unable to create a new account, please email support@bspsoftware.com

 

Can you run a sql report in decision stream

Started by MPK25, 21 Apr 2006 04:39:10 PM

Previous topic - Next topic

MPK25

Hi,

I have the following query.Ã,  When I run this query in Oracle SQL it generates in the form of a report.Ã, 
I want to know if I can get the same output when I run this query in a sql window in a datasource.

set headsep 1
column NUM format 1500
column LEVEL format 1500 word_wrapped
column PART_CODE format 1500 word_wrapped
column TOTAL_ITEMS format 1500 word_wrapped

break on NUM skip 1 on report
compute sum of TOTAL_ITEMS on NUM
set linesize 50
set pagesize 60
set newpage 0

select A.NUM, B.LEVEL, C.PART_CODE,
COUNT(C.ITEM) AS TOTAL_ITEMS
FROM
ITEM_DETAIL A, PART_LEVEL B,
PROD_DETAIL C, MASTER_DETAIL D
WHERE
A.ITEM_NO = D.ITEM_NO AND
B.LEVEL = D.LEVEL AND
C.PROD_ID = D.PROD_ID
GROUP BY
A.NUM, B.LEVEL, C.PART_CODE
ORDER BY
A.NUM ASC, B.LEVEL, C.PART_CODE ASC

Because I am getting the following error when I run it:
DS-DBMS-E400: UDA driver reported the following on connection 'source':

DMS-E-GENERAL, A general exception has occurred during operation 'execute immediate'.
ORA-00922: missing or invalid option

Plz help.

Thank you.

MP.


CoginAustin

just go to the "SQL Helper" paste it and run it. The output you see is what you will get