are we use the group by clause in cursors?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is the difference between LINK and XCTL ?
Explain the difference between dfhcommarea and tsq?
What are the cics commands associated with task control?
What is a cursor in CICS sql processing?
What is meant by PPT and what are its uses?
List the sequence of steps used to achieve ?Modification in Skip Sequential Mode.?
Db2 what is 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 cicsregions that share the same db2 subsystem?
What is the difference between physical map and symbolic map?
Define ceci?
What is the eib parameter?
Explain the difference between the into and the set option in the exec cics receive map command?
Name the three ways available for a program to position the cursor on the screen?