Mainframe, MVS and zOS Discussion

Yes it will be closed as it will be considered as single unit of work. It's in similar way if you have abend in sub program and you are performing a roll back it will roll back changes done until last commit irrespective those were done in main program or sub program.. what happened when you tried? ...

Hi,
If you asking about interactivd spufi then you have option to change record length on page of spufi where you provide the output dataset or next page which appear just before the page for query writing

Thanks and regards,
Chandan

I have used IBM Data Studio for testing Native Stored procedure

Thanks and regards,
Chandan

IEFBR14 called as dummy utility because it almost do nothing. Please refer the link


https://www.ibm.com/support/knowledgece ... EFBR14.htm

Thanks,
Chandan

One reason I can see is the volume on which you trying to allocate the fine does not have space.

Experts.. correct me If I am wrong

Thanks,
Chandan

Well done Enrico

Thanks Robert for the details explanation

not sure if you are looking for below command

Hi,

Type KEYS on command line and assign START command to any of the PF key.
After pressing that Assigned PF key a new window will open

I hope this is what you looking for

Thanks and regards,
Chandan

Hi, @ Manju are you saying We need to the select column names when we use ORDER BY is the conclusion.? If yes then its not the case always. For first case its not required to be a part of result table but it should be identified as the column of table Try to execute the queries with having order by ...

You can have Db2 instance on local machine check for Db2 Express edition n test it out. Joins works same if you doing it on local machine or on mainframes.

As Enrico said if you are a developer you should have access

Hi,

How you are going to decide which record of file 2 you are going to consider for populating it in File 1?

Thanks and regards,
Chandan

Try out some examples execution in Spufi or QMF you will get better understanding

SORT Join would help you. Check for JOINKEYS in DFSORT manual.

But yes as Anuj said,before we would like to know the sample records and DFSORT product

Thanks and regards,
Chandan

Totally agree with you William

By Any chance if interviewer asks how to bypass very first step in JCL using COND parameter , answer is use COND=ONLY

Thanks,
Chandan

I also worked with RDz sometime back and that time code repository was on Z/os not sure how it is handled now. In my latest shop we are in process of implementing Micro Focus which is very much similar to Rdz. THe one biggest difference which is very cost effective is code base will be on Cloud syst...

Hi,

Just though of starting a topic to throw some light on Microfous and RDZ.

If any one working or worked on these can elaborate on these tool and their pro and cons?

Thanks and regards,
Chandan

Thanks Anuj..Its working with New username

Hi,

is there anyway to change the username to login?

Like I want to change username to Chandan Yadav from chandanydav

Kindly guide me with the process

Thanks,
Chandan