Technote (FAQ)
Question
Is it possible to export only "specify other" values through a DMS script? The select statement only selects the "specify others" category but nonetheless the base question is always included in the export.
Answer
By default when exporting a "specify others", the base question will always be included as the specify other is seen as a slice. It is possible to specify a different name in the SQL and then the export will only contain the "specify others". E.g. instead of using "SELECT Q1._4 from vdata", use "SELECT Q1._4 as Q1_4 from vdata". More information is available in the DDL topic called "Filtering Data in a DMS File".
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.