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

Is length = 0 sufficient to ascertain that the field has been modified?

567


how do you fire a batch job from a cics txn ?

602


How to get the cursor position when we receive a map?

572


What is the difference between SEND MAP DATAONLY and SEND MAP MAPONLY ?

712


What is eib?

641






when an xctl is done, does the tranid change ? Is a new task created ? Does it cause an implicit syncpoint to be issued ?

712


Explain the difference between a symbolic map and physical map?

563


What is the use of tdq and tsq?

598


what are the differences between and exec cics xctl and exec cics start command?

674


which cics command must be issued by the application program in order to gain access to the common work area (cwa)?

660


Define the term function request shipping?

571


With the use of an alternate index, how is a VSAM file accessed?

635


Explain the difference between a package and a plan. How does one bind 2 versions of a cics transaction with the same module name in two different cics regions that share the same db2 subsystem?

534


Can QSAM files be accessed from CICS?

675


What does the 'cebr:cics' transactions do?

574