Write the code snippet to validate data in the database. - CICS
Write the code snippet to validate data in the database.
Following is the code snippet that validates the data:
- MOVE USER TO WS-USER.
- MOVE PWD TO WS-PWD.
- Use the SQL query as
Select userid, password into ww-user, ww-pwd from login_table
- If sql_code = 0 , then MOVE ‘userid and password matching’ to message.
- Otherwise MOVE ‘Missmatch’ to message.