problem relted to db2clp

ankur02018 · #1 (**permalink**) 08-16-07, 06:53

suppose i execute command

select ID from TPUBI

if there are large no of records

i cant see the first one

how could see in window record at a time then press enter other window record shows

ARWinner · #2 (**permalink**) 08-16-07, 07:51

You cannot do that as far as I know. You best bet would be to redirect the output to a file for viewing. To do this you would use a command like:

update command options using z on d:\merge_andy_str.sql
select * from bigtable
update command options using z off

Andy

guyprzytula · #3 (**permalink**) 08-16-07, 09:10

pipe the output to a file - pg the file - head - tail

stolze · #4 (**permalink**) 08-17-07, 04:36

Additionally, You can use cursors or execute separate SQL statements. You can also avoid the files by directly piping the output of the query to a pager:

Code:

$ db2 "select ..." | less

grofaty · #5 (**permalink**) 08-17-07, 04:59

Quote:

Originally Posted by stolze

Additionally, You can use cursors or execute separate SQL statements. You can also avoid the files by directly piping the output of the query to a pager:

Code: