Mainframe, MVS and zOS Discussion

Can I drive a car at 300 km/hr?

The answer is yes, you can. Your mileage (Yes, you read it correct, Your mileage, not of car) may vary!

Is it advisable?

No! per traffic rules, per common sense - no, the answer is no.

Can I still do it?

Yes you can. Society has police. Shops have DBAs and ...

As such you can use a COBOL equivalent copybook instead of DCLGEN member, compiler does not stop you, pre-compiler does not stop you. But you are introducing more maintenance work for yourself,in future. Another mistake which might happen is you might end up using COPY statement for the DCLGEN ...

I guess, from carefully reading what Pandor-Box wrote, that what is being said is that if you do not use the pre-compiler generated copybook but use a hand-crafted copybook then, if the pre-compiler creates an updated copybook the change may not be noticed and therefor not made to the hand-crafted ...

Thanks for the answers. It was really a tricky one!

Pandora-Box wrote:Also what if you need to change the DCLGEN member value there is a possibility the direct declarations could be missed in direct declarations

I am sorry what are you saying? I did not understand this.

I could not ask this way to an interviewer. But I think answer is that it saves from copying all the contents manually.

Another which I face goes like this, if i have a DCLGEN member called DCLMEM. I will use this in my program as

EXEC SQL
INCLUDE DCLMEM
END-EXEC.

Q1. Can we write the equivalent of the DCLGEN DCLMEM in cobol terms instead of using

EXEC SQL
INCLUDE DCLMEM
END-EXEC.

Q2. If yes, then ...

Hi,

I was give thie query:

select * from emp where 1=1

and

select * from emp where one=one

and the qustion asked was - If we have some details in a DB2 table and we use a query as listed what will be the result?

I replied the answer will be same...but they said I'm wrong. Can someone ...