are we use the group by clause in cursors?

Answer Posted / bubbles

We can use group by in cursors, but not when using
aggregate functions like Distinct,Max etc

Is This Answer Correct ?    20 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you define commarea?

563


Can you explain cics translator?

610


What are the cics commands associated with task control?

537


Explain the difference between the into and the set option in the exec cics receive map command?

562


name the command that is used to dump the main storage areas related to a task?

633






What does the 'cebr:cics' transactions do?

586


Differentiate between PCT and FCT.

645


What is the use of the eibaid field?

621


In case if the user inputs the characters which turn out to be uppercase, then what is the procedure to close that condition?

577


Can you define cemt?

658


What is the cics command level?

566


Give the definition of COMMAREA ?

629


how can you prevent more than one user from accessing the same transient data queue?

612


What do you mean by CEMT?

775


Mention the option used in a cics command to retrieve the response code after execution of the command?

641