Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am working on a Perl application that uses DBIx::Class::Schema::Loader in order to generate the ORM layer of the application, against a Sybase ASE 15.5 database.

We recently migrated from Sybase 12.1, where the ORM generation worked fine, to our current database, where things have gone screwy. Our ORM layer doesn't change much, so this wasn't immediately apparent.

The driver for accessing the database information uses the syscomments, sysobjects, syscolumns, and systypes tables, but I can't find any reference to them in the ASE 15.5 system table documentation.

Searching through the documentation has led me to conjecture that these tables were retired sometime around 15.1, but I don't have enough expertise to be able to comment either way. Does anyone know where this information is stored in 15.5?

share|improve this question

1 Answer 1

Those tables are still in ASE 15.5

syscolumns

syscomments

sysobjects

systypes

share|improve this answer
    
Wow, that's reassuring to know. I suppose now I need to see if 15.5 stores entries in syscomments differently than 12.x. –  angelixd Jan 26 '12 at 17:50
    
Extracting SP text from syscomments is always going to be a pain. I tend to use a shell script + defncopy when I need to see SP text. –  Simon Righarts Jan 26 '12 at 18:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.