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

What is comp?

867


What are fillers? What is the actual use of fillers? With mall/simple example?

704


Define redefine?

841


What is the actual use of fillers?

692


Explain the input procedure?

687






Explain the syntax of sort?

725


What is input procedure?

753


Explain the difference between search and searchall?

664


Explain the syntax of redefine?

662


What is the syntax of redefine?

708


What is sort? And its syntax?

815


Explain the input procedure and output procedure?

668


Define perform?

754


Define sort?

830


Explain the types of perform?

673