PS Query & SQL

This session is intended for those who have experience with PS Query. Rather than simply explore techniques, this presentation will focus on using those techniques to get things done. We will explore the things that can be done with PS Query that it doesn't do automatically. This will include the use of expressions, including SQL functions (using the Oracle database), modifying how effective dating is used, and left outer joins. We will also discuss the advantages that views can provide and when to ask for them. Finally, we will also look at what you can and can't do when using PS Query to help you write equations. Before the conference, I'll be asking you to contribute things that you'd like to see as examples (but I can't promise I'll address them all!)

https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=6ae53bc7-ea66-4d54-bc8f-8f207d8b0339

#Vic_Goldberg
#PSQuery
#Intermediate