Mainframe, MVS and zOS Discussion

Which term is used to mean hard-coding of SQL in cobol? Could someone guide please.

The term I've always heard and used is "embedded SQL". It's used for C, PL/1, assembler, etc as well and it's certainly the term used in the DB2 manuals. There are two forms. "Static" refers to having fixed SQL statements that can be handled by the precompiler (which gives a performance benefit). "Dynamic" is where the statements are built at run time.

Thanks zum13. So hard coded is 'embedded SQL'? That's what you mean?

Yes. Any time you've got an "EXEC SQL" in a program, you've got embedded SQL.

I replied the same in my interview, though not the exact word. But he didn't agree with me.

That's what embedded SQL has meant since I started working with relational databases, and I go back to 1986 and SQL/DS (which is what DB2 for VM used to be called). According to the current DB2 manuals, it's still called that today...

https://www.ibm.com/docs/en/db2-for-zos ... rogramming

I'd be disagreeing with the guy who disagreed with you!

I think the question is about 'hard coding' and not 'embedded', interviewer was not wrong.