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
9075 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 sort? And its syntax?

1029

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

904

Explain the output procedure?

1026

Explain the input procedure?

933

Define redefine?

1113

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

1141

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

994

What are the types of perform?

1018

seqence numbers in cobol

3112

Explain the difference between search and searchall?

862

Explain the difference between comp & comp-3?

950

Define perform? And its types?

977

Explain how to update data area in cobol 400 program?

1012

How to update data area in cobol 400 program?

1037

How to detect record is locked in cobol/400?

970