Step 1: Creating subfiles

• QUIZ
  >access D-SALES
  >report summary all
  >set subfile name SALESUB keep size 10000
  >set report limit 1
  >go
• QTP
  >access D-SALES
  >subfile SALESUB keep size 10000 include D-SALES
  >set input limit 0
  >go
• Different results if items redefined more than once

Previous slide

Next slide

Back to the first slide

Back to the main menu

View Graphic Version

Notes:

You can use either QUIZ or QTP to create a subfile. QTP has two features that can make it a better choice:

1. The record length of a QUIZ subfile can be greater than the original data records because fields with multiple redefinitions appear more than once. The record length of a QTP subfile is exactly the same as the original data records.2. QTP's syntax is more flexible. With QTP, it's easier to reference fields from two datasets to create a subfile for Suprlink output. You can also use an alias to include items with the same name.