How CICS program validates the data in the database using COBOL logic?
How CICS program validates the data in the database using COBOL logic?
- Create a map in CICS to map the user id with password.
- Ensure the following code is placed in the program:
MOVE USER TO WS-USER.
MOVE PWD TO WS-PWD.
- Use the SQL queries as follows:
SELECT USERNAME FROM EMPLOYEE WHERE USERID LIKE ā%Sā
- Validate by matching the values and move the same values of USER and PWD, if matches.
- Otherwise move different values of USER and PWD.