Sybase ADAPTIVE 15.0.2 User Manual Page 129
- Page / 160
- Table of contents
- TROUBLESHOOTING
- BOOKMARKS
Rated. / 5. Based on customer reviews
CHAPTER 7 Troubleshooting
Installation Guide 113
Determining whether
select * should be
changed in views
If dbcc upgrade_object reports the existence of select * in a view, compare the
output of
syscolumns for the original view to the output of the table, to
determine whether columns have been added to or deleted from the table since
the view was created.
For example, suppose you have the following statement:
create view all_emps as select * from employees
Before upgrading the all_emps view, use the following queries to determine the
number of columns in the original view and the number of columns in the
updated table:
select name from syscolumns
where id = object_id("all_emps")
select name from syscolumns
where id = object_id("employees")
Compare the output of the two queries. If the table contains more columns than
the view, and retaining the pre-upgrade results of the
select * statement is
important, change the
select * statement to a select statement with specific
column names. If the view was created from multiple tables, check the columns
in all tables that comprise the view and rewrite the
select statement if necessary.
Warning! Do not execute a select * statement from the view. Doing so
upgrades the view and overwrites the information about the original column
information in syscolumns.
Another way to determine the difference between the columns in the view and
in the new tables is to run
sp_help on both the view and the tables that comprise
the view.
This comparison works only for views, not for other compiled objects. To
determine whether
select * statements in other compiled objects need to be
revised, review the source text of each compiled object.
Using dbcc upgrade_object
Syntax dbcc upgrade_object [ ( dbid | dbname
[, ['database.[owner].]compiled_object_name' |
'check' | 'default' | 'procedure' | 'rule' |
'trigger' | 'view'
[, 'force' ] ] ) ]
where:
- Adaptive Server 1
- Enterprise 1
- 35889-01-1502-01 2
- April 2007 2
- Contents 3
- About This Book 7
- Related documents 8
- Adaptive Server Enterprise 10
- About This Book 11
- Overview 17
- Product components 19
- Backup Server 20
- Stored procedures 20
- The client 20
- Adaptive Server editions 21
- Enterprise Edition 22
- Small Business Edition 22
- Developer Edition 22
- CHAPTER 1 Overview 23
- Installing Adaptive Server 29
- System requirements 30
- Accessing SPDC 31
- Getting your host ID 32
- Generating licenses at SPDC 33
- Generating a served license 34
- Installation Guide 19 35
- ASE150.[csh.sh] 37
- Installation Guide 23 39
- Installation Guide 25 41
- Installing server components 42
- Installation methods 43
- Installation Guide 29 45
- Installation Guide 31 47
- Installation Guide 33 49
- Backing up Adaptive Server 52
- Installation Guide 37 53
- Post-Installation Tasks 55
- The SAMreport 57
- Installing sample databases 58
- Installing Sybase PC-Client 63
- Products 63
- Installing PC-Client products 64
- InfoMaker 67
- [DIRECTORY] 68
- Installation Guide 53 69
- Upgrading Adaptive Server 71
- Installation Guide 57 73
- Pre-upgrade tasks 74
- Installation Guide 59 75
- Reserved words 77
- Using quoted identifiers 78
- Create a sybsystemdb database 80
- Using sqlupgrade 81
- Installation Guide 67 83
- Using sqlupgraderes 84
- Post-upgrade tasks 85
- Run the instmsgs.ebf script 86
- Installation Guide 71 87
- Reenabling Replication Server 89
- Reenabling auditing 91
- Shutting down SySAM servers 92
- Installation Guide 77 93
- Upgrading Job Scheduler 94
- Upgrading high availability 100
- Installation Guide 85 101
- Method #1: Dump and 101
- Adaptive Server Enterprise 102
- Installation Guide 87 103
- Troubleshooting SySAM Issues 105
- Troubleshooting SySAM 107
- SySAM grace mode 112
- SySAM grace period 113
- Troubleshooting 115
- Error log locations 116
- Cannot use X-Windows 117
- Address already in use 119
- The Installer fails to start 119
- Cannot start XP Server 119
- Configuration failed 120
- CHAPTER 7 Troubleshooting 121
- Restoring from backup 122
- Re-running the upgrade 122
- Reserved word errors 127
- Quoted identifier errors 127
- Temporary table references 128
- Using dbcc upgrade_object 129
- Error reporting 132
- Upgrading using dump and load 132
- Removing Adaptive Server 135
- Alternative Installation 137
- Silent installation 138
- Installation Guide 125 141
- Using srvbuildres 144
- Upgrading Servers with 145
- Replicated Databases 145
- 1> dbcc gettrunc 146
- 2> go 146
- Using sybsystemprocs 151
Related products and manuals for Computers Sybase ADAPTIVE 15.0.2
Computers Sybase MAC OS X User Manual
(54 pages)
(54 pages)
Computers Sybase 15 User Manual
(74 pages)
(74 pages)
Computers Sybase 15.0.2 User Manual
(160 pages)
(160 pages)
Computers Sybase 12.4.2 User Manual
(1 pages)
(1 pages)
Computers Sybase Desktop User Manual
(226 pages)
(226 pages)
Computers Sybase OneBridge 4.1 User Manual
(96 pages)
(96 pages)
AEG A52100HLW0 manuals
Owner’s manuals and user’s guides for Unknown AEG A52100HLW0.
We providing 3 pdf manuals AEG A52100HLW0 for download free by document types: User Manual
Comments to this Manuals