MVSFORUMS.com

manojvoona · Beginner Joined: 05 Jan 2006 Posts: 43 Topics: 14

Hi,

My requirement is to read all the records sequencial. The Primary key is not a sequencial number and so we can not incorporate a logic to fetch one after the othe.

Is there a feild in DB2 like row ID, which is a unique incremental number by which we can fetch one after the other.

It would be of great help.

Thanks
Manoj Voona

kolusu · Posted: Fri Jan 13, 2006 8:09 am Post subject:

manojvoona,

What exactly do you mean sequential? DB2 does NOT gurantee that if you load the records the sequentially , they will be stored sequentially. Db2 finds the first available page and stores the records. So if you want to maintain sequence then you need add the ROWID column to your table.

Hope this helps..

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

manojvoona · Beginner Joined: 05 Jan 2006 Posts: 43 Topics: 14

Thanks a lot.

Manoj Voona

manojvoona · Beginner Joined: 05 Jan 2006 Posts: 43 Topics: 14

Hi Kolusu,

What is the maximum number of records that a cursor can accomedate.

thanks
Manoj Voona

kolusu · Posted: Mon Jan 16, 2006 6:16 am Post subject:

manojvoona · Beginner Joined: 05 Jan 2006 Posts: 43 Topics: 14

thanks a lot Smile