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
9
10938

CICS

Answer

Showing Answers 1 - 9 of 9 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
move usero to ws-user.


move passo to ws-pass.


 


use sql query like


 


select  user , pass into ww-user , ww-pass


 from table_name


if sql code = 0


move 'userid n password matching' to messageo


else


move 'missmatch' to messageo.

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'