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 a cursor in CICS sql processing?
Name the cics command that gives the length of twa area?
mention the option (along with argument type) used in a cics command to retrieve the response code after execution of the command?
What are the differences between Temporary Storage Queue (TSQ) and Transient Data Queue (TDQ).?
Specify the CICS command used to read a VSAM record starting with prefix ?F?. Code all the relevant options.
What is task control?
What is the pcp in the cics?
NMDS is both device dependent and format dependent (True or False)
Name the cics command used to access current date and time?
If -1 is moved to length for more than one field on a map, where will the cursor be positioned?
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 cics regions that share the same db2 subsystem?
what is an mdt (modified data tag)? Its menaing and use?