Mainframe, MVS and zOS Discussion

DB2Explain the effects of using CURSOR WITH HOLD with GROUP BY and ORDER BY clauses in your queries.

Hi,

Does any one have idea about rc 1000 in JCL?
 

Happy New Year everyone!

Hi,

Thanks for the reply. I want to test the query in SPUFI and QMF and later use the query in COBOL program.

How to get top 5 rows from table thru SQL?

203

Thanks.

I have seen people using MVS also but not MFT or MVT. But as you said, IBM documents still use MVS, perhaps that makes to use it.

Hi,

My question is perhaps offtopic but this has been haunting me. What is more appropriate to use between OS390 versus zOS? I have seen people are using these terms, usually, interchangibly. Is not it that OS390 is among the initial releases of the operating system? And it's zOS now.

Yes, that's the only option I am also thinking of now.

The result of the function YEAR should be large integer (S9(09) COMP) and should be defined as binary of 4 bytes. Change the host variable definition and see if it works. And if it does, you should read back what Enrico has said initially and you'll realize that you had the answer right there. :) T...

Robert Sample wrote:It can make a big difference!  If you want to know the return code of the program you ran in TSO, you CANNOT use IKJEFT01!  And if you get an ABEND, you will see the difference between IKJEFT1A and IKJEFT1B in the ABEND code you get.

hmmm,,ok Thanks.

Hi - From manuals and some tests, I have checked that in z/OS 2.1 a PDSE can be of two different types - type 1 or 2. Manual  gives information about DSINFO and it has been enhanced to set the variable, ZDSDSNV, to indicate if the PDSE is version 1 or 2. But I don't find a similar variable for LISTD...

Thanks enrico. A VALUE CANNOT BE ASSIGNED TO OUTPUT HOST VARIABLE NUMBER position-number BECAUSE THE DATA TYPES ARE NOT COMPARABLE Explanation A CALL, FETCH, SELECT, VALUES INTO, or SET statement with an output host variable could not be performed because the data type of a variable was not compatib...

Thanks all for explanation. I did look at the documentation before posting it here. I should have told about that. But the documentation does not say if IKJEFT1A is better, bad, good or something else when used in place of IKJEFT01 for a DB2 Job. Or there is just no difference as long as we are usin...

181

Hi,

I have seen JCLs for DB2 making use of IKJEFT1A and IKJEFT01 both. I have mostly used the JCLs using IKJEFT01 but not IKJEFT1A. What is that used for? Does it improve on efficiency?

Hello, I have written a test COBOL program. I am using SCALAR function YEAR in the program. Function is used to get the Year part from the date from DB2 table. The corresponding host variables are PIC X() The problem is my program abends at the FETCH statement with a SQL CODE OF -303. How do I corre...

79, for the original post.

Hi,

How to get the date changed from a member of a PDS in 'C' on zOS? Can someone give some pointer?

061.