Re: SQL in CL. -- MIDRANGE-L

I am a newbie and am still trying to learn RPG. I have a question regarding
CL programming. Is embedded SQL supported in CL programs? If so, are SELECT
statements supported?

In addition to Vern's excellent suggestions of QMQRY, REXX and OPNQRYF,I'd like to add these:

a) In V5R3 it's possible to call the CLI APIs from CL. This provides someinteresting possibilities.

b) In earlier releases, you can run SQL via QShell commands. This can beconvienient, since you can build the SQL command on-the-fly.

c) Some people advocate creating an RPG program that accepts an SQLstatement as a parameter, and then simply prepares and executes it. Thisway you can call it from CL programs to perform SQL commands. Of coruse,this doesn't allow data to be returned (such as the result of a SELECT),but you could have SQL write the results to a file and read it from CLusing RCVF.

I want to do something like

(only an example SQL statement).
'SELECT CSTNUM,  CSNAME,  CSADD1, CSADD2, CSCTST, CSZIP from MYLIB.CSTMST
WHERE CSTNUM = 'PARM1';


For that I'd probably use QMQRY.

I posted this question in rpg group but I was advised that it would be more
appropriate to post it here.


I'm not sure if you understand why that is, so I'll explain.

There are SQL programmers who are not RPG programers. There are CLprogrammers who are not RPG programmers. It makes sense to post yourquestion in the correct forum. Don't post Java questions in the COBOLforum. Don't post CL questions in the RPG forum. It just makes sense!

In addition to that, the archives of the mailing lists are very valuablebecause when you're having a problem you can search them, find out whatother people have discussed, and often solve you problems in a fewminutes. To keep these archives valuable, you have to know which lists tosearch. For example, if I have a question about CL programming, itwouldn't make sense for me to search the Java mailing list. Therefore,it's to everyone's benefit if you post your questions to the right lists.

Remember, CL is a different language than RPG. The correct forum for CLdiscussions is MIDRANGE-L. The correct forum for RPG discussions isRPG400-L.