1

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?

1 Answer 1

1

Those tables are still in ASE 15.5

syscolumns

syscomments

sysobjects

systypes

2
  • 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, 2012 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. Jan 26, 2012 at 18:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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