This section contains error messages for the functions that create remote objects.
16
Unable to create table '%.*s' because it has no remote storage location defined. Creation of local user tables is allowed only in the master and tempdb databases.
Component Integration Services (CIS) is a feature that extends Adaptive Server capabilities and allows you to access and manipulate tables in remote servers as if they were local tables. When you install Adaptive Server, files needed to interact with CIS are placed in the installation directory.
Error 11202 is raised when you attempt to create a table, but Adaptive Server is unable to locate or otherwise access one of these files. The problem can occur even if you are creating a local table and do not utilize CIS.
Use the following checklist to ensure that the necessary file is accessible:
Check that the SYBASE environment variable is properly set. If you recently upgraded, make sure that this variable was updated. Restart the server after checking this variable.
Make sure that you start the server as user sybase.
Check that the files dsopt1 (necessary for local tables) and dsopt2 (necessary for remote tables) exist in your installation directory. For example, in Unix sites the file $SYBASE/install/dsopt1 must exist with read permissions before you can create local tables. Restore any missing files and restart Adaptive Server.
The ASE directory structure has changed with 12.0. Check
your Installation and Configuration guide for details.
All versions
16
The command ’%s’ is not legal for objects of this type. External definition: %.*
Adaptive Server 12.5 enables SQL access to file system directories and their underlying files. A Component Integration Services (CIS) proxy table, created with the command syntax
create table table-name external file at "directory-path" ...
maps column names to attributes of files that exist within the external directory.
Given the nature and purpose of CIS proxy tables defining external file systems, not all Adaptive Server commands and functions are applicable to these tables. Error 11203 is raised when the server is instructed to perform an operation that is incompatible with this type of table.
For example, Error 11203 may be raised when one of the following operations are attempted on an external file system proxy table:
dbcc checks
the alter table command
the delete table command
the create index command
partitioning commands
Do not attempt the operation that raised error 11203. Batches or scripts that perform mass operations such as dbcc checks may need to be altered to ensure that the offending operation is not attempted on the external file system proxy table.
Have the following information ready when you call Sybase Technical Support:
Adaptive Server version and SWR rollup level
Server error log
12.5 and later
