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 |
Can you issue SQL COMMIT from a CICS program?
How to prevent user to access a screen directly from cics Native screen by using Trans Id?
Can you define transid?
How are screens created in cics
What is Tclass in cics?what is its importance? How it is implemented?
What is CEDF?
Receive consists of buffer option in it. What is the significance of this option?
Mention the content that is present inside a PPT ?
Explain the basic difference between Intra partition TDQ and Extra partition TDQ.
What is the use of a TDQ, TSQ?
how do you intitiate another transaction?
What is the most common way of building queue-id of a TSQ? (Name the constituents of the Queue ID).