自动iseries导航器生成sql命令 [英] automate iseries navigator generate sql command

问题描述

我有时会使用iseries导航器"generate sql"将DDS对象转换为sql代码.有没有办法使它自动化?还是绿屏等效命令?我真正想要的是一种将键控逻辑文件转换为一组sql索引的方法.

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.

推荐答案

您要使用生成数据定义语言(QSQGNDDL)API ...

You want to use the Generate Data Definition Language (QSQGNDDL) API...

http://www-01.ibm.com/支持/知识中心/ssw_ibm_i_71/apis/qsqgnddl.htm

至少有两个使用此API的已发布实用程序.
http://www.ibmsystemsmag. com/ibmi/developer/general/Generating-DDL-Source-Using-a-CL-Command/
http://www.itjungle.com/mgo/mgo060502-story01.html

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

这篇关于自动iseries导航器生成sql命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！