Formatting

• Time, date and currency format
• Field specification (worksheet name, title, subject, author, keywords, category, comments, etc.)
• Inclusion and exclusion of fields
• Sorting fields
• Field delimiter
• String delimiter
• Record delimiter
• Decimal point character
• Table specifications (table caption, header, columns, rows, cell spacing, cell padding, etc.)
• Sort specifications, query selection

Input sources

• physical DB2 files (file name/library)
• logical DB2 files (file name/library)
• Query/400 queries
• Query Management (QM/400) queries
• interactive SQL query statements
• SQL query statements stored in a source file member
• no additional expenditure of time through data transfer and ODBC query statements
• call i-effect^® tasks from existing (batch-processing) application using iSeries commands in a CL program