/*
Expand Email Files
Peter @ EIMINTL.COM 07-2013

Expand the column width of the email columns in the Profile table to capture full email metadata.

These queries are provided 'as is' and EIM assumes no liability for their use. Test first and understand the impact of these statements. All queries run on 1 single Library. 
*/

Update docsadm.docscolumn set col_length = 1000 where colname='PD_Originator'
Update docsadm.docscolumn set col_length = 1000 where colname='PD_Addressee'
Update docsadm.docscolumn set col_length = 1000 where colname='PD_EMAIL_CC'
Update docsadm.docscolumn set col_length = 1000 where colname='PD_EMAIL_BCC'
ALTER TABLE docsadm.profile ALTER COLUMN pd_originator varchar(1000)
ALTER TABLE docsadm.profile ALTER COLUMN pd_email_cc varchar(1000)
ALTER TABLE docsadm.profile ALTER COLUMN pd_email_bcc varchar(1000)
ALTER TABLE docsadm.profile ALTER COLUMN pd_addressee varchar(1000)