Question & Answer
Question
Due to SOX requirements, I need to add a comment prologue to both my Query Management Form (QMFORM) and Query Management Query (QMQRY) source. How can I do that?
Cause
The iSeries DB2 Universal Database for iSeries Query Manager Use (Version 5 SC41-5212-05) has some information on comments, but it's not entirely clear in the case of Query Management Form.
Answer
Query Management Query (QMQRY)
0001.00 H QM4 05 Q 01 E V W E R 01 03 16/11/14 07:53
0002.00 /* this is a comment
0003.00 /* prologue
0004.00 /* SOX requirement
0005.00 /* $inc kjtrisko 14Nov2016 Initial creation
0006.00 V 1001 050 QMQRY for HR
Query Management Form (QMFORM)
0001.00 H QM4 05 F 01 E V W E R 01 03 16/11/14 07:53
0002.00 V 1001 050 This QMFORM is for HR
0003.00 * prologue
0004.00 * SOX requirement
0005.00 * $inc kjtrisko 14Nov2016 Initial Creation
0006.00 T 1110 009 002 1115 006 1118 003
The lines in red are the source comment.
[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 for IBM i","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Historical Number
AFKUAF
Was this topic helpful?
Document Information
Modified date:
18 December 2019
UID
nas8N1021715