How can i Switch database inside procedure in Sybase ASE

[former_member754528]

In SQL Server I am using "use database_name" in exec statement inside procedure..

but Sybase ASE i cant able to change database dynamically...

can anyone help me please

[parth_raval]

Hi Srinath,

Please find the below link..Hope it will help you.

Use the Database Properties wizard to change database options using sp_dboption ---->  SyBooks Onlin...

[parth_raval]

Hi Srinath,

What's your exact need..??

If you want to extend size of data device, log device, data device/log device for saptools, etc.., you can use transaction "DBACOCKPIT".

Thanks And Regards,

Parth Raval

[former_member754528]

My Need is dynamically changing database inside procedure (like use database_name)..use database_name command not working inside procedure..

[parth_raval]

Hello Srinath,

In Sybase ASE you can use "alter database_name" to change database dynamically.

Also refer below links for detailed information.

Alter Database Syntax ----->    SyBooks Online

Alter Database Command ----->   SyBooks Online

Thanks And Regards,

Parth Raval

[former_member754528]

I tried alter database_name..

its not working.