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 we say that bms length of field = 0, then what does that mean?
How do you access storage outside your CICS program?
Which option of the PCT entry is used to specify the PF key to be pressed for initiating a transaction?
Can you explain cics translator?
how can we display negative sign in a map?
what is psuedo conversation?
I just want to ask why does the variable I passed in a dclgen of sql that has a data type of varchar which has a maximum length is 250 is truncated,, Here is the code.. DCLGEN of rsauud01 table 01 dataarea 43 data-area-len pic s9(4). 43 data-area-text pic x(250). MYVARIABLE. 01 DATAAREA1 pic x(250). move 250 to data-area-len of dataarea of rsauud01 MOVE DATA-AREA1 TO data-area-text of dataarea of rsauud01 --- but it is always trucated everytime I insert it in the table by the way it is a cobol-cics program
Why must all CICS programs have a Linkage Section ?
What is journal recovery?
Explain the difference between and exec cics xctl and exec cics start command?
What is MDT? What are FSET, FRSET ?
What is the content of the PPT entry?