are we use the group by clause in cursors?

Question Posted / pavankumar

Answers were Sorted based on User's Feedback

are we use the group by clause in cursors?..

Answer / 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

are we use the group by clause in cursors?..

Answer / suma

We can use group by clause in cursor. But when used the
cursor is not updatable.

Is This Answer Correct ?

3 Yes

1 No

are we use the group by clause in cursors?..

Answer / madhusudhana

No we cant use group by clause in cursor because a GROUP BY
may be used on a column(s) but not on row(s)

Is This Answer Correct ?

4 Yes

9 No

More CICS Interview Questions

What is the pic clause for the data type of length option field type of data fields?

How does COBOL II and CICS release 1.7 provide for exceptional conditions and how does that differ from

What happens to resources supplied to a transaction when an XCTL command is executed?

Explain the use of DCT ?

what are transient data sets defined to cics?

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

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

Before issuing an ASKTIME command what will be the values in the EIBDATE and EIBTIME fields ?

How do you place the cursor on a particular position on the screen?

What is the comaera (communication area)?

what are the differences between and exec cics xctl and an exec cics link command?

Name the macros used to define the following: MAP MAPSET FIELD

For more CICS Interview Questions Click Here