Hi Philippe, I have had some time to take a look into Sybase ASE. Generating tables and columns seems easy using "sp_help", although selecting data from sysobjects and syscolumns seems even more useful, as documented here:
http://stackoverflow.com/questions/1429898/from-a-sybase-database-how-i-can-get-table-description-field-names-and-types However, I'm still having some trouble in discovering primary / unique keys. I raised an issue here. http://stackoverflow.com/questions/7299550/discover-primary-unique-keys-in-sybase-ase Once this is done, I can realise basic Sybase ASE support in a first step. Stored procedure support in a second step. Have you had some success with your own attempts at looking into a contribution? Cheers Lukas 2011/8/22 psevestre <[email protected]>: > Hi, > > I'm currently evaluating jOOQ for a number of projects for the > organization I consultt for but it seems that its support for Sybase > actualy aplies to Sybase Anywhere. Are there any plans to support > Sybase ASE in the horizon ? > > From what I could see in the source code, the generator expects to > find schema information in some "standard" tables, but ASE does not > support those tables. Instead, one usually uses the system proc > "sp_help" in order to gather schema information. > > In such scenario, which steps should I follow in order to support a > new database dialect ? > > > Regards, > > Philippe
