scripts Archive

PeopleTools Objects Analysis SQL
Problem: Need to review all objects for a particular project, including descriptions and status:

Purging lots of data in UDB
Problem: Need to delete 2-3 million rows from a table in UDB. Attempting to use one statement causes table locks and heavy log usage.

UDB Escape Characters
select oprid, oprdefndesc from psoprdefn where oprid like '%\_%' {escape '\'} and acctlock = 0