MVSFORUMS.com

[ANDY]

Hello:

When we access db2 we can using Embedded SQL or DB2 API. What's the rule to choice them? What's the difference ?

Thank you

Andy

[kolusu]

Andy,

API(Application Program Interface) is functional interface supplied by the operating system or by a separately orderable licensed program that allows an application program written in a high-level language to use specific data or functions of the operating system or the licensed program.

SPUFI(SQL processing using File input) and QMF(Query Management Facility) are a few examples of API. Both of the above mentioned products are interactive.

If your requirement is to just browse/generate simple reports the data in a DB2 table then you can simply use SPUFI or QMF.

Embedded SQL's are used to access DB2 via program where you browse/modify the data based on your business requirement.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[ANDY]

Hi Kolusu:

Thank you for your explantion.
But as I know, DB2 API can still be used to access DB2 by calling their function via program like Embedded SQL. I want to konw when we use it.

Thanks

Andy
_________________
cheers,
Andy