Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Tuning LDB PNP

Former Member

‎01-13-2006 12:27 PM

0 Kudos

Hi all,

Can any one tell me how to optimize data retrival in PNP LDB.

3 REPLIES 3

Former Member

‎01-13-2006 12:34 PM

0 Kudos

Hi Bala,

The underlying program which works under ldb PNP is very well optimized.

It depends upon what you give as selection values for the ldb.

Can you elaborate?

Regards,

Raj

Former Member

‎01-13-2006 12:47 PM

0 Kudos

To be more specific

1)Its gets all the records from the database irrespective of date.

so if we know the range then we can resrict using SET_data_interval macro.

sll'y

1) if i need ansal from p0008 . it gets all the fields

Can we restive to ansal ?

and so...

suresh_datti
Active Contributor
In response to Former Member

‎01-13-2006 1:30 PM

0 Kudos

Hi,

Use the following statement to restrict selection by dates.

infotypes : 0008 VALID FROM date1 TO date2.

I don't think you have the GET dbatb FIELDS option with the PNP Logical database. You just have to use loop at p0008 where ansal =...

Regards,

Suresh Datti