SybDBA
Participant
Member since ‎2014 Dec 16

User Statistics

  • 148 Posts
  • 1 Solutions
  • 14 Kudos given
  • 5 Kudos received

User Activity

Hi All, Can we change/alter owner of the views and procedures in SAP IQ, like tables in SAP IQ. As we have already moved tables to new schema from old one. We wanted to remove old schema, due to certain requirement. But due to underlying proced...
Hi All, I have a huge table contains around 50bn data, on which we have range partition, each partition contains around 13mn records, while we are dropping the partition using alter table .... drop partition ... command , it takes around 1 an...
Hi All, How do, I revoke select rights after specific time in SAP IQ ? For e.g, like If my requirement is to grant select to a specific user for 2 days only , so what should I do , instead of manually...
Hi All,Thanks in advance!!How to get number of estimated rows returned from a query in Sybase ASE ?(assume that query in being executed)Thank you!!Regardspankaj
Hi All, Please help me to understand the different values which displayed by select @@version and sp_version procs. As in above snap installcommit script shows the old version 15.0.3 , which usually happens when we manually install the scripts from i...