View previous topic :: View next topic
|
Author |
Message |
induajayrose Warnings : 2 New User
Joined: 25 Jul 2005 Posts: 28 Location: Thrissur
|
|
|
|
Hi,
Can you please give the answers for these questions.
1. When we use select in DB2 whether it will collect a set of records.Is it to avoid this we are using cursor,ie to fetch 1 record at atime.
How all we can define cursor,is it possible through Working- storage section and procedure division.What is the difference between two?
2.While we are defining a GDG we are using the term (chronolagical ly and functionally related datasets)what is meant by chronological . |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi There,
Quote: |
1. When we use select in DB2 whether it will collect a set of records.Is it to avoid this we are using cursor,ie to fetch 1 record at atime.
How all we can define cursor,is it possible through Working- storage section and procedure division.What is the difference between two? |
Yes to Process all the record return by query we use cursor & there is no
difference between cursor defining in Working- storage section and procedure division But it should always define before OPEN Cursor stmt
Quote: |
2.While we are defining a GDG we are using the term (chronolagical ly and functionally related datasets)what is meant by chronological . |
I am not able to understand ur question. |
|
Back to top |
|
|
induajayrose Warnings : 2 New User
Joined: 25 Jul 2005 Posts: 28 Location: Thrissur
|
|
|
|
Thanks Ekta...
Regarding 2nd question..
When we try to explain a GDG we will define it as "group of datasets which are chronologically and functionally related".In this what is the significance of the word 'chronological'.
regards,
indu |
|
Back to top |
|
|
muthuvel
Active User
Joined: 29 Nov 2005 Posts: 217 Location: Canada
|
|
|
|
Quote: |
In this what is the significance of the word 'chronological' |
The term 'Chronological' means order of occurence.In case of GDG you can see that the versions are in an order.For example,you have a daily updated GDG ,then the latest version will be today's data and previous version will be yesterday's data and so on..
Thanks,
Muthuvel. |
|
Back to top |
|
|
therasith
New User
Joined: 02 Jan 2004 Posts: 52 Location: chennai
|
|
|
|
Chronological Means
Arranged in order of time of occurrence. |
|
Back to top |
|
|
|