Author Archive

Compiled Objects in ASE

September 22nd, 2011 No comments

Adaptive Server uses compiled objects to contain vital information about each database and to help you access and manipulate data.

  • A compiled object is any object that requires entries in the sysprocedures table, including:
  1. Check constraints
  2. Defaults
  3. Rules
  4. Stored procedures
  5. Extended stored procedures
  6. Triggers
  8. Functions
  9. Computed columns
  10. Partition conditions

Compiled objects are created from source text, which are SQL statements that describe and define the compiled object.

When a compiled object is created, Adaptive Server:

  • Parses the source text, catching any syntactic errors, to generate a parsed tree.
  • Normalizes the parsed tree to create a normalized tree, which represents the user statements in a binary tree format. This is the compiled object.
  • Stores the compiled object in the sysprocedures table.
  • Stores the source text in the syscomments table.

Why Software is Soft?

September 22nd, 2011 No comments

why software is soft ,it’s very basis question, worth to know it..

Our computer is designed in layered in architecture, In the core (inner layer) we have all physical component(h/w).

In starting , we were directly interacting with hardware and mainly in 1 & 0 , even you can say in on/off state of a transistor. It was really very difficult process for the user’s interaction.

To reduce the hardness of physical component for interaction, we started layering h/w with piece of code.

Simply saying to remove the hardness of hardware , for making it soft for users, we used layers, as we calling now as Software.

Thanks Prof Raman for clearing my thoughts!

object id 98 and 99 in ASE:sysencryptkeys & ALLOCATION

September 21st, 2011 No comments

20K+ Visitors in!

September 15th, 2011 No comments


One more good news you fav blog has reached the figure of 20K yday!!

Thank all for your support and response!!


Categories: ASE Tags:

ASE 15.7 for SAP® Business Suite Released in Techwave!!!

September 14th, 2011 No comments

Hi Folks,

Most Awaited Database ASE 15.7 has been released yday in Vegas Techwave:

Extremely good news for Sybase Users!!!!!!!!

ASE 15.7 key features include:

Management of Large Datasets

  • Compression— allows large databases to be stored more compactly and reduces I/O times to ensure high performance on even the largest databases.
  • Reduced Query Latency— helps better handle large data sets, especially those which use dynamic SQL for interactive data retrieval.
  • Replication Performance—increases the performance of Sybase’s industry-leading transaction replication and syncing technology.
  • Enhancements for Parallel Hardware —improves optimization of multi-core/multi-threaded CPU architectures to get the maximum performance out of today’s latest processors

Simplified Administration

  • Online Operations—increases data availability while allowing data to be optimized for application performance.
  • Extended Diagnostics—allows DBAs to quickly pin-point performance bottlenecks and speed customer support requests.
  • Strong Password Encryption—protects the database from external intrusion and hacking
  • Single Sign-on & Login Profiles—makes it easier to manage large numbers of users and simplifies end-user access to the system

Ease of Application Development

  • Efficient Management of Large Objects—inline management of large objects as well as enhanced application development features such as large objects as parameters to stored procedures.
  • Enhanced Application Language Capabilities—many improved TransactSQL&™ language features to increase productivity of application developers as well as support for a variety of popular languages such as Python, PHP and Perl.
  • An Enterprise-Class DB for ISV applications —enhanced business-critical performance for ISV applications out of the box, enabling ISVs to easily write and port their applications to ASE 15.7.
Categories: ASE, News Tags: , , , , ,

Essential DBA Unix

September 12th, 2011 No comments

Hi All,

I am listing the command which we are frequently used in our DBA unix enviorment. I would lile to thnx Abhay for sharing this.

Essential DBA Unix
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!System Administration!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

su : Acquiring super user status
su – henery : Crearting Other users (henery) environment
passwd : Changing Passowrd
date : Setting the system date
wall : Write message all users desktop , terminate
calender : display calender

Read more…

bcp copy in failed

August 17th, 2011 No comments

Hi Folks,

Few days back , we  have faced the issue regarding bcp in,  message was bcp copy in failed. Although Rows were inserting successfully.  The user which We were using that was dbo of database and had all

We tried with other login id and it was working fine, that was dbo alias.

We tried to remove user, added as  dbo alias, given explicit permission,but it didn’t work out.

It was totally weried as there was no problem at all , or you can say the issue which we were not able to
investigate as error is not much explanatory.

Also I would like to mention , we have refreshed this database from 12.5.4 to 15.0.3 env.

Finally we dropped the user, dropped login account and added again , means we craeted new login account
with same name  and after that added in db as a dbo alias. It worked fine now.
I am still not sure why this caused the issue.

Categories: ASE Tags: , , , ,

If failures is my Destiny, I would like to top in failures!!

August 7th, 2011 No comments

–If 100 plans fail, will make 200 next day!

— If failures is my Destiny, I would like to top in failures!!

Categories: ASE Tags: , , , ,

SAP HANA & Sybase!

August 2nd, 2011 No comments


HANA, which will be available in appliance form from a number of hardware partners,
places data to be processed in RAM instead of reading it off disks, adding a performance boost.
HANA is built on a superset of technologies with a long history at SAP,
including the MaxDB database and TREX in-memory engine.
Data held in memory by HANA is backed by a persistence layer that logs
transactions and incorporates savepoints that create images of the database,
according to an SAP document. This allows it to be restored in the event of a power outage or other disruption.
HANA is compatible with any BI (business intelligence) application that supports common query languages like SQL and MDX.

by PCWorld

HANA is not a database, it is an appliance (hardware + software). SAP sells these to large customers;
a typical HANA installation has 2 Terabyte of memory.
The database software inside HANA is a custom-developed database engine by SAP,
optimized for in-memory handling of analytic workload patterns. To the best of my knowledge,
it is not available for download.

by – Rob V.

HANA with Sybase ?

As per recent IDC Report, SAP would be pushing this HANA technology in
ASE & IQ and our Rep server would be replicating the data from HANA Appliance.

If HANA is going to be part Sybase ASE/IQ/REP then it will certainly enhance the
ASE functionality and performance. If you want more about HANA , please refer below links :

IDC Report :

Sybase: PowerBuilder and PowerDesigner

July 27th, 2011 No comments
  • Sybase PowerBuilder is a RAD tool that lets you develop rich GUI applications,

based on the DataWindow concept.I’ve been told that part of the

SAP POS module is actually developed  with PowerBuilder.

  • Sybase PowerDesigner is a modeling tool that lets you handle anything from a 

data model to a full enterprise architecture, and is widely seen as

one of the best such tools around.

Source :
Both PowerBuilder and PowerDesigner are not tied to any specific database and will work with most common database brands.

Categories: ASE Tags: , , , ,