-
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?
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'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.
-
JCL and JES
1.What is the difference between JCL and JES.? 2.What is the difference between VSAM and DB2?
rasheeed17
- Jan 19th, 2012
JCL: JCL is a language, We write JOBs in JCL laguage that is understood by Mainframe and job is executed, space allocations & other resource allocation is done according to the keywords specified by ...
mohammadanis.jamadar
- Oct 4th, 2011
JCL: is Job control Language.Through jcl we can decide what job has to be run what programs needs to be run.
JES: Job entry System : This will take care of the execution of the job . when a job is submitted it will allocate space for execution and will help in execution -
CICS Screen
How CICS Screen developed?
mohammadanis.jamadar
- Jul 25th, 2010
Basically CICS screens can be developed using BMS macros(DFHMSD, DFHMDI, DFHMDF). Apart from this we can develope it through SDF, APS, and many more tools are available.
-
How to create a PDS file using JCL
Chan
- May 25th, 2019
IEFBR14 is used to create PS file. IEBCOPY is used to create PDS file. Example: //JOB statement //STEP1 EXEC PGM=IEBCOPY //DD1 DD DSN=,DIS...
serken
- May 28th, 2017
PDS has absolutely nothing to do with folder. Those two are the terms from different worlds: mainframe vs. Windows/Unix/Android
-
What is sysda?
krishna
- Oct 11th, 2011
UNIT=SYSDA refers to the next available disk storage device.
