1. Start the DB file with field1 and field2. 2. Read the DB file next reco

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

Question Posted / mithun paul

2 Answers
9231 Views
HP, I also Faced
E-Mail Answers

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 perform?

1157

What is the syntax of sort?

966

Explain what all the conditiones required for using open opcode on a file?

1007

Explain the output procedure?

1076

Define perform? And its types?

1059

Explain the difference between section, paragraph and sentences?

1048

What is output procedure?

1077

Define redefine and its syntax?

1035

Explain the difference between comp & comp-3?

1022

What are fillers?

1103

Explain how to detect record is locked in cobol/400? What is the solution for that?

950

What is the syntax of redefine?

1016

Explain the input procedure and output procedure?

962

What are the types of perform?

1109

Explain the difference between search and searchall?

919