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 |
If DATAONLY option is specified in the SEND MAP command what will happen?
Explain the difference between tsq and tdq
What is the effect of including the TRANSID in the EXEC CICS RETURN command?
What is temporary storage?
What is the difference between getting the system time with EIBTIME and ASKTIME command?
what is an MDT in cics
What CICS command do you need to obtain the user logon-id?
Name at least one of the ways by which a transaction can be terminated?
What are the terms cics generally means?
In SYMBOLIC Cursor Positioning after moving -1 to the length field also the cursor is not positioned in that particular field. Give reasons?
how to code the following map using occours clause? all the three fields have different length. ename eno addr 1) _______ _________ __________ 2) _______ _________ __________ 3) _______ _________ __________ 4) _______ _________ __________ 5) _______ _________ __________ 6) _______ _________ __________
How errors are handled in CICS programs?