cancel
Showing results for 
Search instead for 
Did you mean: 

How can i Switch database inside procedure in Sybase ASE

0 Kudos
218

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

Accepted Solutions (0)

Answers (3)

Answers (3)

parth_raval
Participant
0 Kudos
parth_raval
Participant
0 Kudos

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

0 Kudos

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

parth_raval
Participant
0 Kudos

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

0 Kudos

I tried alter database_name..

its not working.