When I try to register table(view from sybase ASE) to library i get the following error, but when i register table(table from sybase ASE) i have no problems.
*****************************************************************
NOTE: End of registration for table library.view_name.
NOTE: Additional host information:
X64_SRV12 WIN 6.2.9200 Server
NOTE: SAS Initialization used (Total process time):
NOTE: The autoexec file, D:\SAS\Config\Lev1\SASApp\WorkspaceServer\autoexec.sas, was executed at server initialization.
1 LIBNAME libray ODBC DATAsrc=datasourcename SCHEMA=dbo USER=dbo_user_net
1 ! PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;
NOTE: Libref libray was successfully assigned as follows:
Engine: ODBC
Physical Name: transferencias
2
3 PROC SQL;
3 ! CREATE TABLE work._memTypes AS
4 Select MEMTYPE, MEMLABEL, COMPRESS, ENCRYPT, DBMS_MEMTYPE from dictionary.tables where libname="library" and
4 ! memname="view_name" and MEMTYPE in ("DATA", "VIEW");; quit;
NOTE: Table WORK._MEMTYPES created, with 1 rows and 5 columns.
NOTE: PROCEDURE SQL used:
5 PROC SQL;
5 ! CREATE TABLE work._cols AS
6 Select NAME, TYPE, LENGTH, FORMAT, INFORMAT, LABEL, NOTNULL from dictionary.columns where libname="library"
7 and memname="view_name" and MEMTYPE in ("DATA", "VIEW");
NOTE: Table WORK._COLS created, with 24 rows and 7 columns.
7 ! quit;
NOTE: PROCEDURE SQL used:
8 PROC SQL;
8 ! CONNECT TO ODBC( DATAsrc=datasourcename USER="dbo_user_net"
8 ! PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX );
9 CREATE TABLE _Indexes AS
10 SELECT COLUMN_NAME, INDEX_NAME, SEQ_IN_INDEX, UNIQUE, 0 as ISPRIMARY
11 FROM CONNECTION TO ODBC(DBMS::Indexes("","dbo","view_name"))
12 order by INDEX_NAME desc;
NOTE: Table WORK._INDEXES created, with 0 rows and 5 columns.
13 QUIT;
NOTE: PROCEDURE SQL used:
14
15 PROC SQL;
16 CONNECT TO ODBC( DATAsrc=datasourcename USER="dbo_user_net"
16 ! PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX );
17 CREATE TABLE _PrimaryKeys AS
18 SELECT COLUMN_NAME FROM CONNECTION TO ODBC(DBMS::PrimaryKeys("","dbo","view_name"))
19 QUIT;
NOTE: Table WORK._PRIMARYKEYS created, with 0 rows and 1 columns.
20
NOTE: PROCEDURE SQL used:
21 PROC SQL;
22 CONNECT TO ODBC( DATAsrc=datasourcename USER="dbo_user_net"
22 ! PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX );
23 CREATE TABLE _ForeignKeys AS
24 SELECT PKCOLUMN_NAME, FKTABLE_NAME, FKCOLUMN_NAME
25 FROM CONNECTION TO ODBC(DBMS::ForeignKeys("","dbo","view_name", "", "", ""))
26 QUIT;
ERROR: Error executing CLI query statement: [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Object does not exist in this
database.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
27
Thank you!
