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

Those tables are still in ASE 15.5

syscolumns

syscomments

sysobjects

systypes

  • 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

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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