setdisqlshowdisql
6 647DM7
disqlSQL>helpsetshow
1disql
[dmdba@dm1 ~]$ disql/nolog
disql V7.1.5.42-Build(2015.12.30-64335trunc)
SQL>
disql/nologdisqldisqldisql hdisql
2set
SQL> help set
3show
SQL> help show
DM7autocommitlong800disqlpagesize
pagesize,014
4pagesize
SQL> show pagesize
PAGESIZE 14
5t1
create table t1 (col1 int);
6
SQL> begin
for i in 1..20 loop
insert into t1 values (i);
end loop;
commit;
end;
/
7t1
SQL> select * from t1;
COL1
---------- -----------
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10
11 11
COL1
---------- -----------
12 12
13 13
14 14
1411
8pagesize
SQL> set pagesize 30
9pagesize
SQL> show pagesize
PAGESIZE 30
10t1
SQL> select * from t1;
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
pagesize3020disql
