{ WorkingScripts }

  • Home
  • Scripts
  • About Me

scripts Archive

17/08/2012
PeopleTools Objects Analysis SQL

PeopleTools Objects Analysis SQL

Problem: Need to review all objects for a particular project, including descriptions and status:
by Iouri "Yury" Chadour | Scripts
Read More
17/08/2012
Purging lots of data in UDB

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.
by Iouri "Yury" Chadour | Scripts
Read More
17/08/2012
UDB Escape Characters

UDB Escape Characters

select oprid, oprdefndesc from psoprdefn where oprid like '%\_%' {escape '\'} and acctlock = 0
by Iouri "Yury" Chadour | Scripts
Read More
  • Top Posts & Pages

    • Notepad++ for Peoplecode and SQR
    • Notepad++ Function list for PeopleCode and SQR
  • Tags

    AD Blackberry blogging Books Conference DB2 DBA Debugging Development GUI image Javascript jQuery KeyNote LDAP MOS nVisoin oow OpenWorld Oracle pagelet PeopleBooks peoplecode PeopleSoft PeopleSoft Browser PeopleTools PeopleTools. AppClass Performance Portal ppt presentation Process Scheduler scripts Security Social SQL SQR SSO Tips Tracing UDB Upgrade Utilities utility Wordpress
  • Blogroll

    • Chris Malek's Blog
    • David Kutz' PeopleSoft DBA Blog
    • Graham Smith's Blog
    • GreyHeller Blog
    • Jim Marion – PeopleSoft Development
    • Oracle PeopleTools Blog
    • PeopleSoft Tipster
    • PeopleSoft Wiki
    • Stephen Pillips' PSST0101
Stay Connected with us
{ WorkingScripts } Copyright © 2021.
Copyright {WorkingScripts} 2012. Back to Top ↑