Changing tablespace values in PeopleSoft

I recently had a project where I had an issue having to change the tablespaces for many records. Here is a handy script that will allow you to change the tablespace value and avoid build errors.

Enjoy!

Update PSRECTBLSPC
SET DDLSPACENAME = '<New_TablespaceName>'
WHERE DDLSPACENAME = '<Old_TablespaceName>'
and RECNAME IN (Select A.OBJECTVALUE1 from PSPROJECTITEM A, PSRECDEFN B
               Where A.PROJECTNAME = '<PROJECTNAME>' and A.OBJECTTYPE = 0 and A.OBJECTID1 = 1 and A.OBJECTVALUE1 = B.RECNAME and B.RECTYPE =0);