Description
You can enter special characters before and after any text you want to exclude from validation and processing. These characters may be changed by individual sites at installation. The CA Dataquery system option default for BEGIN COMMENT is */ and the default for ending a comment is /*. The System Profile topic selected from the List of Help Topics panel (DQN10) that appears with the HELP command tells you the characters in use at your site.
The BEGIN COMMENT command precedes any comment you want to add to a query without having it read by CA Dataquery during query execution. The END COMMENT command follows the text to be excluded.
Action
Enter the BEGIN COMMENT command anywhere in the text area of the Editor panel to tell CA Dataquery not to read the following text. Type an END COMMENT command after the text to be excluded.
Example
=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: SHOW EDITOR LINE COMMAND FUNCTIONS ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. ..================================ T O P ===================================== 01 */THIS QUERY JOINS SALES HISTORY ROWS TO RECEIPTS ROWS FOR MONTHLY 02 REPORT DISTRIBUTED TO BRANCH MANAGERS/* 03 FIND 10 CAI-SLSHST-REC 04 WITH SHIP-QTY > 100 05 RELATED BY ITM-ID TO CAI-RCPTS-REC 06 SET NET-COST (8.2) = CAI-SLSHST-REC SHIP-QTY * UNIT-PRICE 07 SET DISCOUNT (5.2) = NET-COST * DISC-PCT 08 SET DISCOUNT-COST (8.2) = NET-COST - DISCOUNT 09 SORT CAI-RCPTS-REC BY (ITM-ID) 10 CAI-SLSHST-REC BY (ITM-ID) 11 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID' ----------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> EXECUTE <PF4> SAVE <PF5> DIALOG DEF <PF6> DELETE <PF7> BACKWARD <PF8> FORWARD <PF9> UPDATE <PF10> VALIDATE <PF11> RIGHT/LEFT <PF12> CREATE MODE
|
Copyright © 2014 CA.
All rights reserved.
|
|