Sybase ASE에서는 하나의 서버에 여러개의 DB가 있을 수 있습니다.

테이블이름을 쓰실 때에 DB명을 넣으시면 됩니다.

 

select * from DB명.Table명

 

 

exec sql begin declare section;
CS_CHAR user[16];
CS_CHAR passwd[16];
CS_CHAR name;
CS_INT value, test;
CS_CHAR server_1[BUFSIZ];
CS_CHAR server_2[BUFSIZ];
exec sql end declare section;
...
strcpy (server_1, "sybase1");
strcpy (server_2, "sybase2");
strcpy(user, "my_id");
strcpy(passwd, "mypass");
exec sql connect :user identified by :passwd at connection_2 using :server_2;
exec sql connect :user identified by :passwd using :server_1;
/* This statement uses the current "server_1" connection */
exec sql select royalty into :value from authors
where author = :name;
if (value == test)
{
/* This statement uses connection "connection_2" */
exec sql at connection_2 update authors
set column = :value*2
where author = :name;
}