Specifying a List of Values in a SQL Selection Statement for iSeries Report Splitter · Customer Portal

To specify a list of values when including criteria for splitting a report, use the IN SQL keyword.

For example: To include all pages where @REP is either 100 or 200, use:

@REP IN("100","200")

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016