Wednesday, 30 March 2016

EDIT MASK -Show - Display SQR Commands

SQR Commands – Show and Display and EDIT MASK

·   Display command useful to display only one value at a time

Display &STUDID
Display &NAME
Display &SEM

Output:
100
Satish
4
Display &STUDID NO LINE
Display &NAME NO LINE
Display &SEM

Output:
100 Satish 4
·   Show command useful to show more than one value at a time.
                                          
Show &STUDID &NAME &SEM

Output: 100 Satish 4


·   We can also use the EDIT Mask with Show and Display.

Display '123456789' xxx-xx-xxxx
Output: 123-45-6789

Display 1234567.89 999,999,999.99
Output: 1,234,567.89


No comments:

Post a Comment