In WebFOCUS (8205) we have the ability to create a new text file with an SQL extension (or to upload a .sql file). I'm wondering if there's any way to leverage these files when running a fex file.
Obviously, we'd need to provide an adapter and connection but since we use SQL pass thru is there a way to basically point at the .sql file when a report runs?
This is specifically looking at the SQL Script option in the WebFOCUS repository (not Reporting Server).
Thanks!This message has been edited. Last edited by: Dan Brooke,
Have you tried to -INCLUDE the .sql file ?
Waz, that worked! I had tried it before posting but I'm pretty sure I had a syntax error. Thank you!
As a follwup, is there a way to reference this from InfoAssist? My goal is to allow end users to upload .sql files and leverage them to create content in InfoAssist.
I imagine I can get the SQL written to a hold file and create content against that hold file but the hold file wouldn't update to pull new data.
Thanks for the help so far!
Investigate the SQL_SCRIPT format - it might help you some, but would probably depend upon what level of security you give to your groups and roles.
Tony, thanks for the reply!
I think we'll be able to leverage SQL_SCRIPT to help us with this. Thanks!
|Powered by Social Strata|