Hi,

 

We have a need to generate code bindings from DB/2 on z/OS.  So far we've 
been doing it by copying the schema from the z/OS database into a DB/2 LUW, 
then running the code generator against the LUW.  We've had to do this 
because the jooq is coded to use the SYSCAT catalog, present on LUW but not 
on z/OS.

 

I'm looking for alternatives to this process.  Came up with a few ideas, 
but I was wondering if anyone else has solved this problem or has some 
different recommendations?

 

   1. Find a way within jooq to map the SYSCAT schema over to SYSIBM.  I've 
   done this just fine for regular data tables, but the catalog schema 
   remapping is not something I see how to do.
   2. Automate the schema synchronization with a tool like liquibase, and 
   keep generating from an LUW DB/2
   3. Create views onto SYSIBM named SYSCAT, sufficient to meet the needs 
   of the jooq code generator.  I don't know quite how many views that 
   would be, but looking at o.j.u.d.syscat.Tables it seems to start at 
   thirteen.

 

Any thoughts or guidance would be appreciated.

 

Thanks,

Jeff

-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to