Re: [Bulk] Re: [Bulk] Can't call QSQGNDDL on a V7R2M0 box.

Hi, Justin:

As Alan suggested in his reply, Operations Navigator (aka. System i Navigator, or IBM i Navigator) is one way to do that ...

If you really want a "green-screen" tool or command to do that without having to directly write a program to call some APIs, well ... one way is to do a Google search for "RTVSQLSRC" ... several folks have published various magazine articles complete with source code showing how to create your own command to do that ... (a "wrapper" around the IBM supplied APIs). And, you probably can even find someplace that has a "ready to run" version already compiled, so you just download and install it on your IBM i system (e.g. FTP a save file and RSTOBJ ...).

(Sorry for not being more specific, but it is late and I am tired -- time for some sleep now.)

HTH,

Mark S. Waterbury

> On 7/19/2015 12:35 AM, Justin Dearing wrote:

Mark,

Thanks for clarifying.

So I do want a greenscreen command, not an API to run from RPG. I have an
existing PF. I want to reverse engineer the CREATE TABLE DDL. I already
know how to issue a new CREATE TABLE command from STRSQL, or from the db2
command from QSH in PASE.


Thanks,

Justin

On Sun, Jul 19, 2015 at 12:26 AM Mark S Waterbury <
mark.s.waterbury@xxxxxxxxxxxxx> wrote:

Justin:

Not sure exactly what you are trying to do, but QSQGNDLL is an "API" and
not a "command". Do you know and understand the difference?

An "API" (or "Application Programming Interface") is a program that you
call and pass various parameters to request the system to perform some
task or retrieve some information from the system.

If you just want to create SQL DB2 TABLEs and VIEWs, perhaps you might
want to try the command "STRSQL" ... this provides an interactive
"green-screen" tool for entering and running SQL statements, such as
"CREATE TABLE." One thing I like about STRSQL is that you can even
"prompt" SQL statements within STRSQL by typing, e.g. "CREATE TABLE" and
then pressing F4=Prompt. Try it, I think you will like it.

Eventually, you might want to look into getting the IBM i Navigator
running on your PC -- it provides a PC GUI toolset for entering and
running "SQL scripts" and commands, and is considered to be a more
"modern" alternative to STRSQL.

HTH,

Mark S. Waterbury

> On 7/19/2015 12:11 AM, Justin Dearing wrote:

Hello,

I would like the CREATE TABLE DDL for a PF on my clients V7R2M0 system. I
am QSECOFR on this system. The internet tells me that QSQGNDDL is a
wonderful tool for doing that, and proceeds to tell me that DDL is the
future and DDS is the past, which is great news for me because I'm a PHP
programmer that knows SQL, and not DDS, or RPG.

Unfortunately, this IBMi tells me "Command QSQGNDDL in library *LIBL not
found." This is not great news for me.

http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/apis/qsqgnddl.htm

Indicates that this command still works in V7.2 (also it gave me stern
warnings about the maintenance window). It doesn't say what library it
would be in, or else I'd attempt to edit my library list, which is
something I have not done in a decade, but understand in theory. What am

I

doing wrong?

If there is an alternative methodology to "script" a PF to a CREATE TABLE
statement, such as through PASE, I'm all ears. I'm actually much more
comfortable at the PASE shell prompt than the green screen.

Thanks,

Justin

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.