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 input procedure?

582


why icetool be used in programmer view?

2149


What is the actual use of fillers?

507


What is comp?

557


Define sort?

589






Define redefine and its syntax?

549


Explain how to update data area in cobol 400 program?

583


What is the syntax of redefine?

544


What are fillers?

537


How to detect record is locked in cobol/400?

544


Explain the difference between search and searchall?

519


What is output procedure?

549


seqence numbers in cobol

2668


What is the syntax of sort?

544


Explain the difference between section, paragraph and sentences?

518