Search found 34 matches
- Mon Nov 18, 2024 2:09 pm
- Forum: JCL - Job Control Language.
- Topic: Return code 1000 in JCL.
- Replies: 2
- Views: 2744
Re: Return code 1000 in JCL.
Thanks Anuj.
- Mon Nov 18, 2024 1:44 pm
- Forum: CICS, Middleware and MQ Series.
- Topic: What are CICS web services?
- Replies: 5
- Views: 2904
Re: What are CICS web services?
zum13Many large businesses have huge investments in mainframe technology as the means of running their businesses. Migrating that functionality to another platform would be incredibly expensive to do so the alternative is to move away from the paradigm of the mainframe as being a thing solely for r...
- Mon Nov 18, 2024 1:34 pm
- Forum: Other Mainframe Topics, Off-Topics, FAQs.
- Topic: Get GDG versions in a file.
- Replies: 7
- Views: 1569
Re: Get GDG versions in a file.
Thank you so much zum13, this is very helpful.
- Tue Nov 12, 2024 7:47 pm
- Forum: Other Mainframe Topics, Off-Topics, FAQs.
- Topic: Get GDG versions in a file.
- Replies: 7
- Views: 1569
Re: Get GDG versions in a file.
zum13enrico-sorichettithe TS does NOT want to process all the generations
he wants to pull all the generations names into a file
As in
?Code: Select all
LISTCAT LEVEL(basename)
Thank you , this is what I am looking for. Is there a view to remove, the messages LISTCAT produces automatcally?
- Sun Nov 10, 2024 11:22 am
- Forum: Thought of the Day, General Talk & Jokes.
- Topic: Where do you live?
- Replies: 252
- Views: 239463
Re: Where do you live?
I live in Mumbai , India now.
- Sun Nov 10, 2024 11:20 am
- Forum: Other Mainframe Topics, Off-Topics, FAQs.
- Topic: Get GDG versions in a file.
- Replies: 7
- Views: 1569
Get GDG versions in a file.
hi all,
i am expecting to pull all gdg versions in a file using the gdg base names, can anyone help me same?
i am expecting to pull all gdg versions in a file using the gdg base names, can anyone help me same?
- Wed Apr 24, 2024 12:16 pm
- Forum: Interview Questions.
- Topic: Mainframe Interview Questions (3-5 Years Experience)
- Replies: 4
- Views: 3570
Re: Mainframe Interview Questions (3-5 Years Experience)
DB2Explain the effects of using CURSOR WITH HOLD with GROUP BY and ORDER BY clauses in your queries.
I think we can not use GROUP BY and ORDER BY in the same cursor?
- Wed Apr 24, 2024 12:09 pm
- Forum: JCL - Job Control Language.
- Topic: Return code 1000 in JCL.
- Replies: 2
- Views: 2744
Return code 1000 in JCL.
Hi,
Does any one have idea about rc 1000 in JCL?
Does any one have idea about rc 1000 in JCL?
- Tue Dec 26, 2023 8:51 am
- Forum: Other Mainframe Topics, Off-Topics, FAQs.
- Topic: 🎄✨ Celebrate the Season with Our Festive Forum Makeover! ✨🎄
- Replies: 12
- Views: 6093
Re: 🎄✨ Celebrate the Season with Our Festive Forum Makeover! ✨🎄
Happy New Year everyone!
- Thu Nov 16, 2023 12:20 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: How to get top 5 rows from table thru SQL?
- Replies: 4
- Views: 3014
Re: How to get top 5 rows from table thru SQL?
Hi,
Thanks for the reply. I want to test the query in SPUFI and QMF and later use the query in COBOL program.
Thanks for the reply. I want to test the query in SPUFI and QMF and later use the query in COBOL program.
- Wed Nov 08, 2023 1:18 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: How to get top 5 rows from table thru SQL?
- Replies: 4
- Views: 3014
How to get top 5 rows from table thru SQL?
How to get top 5 rows from table thru SQL?
- Tue Jan 24, 2017 12:24 pm
- Forum: Thought of the Day, General Talk & Jokes.
- Topic: Count to a Million!
- Replies: 234
- Views: 82116
- Tue Jan 24, 2017 12:24 pm
- Forum: Other Mainframe Topics, Off-Topics, FAQs.
- Topic: OS390 versus zOS.
- Replies: 4
- Views: 1121
Re: OS390 versus zOS.
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.
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.
- Thu Jan 19, 2017 3:18 pm
- Forum: Other Mainframe Topics, Off-Topics, FAQs.
- Topic: OS390 versus zOS.
- Replies: 4
- Views: 1121
OS390 versus zOS.
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.
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.
- Fri May 13, 2016 2:20 pm
- Forum: Other Mainframe Topics, Off-Topics, FAQs.
- Topic: LISTDSI in z/OS 2.1.
- Replies: 2
- Views: 479
Re: LISTDSI in z/OS 2.1.
Yes, that's the only option I am also thinking of now.
- Mon May 09, 2016 3:28 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: Solving SQLCODE= -303.
- Replies: 5
- Views: 1064
Re: Solving SQLCODE= -303.
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...
- Mon May 09, 2016 3:26 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: What is the difference between IKJEFT1A and IKJEFT01 in JCL and DB2.
- Replies: 7
- Views: 8620
Re: What is the difference between IKJEFT1A and IKJEFT01 in JCL and DB2.
hmmm,,ok Thanks.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.
- Mon May 09, 2016 3:24 pm
- Forum: Other Mainframe Topics, Off-Topics, FAQs.
- Topic: LISTDSI in z/OS 2.1.
- Replies: 2
- Views: 479
LISTDSI in z/OS 2.1.
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...
- Fri Dec 18, 2015 2:16 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: Solving SQLCODE= -303.
- Replies: 5
- Views: 1064
Re: Solving SQLCODE= -303.
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...
- Fri Dec 18, 2015 12:38 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: What is the difference between IKJEFT1A and IKJEFT01 in JCL and DB2.
- Replies: 7
- Views: 8620
Re: What is the difference between IKJEFT1A and IKJEFT01 in JCL and DB2.
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...