How can i change the below code in SQL to cobol/400?
EXEC SQL SELECT COUNT(*) INTO : WS-COUNT FROM Db file
WHERE Field 1 = : WS-VAR AND
Field 2 = : WS-USERID
END-EXEC

Answer Posted / mithun paul

1. Start the DB file with field1 and field2.
2. Read the DB file next record and increase the counter
value.
3. End the process, when end of file reached.




Mithun Paul
KMG Infotech Ltd., Kolkata

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define redefine and its syntax?

542


Explain how to update data area in cobol 400 program?

575


What is comp?

549


Explain the syntax of sort?

560


Explain the difference between comp & comp-3?

545






Define perform?

518


What is the actual use of fillers?

503


What is input procedure?

578


What is the syntax of redefine?

535


Explain how to convert 2010/02/11 to m/dd/yyy.. With string and without string if any other method... Code?

645


Explain the difference between search and searchall?

509


What is perform?

535


I like to know if possible to use %TRIM or any statement with prefiv "%" like RPG ile programs. thanks

2064


Define perform? And its types?

504


What is output procedure?

542