http://www.dbatodba.com These are the search results for the query, showing results 1 to 10. http://www.dbatodba.com/Forums/db2/508100756/836271540 Hi Experts, I have two schemas having same tables and another schema contain sequences.Is it possible to call the sequences from other two schemas not specifying the sequence schema? Thanks in Advance No publisher ratheeshknair 2009-07-16T06:10:06Z Comment http://www.dbatodba.com/Forums/db2/523307706/625048920 Hi Perallis,   The above error got soloved when i gave authorization in CAPS.But I am still getting the same old error db2 => create server sevdb2a type DB2/UDB version '9.5' wrapper drda AUTHORIZA ON rknair PASSWORD rknair123 options( add dbname 'db2a') DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Processor command.  During SQL processing it returned: SQL1101N  Remote database "db2a" on node "<unknown>" could not be accessed with the specified authorization id and password.  SQLSTATE=08004   No publisher ratheeshknair 2009-05-11T13:11:04Z Comment http://www.dbatodba.com/Forums/db2/523307706/160384563 Hi Perallis,   I created databases db1a and db2a.   I am running this in command window.   Now I am getting Error  db2 => create server sevdb2a type DB2/UDB version '9.5' wrapper drda authorizat n rknair PASSWORD rknair123 options( add dbname ' db2a') DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Processor command.  During SQL processing it returned: SQL0104N  An unexpected token "authorizaton" was found following "n '9.5' wrapper drda".  Expected tokens may include:  "AUTHORIZATION".  SQLSTATE=42601 No publisher ratheeshknair 2009-05-11T13:06:55Z Comment http://www.dbatodba.com/Forums/db2/523307706/826013384 db2 => create server sevdb2a type DB2/UDB version '9.5' wrapper drda authorizat on rknair PASSWORD rknair123 options( add dbname 'db2a') DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Processor command.  During SQL processing it returned: SQL1101N  Remote database "db2a" on node "<unknown>" could not be accessed with the specified authorization id and password.  SQLSTATE=08004 No publisher ratheeshknair 2009-05-11T09:36:29Z Comment http://www.dbatodba.com/Forums/db2/523307706/584837236 Hi Perallis, Many thanks for you help.   I am still getting error   I am using Windows XP and  the script provided is for Linux..Is that the problem? No publisher ratheeshknair 2009-05-11T07:24:53Z Comment http://www.dbatodba.com/Forums/db2/523307706/632525605 HI Perillis,   I am using 9.5 C Express and the site given below shows that its not possible to federate database http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.licensing.doc/doc/r0053238.html.   I tied the script you have given and getting error. db2 => create server sevdb2a type DB2/UDB version '9.5' wrapper drda authorizat on \"rknair\" PASSWORD \"rknair123\" options( add dbname 'db2a') DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Processor command.  During SQL processing it returned: SQL0007N  The character "\" following "r drda authorization" is not valid. SQLSTATE=42601   No publisher ratheeshknair 2009-05-08T05:47:42Z Comment http://www.dbatodba.com/Forums/db2/523307706/444253279 db2 => "create server CY1274 type DB2/UDB version '9.5c' wrapper drda authorizat ion \"administrator\"scrolllock \"administrator\" options( add dbname 'carddemo )" DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Processor command.  During SQL processing it returned: SQL0007N  The character "\" following "tion \"administrator" is not valid. SQLSTATE=42601 No publisher ratheeshknair 2009-05-07T18:15:05Z Comment http://www.dbatodba.com/Forums/db2/523307706/738732503 Also I am using 9.5C Express. Is it possible to federate database in this version? No publisher ratheeshknair 2009-05-07T15:24:27Z Comment http://www.dbatodba.com/Forums/db2/523307706/605143478 Thanks Perallis,   Till fourth step its working fine after that  I am not able to do please help   My server is CY1160 Username:rknair Password:rknair123 DATABASE1=CARDAPPS DATABASE2=CARDDEMO TIA No publisher ratheeshknair 2009-05-07T15:22:31Z Comment http://www.dbatodba.com/Forums/db2/523307706/648302254 Hi Exerts,   I am newbie to DB2 Please help me Can anyone please tell me how to access an object from databaseA when we are connected to databaseB Is it possible to query like this SELECT * FROM DATABASE1.ADMINISTRATOR.CARDT When I am connected to DATABASE2   TIA No publisher ratheeshknair 2009-05-06T13:35:00Z Comment