Shulou(Shulou.com)06/01 Report--

The set command is used to set disql system environment variables. By using the show command, users can quickly and easily understand the current environment variable settings of the disql environment.

Test environment: won the bid Kirin 664 bit, Dameng database version 7 abbreviated as DM7

Start the disql tool, and use the help command in "SQL >" to get help from set and show.

Demo 1: start disql

[dmdba@dm1 ~] $disql / nolog

Disql V7.1.5.42-Build (December 30, 2015-64335trunc)

SQL >

Description: disql / nolog just starts the disql tool. If you want to learn more about the use of the disql command, use disql-h to get more information about how to do disql.

Demo 2: get set help

SQL > help set

Demo 3: get show help

SQL > help show

DM7 has set commonly used configurations to default values, such as autocommit off by default, long by default, and so on. This reduces the debugging of disql parameters and is convenient for everyone to use. Through the pagesize setting as an example, other parameter settings are exemplified, and the corresponding parameter settings are adjusted according to the needs.

Pagesize can set the size of each page to control the amount of data displayed on each page. If set to 0, all output is one page and column headers are not displayed. The default value is 14.

Demo 4: view the default values for pagesize

SQL > show pagesize

PAGESIZE 14

Demo 5: create a test table T1

Create table T1 (col1 int)

Demo 6: enter data:

SQL > begin

For i in 1..20 loop

Insert into T1 values (I)

End loop

Commit

End

/

Demo 7: view the data of the T1 table

SQL > select * from T1

Line number COL1

--

1 1

2 2

3 3

4 4

5 5

6 6

7 7

8 8

9 9

10 10

11 11

Line number COL1

--

12 12

13 13

14 14

……

Note: the above data output reaches 14 lines will be paged, to carefully examine the above display information, do not be confused by the number 11.

Demo 8: adjust the value of pagesize

SQL > set pagesize 30

Demo 9: view the value of pagesize after setting

SQL > show pagesize

PAGESIZE 30

Demo 10: view the data of the T1 table

SQL > select * from T1

Line number COL1

--

1 1

2 2

3 3

4 4

5 5

6 6

7 7

8 8

9 9

10 10

11 11

12 12

13 13

14 14

15 15

16 16

17 17

18 18

19 19

20 20

Set pagesize to 30, and the data paging for 20 rows of query disappears. The parameters of disql are very flexible and can be adjusted individually according to the actual needs.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.