How to validate data in database from cics program

I will have user name and password values in database. i create a map from cics. and i will enter user name and
password then validation should be done in COBOL program. what is COBOL logic to validate database?

Interview Candidate
Oct 7th, 2011
3
11046

CICS

Answer

Showing Answers 1 - 3 of 3 Answers

mohammadanis.jamadar
Profile Answers by mohammadanis.jamadar Questions by mohammadanis.jamadar

Oct 11th, 2011

1st thing is you have bring the screen Output variables to cobol program.

eg. MOVE USERO TO WS-USER-VAL .
Declare and open the cursor .Next fetch USER_ID_FROM_TABLE till the sqlcode = +100 from the table. Whenever the SQLCODE is ZERO then code the below code
IF HOST-VARIABLE-USER-ID-FROM-TABLE = WS-USER-VAL
MOVE " USER ID MATCHING"

hemanth.pesce
Profile Answers by hemanth.pesce

Oct 19th, 2011
Code
span style="color: #ff0000;">'userid n password matching''missmatch'

sarankumar

Oct 27th, 2011

Try this:
MOVE USERO TO WS-USER.
MOVE PWDO TO WS-PWD.
AND THEN USE THE SAME SQL QUERIES AS
SELECT USERNAME FROM EMP WHERE USERNAME LIKE '%S'
THEN validate as use the matching and move 'same value of user and pwd ' else move 'different values of user and pwd'