File:Phuse2015-CC05-notes.pdf

From PHUSE Wiki
Jump to: navigation, search
Phuse2015-CC05-notes.pdf(file size: 1.67 MB, MIME type: application/pdf)

The macro-function %VARLIST was developed as a generic utility function to retrieve lists of variables from one or more datasets, and process them according to specified criteria in order to dynamically generate SQL code fragments. Thus a few simple %VARLIST calls inserted between additional SQL keywords will generate a full SQL join of arbitrary complexity. This presentation will introduce in a few examples the general syntax of SQL joins of increasing complexity and show how %VARLIST can be used to simplify SQL code generation and make it dynamic.

File history

Click on a date/time to view the file as it appeared at that time.

Date/TimeDimensionsUserComment
current23:18, 12 October 2015 (1.67 MB)Jmbodart (talk | contribs)higher resolution
22:44, 12 October 2015 (1.18 MB)Jmbodart (talk | contribs)The macro-function %VARLIST was developed as a generic utility function to retrieve lists of variables from one or more datasets, and process them according to specified criteria in order to dynamically generate SQL code fragments. Thus a few simple %...
  • You cannot overwrite this file.

The following page links to this file: