DB2 Server for VSE & VM: Interactive SQL Guide and Reference

RIGHT



            .-1-------.
>>-RIGHT----+---------+----------------------------------------><
            '-integer-'
 

RIGHT is an ISQL display command that causes the display to start integer columns to the right, counting from the leftmost column of the display, provided no columns are being excluded. The number refers to the columns provided by the SELECT statement, not those currently displayed. You must use the order of the columns specified in the SELECT clause of the SELECT statement that provided the query result to determine the value for integer. If the value of integer represents a column being excluded, the display starts at the next displayable column to the right of the excluded column. If no more columns to the right can be displayed, a blank display results.

Specifying a value greater than the number of columns remaining to the right displays the last column or a blank display if the last column is excluded.

If no number is specified, the display moves one column to the right or to the next displayable column to the right if that column is excluded.

The RIGHT 1 command can be invoked by pressing PF11. Because you can reset your PF key values, you can assign the RIGHT 1 function to any PF key. The default function key is PF11 or PF23.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]