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 |
How do you use altindxs in batch, cics programs?
How to test CICS, MainFrame applications
Suppose you are adding a new field in a map, and that field should also be added as a new column in DB2 table. How do you implement this? what is the impact analysis u will do?
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
What are the some important fields in the eib block?
Mention the 5 fields available in the symbolic map for every ?NAMED? field in the DFHMDI macro? Give a brief description of these fields (Not exceeding a line).
In a particular cics program, what is the procedure to allocate dynamic memory?
What is the pic clause for the any bll cell type of data fields?
What happens to resources supplied to a transaction when an XCTL command is executed?
Can you use occurs in bms map?
Can you explain dfheiblk?
Explain the means of supporting pseudo conversation programming. (E.g. Storing and restoring of states)