[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Missing views when rebuilding PS_JOB
- Subject: Missing views when rebuilding PS_JOB
- From: Zubin Shroff <zshroff@DTTUS.COM>
- Date: Tue, 6 Jul 1999 17:40:40 -0500
- Alternate-Recipient: Allowed
- Conversion: Allowed
- Disclose-Recipients: Prohibited
- Original-Encoded-Information-Types: IA5-Text
- Priority: normal
- X400-Content-Type: P2-1988 ( 22 )
- X400-Mts-Identifier: [/c=US/admd=TeleMail/prmd=Deloitte/; 01AE6378285E827E-MTAUSCNT1DT]
- X400-Originator: zshroff@deloitte.com
- X400-Received: by ans2-pub.dttus.com (Internal Mail Agent-2); Tue, 6 Jul 1999 17:44:49 -0500
- X400-Received: by ans2-pub.dttus.com (Internal Mail Agent-1); Tue, 6 Jul 1999 17:44:49 -0500
- X400-Recipients: non-disclosure;
We had added a couple of fields to the PS_JOB table through App
Designer. When rebuilding the table, I checked the options to recreate
all views. There are over 50 different views for the JOB record, and
the rebuild process did not seem to recreate any of these views. We
had to run a DDL audit on the database and recreate each view. Any
ideas/explanations?
Thanks.