Create command in AS400 (IBM i) to run SQL Queries | AS400 Tutorial for Beginners
Creating a complex command to accept a parameter, and pass it on to the CL program logic, which in turn runs SQL queries.
Create a command in AS400 to run SQL queries.
1. Creating simple commands – review
2. Passing command parameter
3. Writing CL program to accept parameter.
4. Declare CL variables to encapsulate the input parameter.
5. Create SQL queries (CRTQMQRY)
6. Call SQL queries (STRQMQRY)
7. Compile
8. Run!
#as400 #ibmi #ibm #query #db2 #command #create #programming #development
