I occasionally use iseries navigators "generate sql" to convert out DDS objects into sql code. Is there a way to automate this? or perhaps a green screen equivalent command? what I'm really after is a way to translate a keyed logical file into a set of sql indexes.
相关问题
- What is the best way to handle BOOLEAN values in D
- SQL1032N No start database manager command was iss
- How can I read the liblist from within an ILE-Prog
- COBOL DB2 program
- SQL LIKE Column Value Plus Wildcard DB2
相关文章
- Escape percentage sign DB2 SQL
- DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703 [clo
- Extra rows being received when matching pairs in S
- How to check DB2 SYSADM or SYSCTRL authorization f
- Which is the Best database for Rails application?
- How do I get connection pooling working on a PHP-C
- SQL concatenate text fields from different records
- Why can't my As400 select from a newly created
You want to use the Generate Data Definition Language (QSQGNDDL) API...
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_71/apis/qsqgnddl.htm
There's at least two published utilities that use this API.
http://www.ibmsystemsmag.com/ibmi/developer/general/Generating-DDL-Source-Using-a-CL-Command/
http://www.itjungle.com/mgo/mgo060502-story01.html