Menu

#19 PSPCMPROG order by LASTUPDDTTM DESC ?!?

v1.0 (example)
open
Erik H
None
5
2016-10-27
2016-10-27
Alphonse
No

Hello Great tools

But, we can't extract all peoplecode of database
Because we have a timeout after 5 hours :-(

We propose 2 solutions to solve the problem :

  • make the extraction with a descending date, so that, we can relaunch with the since option on a newer date .. You just have to add "order by LASTUPDDTTM DESC;" where you make your
    select * from PSPCMPROG order by LASTUPDDTTM DESC;
  • And to complete the developpement by adding the option "until" to be able to extract a period

With that, it will perfect, and I will be able to recommand this very nice tool.

Regards

Alphonse

1 Attachments

Discussion


Log in to post a comment.