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
8961 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 are fillers? What is the actual use of fillers? With mall/simple example?

948

Explain the difference between search and searchall?

826

What is redefine?

1135

Explain the difference between comp & comp-3?

913

What are the types of perform?

963

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

2435

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

1104

Explain the output procedure?

978

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

907

Define perform?

947

What is sort?

900

Explain the types of perform?

939

why icetool be used in programmer view?

2523

What is perform?

1058

How to detect record is locked in cobol/400?

931