![]() ![]() ![]() In the past if I ever wanted to run a CL command in one of these member I would use SQL's QCMDEXC procedure. RS RUNSQLSTM SRCFILE(&L/&F) SRCMBR(&N) COMMIT(*NONE) ERRLVL(20) I use RUNSQLSTM so much I have a PDM option defined so I don't have to type in the command and all the parameters I care about. I also put miscellaneous groups of SQL statements into source members, that I can then execute whenever I want. I use the command a lot as I put all of my SQL statements to create Tables, Views, Indexes, and the statements to Alter them into source members, and I update the member whenever I make a change to the object. The Run SQL Statements command, RUNSQLSTM, runs all of the SQL statements that are in a particular source member. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |