Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Single FEX | Multi SQL Query | Multi Sheet Output


Brendan Parochelli

Recommended Posts

I have a simplified report using ORA SQL that provides an XLSX output.

I would like to have the existing query below populate in Sheet 1 of the XLSX and add a second query that will populate in Sheet 2.

So far all information on Compound Reports and BYTOC seems does not seem applicable or working as expected to reports written entirely in SQL.

 

Report :

ENGINE SQLORA SET DEFAULT_CONNECTION &Server.(BANREP,BANPPRV,BANDEVL).Choose_Server.

SQL SQLORA PREPARE SQLOUT FOR

SELECT * FROM TBRACCD WHERE 1=1 AND TBRACCD_TERM_CODE = '202110 'AND TBRACCD_PIDM = '701785';

END

TABLE FILE SQLOUT

LIST *

ON TABLE PCHOLD FORMAT XLSX

END

 

Second Query To be Added :

SELECT * FROM TBRACCD WHERE 1=1 AND TBRACCD_TERM_CODE = '202113 'AND TBRACCD_PIDM = '701785';

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...