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

1061

Explain the difference between section, paragraph and sentences?

991

Define sort?

1190

Explain the input procedure and output procedure?

920

Explain the syntax of sort?

983

What is perform?

1107

seqence numbers in cobol

3127

Define redefine and its syntax?

986

What are the types of perform?

1046

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

973

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

970

What is comp?

1160

How to update data area in cobol 400 program?

1053

Define redefine?

1131

What is the syntax of redefine?

955