CREATE ALIAS QTEMP.GLJRN0502 FOR S2KPRDD.GLJRNLS(GLJRN0502)

SELECT * FROM QTEMP.GLJRN0502 WHERE     (JNCO = '002') AND (JNDEPT = '531') ORDER BY JNMACT, JNSACT

From within SQL Server Reporting Services I'm accessing iSeries file...

Have you accomplished this using Analysis Services?  I'm at a loss as to how to break up the CREATE ALIAS and SELECT commands.  If you have a general answer to...

In Reporting Services