Table I/O: Implecation of using Table.Select, Table.FetchNext without using Table.Open and Close
In RDA, for F0911 view, the select and fetch next is used to bring few columns from F43121. It used 3 times with subsequent if conditions.
The code look like this.
F43121.Select
F43121.FetchNext
if(few conditions)
F43121.Select
F43121.FetchNext
Else if(few conditions)
F43121.Select
F43121.FetchNext
If the code is executed for example, 10,000 records of F0911, what is the implecation as the code is not with F43121.Open and F43121.Close? Will it make any issue with server ? Will it make any database locks ? Will it affect subsequent deployment ?
Tagged:
0