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 |
Why do we need integrated cics translator?
What is the common work area (CWA)?
Can you define attribute byte?
What is the function of the LOAD command?
Define floating maps with illustration?
list the sequence of steps used to achieve modiication in skip sequential mode?
Can you issue SQL COMMIT from a CICS program?
Can you have CICS code in a copybook? If yes, what happens during compilation?
What is multitasking and multithreading?
how do you fire a batch job from a cics txn ?
Define an asra?
Define ceci?