Home > IT Answers > Updat a dabase using CL
cmarsellus
50 pts.
 Updat a dabase using CL
Development
Is it possible to update using CL commands? If so can an example be provided.

Software/Hardware used:
ASKED: November 16, 2004  5:19 PM
UPDATED: November 17, 2004  10:31 AM
RELATED QUESTIONS
Answer Wiki:
No, CL does not have the capability of updating database files. It is possible to indirectly update a file by creating a Query Manager Query and passing it parameters at run time.
Last Wiki Answer Submitted:  November 17, 2004  10:15 am  by  Rchevalier   0 pts.
All Answer Wiki Contributors:  Rchevalier   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I have a sql statement in a source type SQL that updates a db. From the CL:
RUNSQLSTM SRCFILE(mich/MICHwork) SRCMBR(SQLPPRST) +
COMMIT(*NONE)

I have been reading some about stored procedures…but haven’t had the opportunity to use them. You might see if that would help.

Mickailee
 0 pts.