Mainframe, MVS and zOS Discussion

HafeezAkmal

Thanks Robert and Anuj.

HafeezAkmal

Thanks Anuj and Pandora. I used your query and it's working Anuj!

Thank you!

By the way, With ROW-ID, will there be an additional overhead, just thinking...

HafeezAkmal

Hello,

Does someone have any good material on ITIL certificate? It'll be a great if you can share one.

Appreciate your kind help in advance.

HafeezAkmal

Thanks Anuj. Yes, I need the answer for DB2. Please help.

We're at DB2 10. I can not access the mainframe as of now but the error was something that keyword is not recognized.

HafeezAkmal

Hi,

I was just searching for a QUERY which gives me the Nth Max sal of an employee. And found this:

Code: Select all

select max(sal) 
from emp 
where level = 10 
connect by prior sal > sal 
start with sal = (select max(sal) from emp)

I'm confused how this query works? Can somone please help me with this.

HafeezAkmal

Hi,

As in case of a COBOL DB2 program we include SQLCA and DCLGEN member etc. in program, which tells about the structure of the table to program however while using VSAM what we do? Can we generate the layout of the VSAM likewise?

HafeezAkmal

Via Google.

Mainframe, MVS and zOS Discussion

Search found 7 matches

Re: COBOL VSAM and DB2.

Re: "N"th maximum Salary and SQL Query.

Preparation material for ITIL certificates.

Re: "N"th maximum Salary and SQL Query.

"N"th maximum Salary and SQL Query.

COBOL VSAM and DB2.

Re: How did you find us?