ZOS DB2 - Stored proceedure with both language SQL and Cobol

mahesh_terdal · #1 (**permalink**) 02-02-11, 08:14

Hi ALL,

One of our client is unable to execute the standard SQL scripts on their ZOS DB2, it is because our scripts make use of stored procedure and uses "lang=SQL"

in their environment they have lang=COBOL.

See the note from them.

>>As a standard we use external STORED PROCEDURES (SP) with language COBOL.
>>To create SPs with lang=SQL we need to set up the environment accordingly

We cannot test this as we don't have ZOS.

Can you guys please help us what tweaking measures should be takes in such scenario's.

Any help will be highly appreciated.

Thanks and Regards,
MAhesh

sathyaram_s · #2 (**permalink**) 02-02-11, 09:10

What version of zos db2 are you on?
Read the part of sql stored proc requirements for that version.

in v8 for example, you need C compiler to create sql procs ... not sure how it is in recent versions

DB2 V8 - Application programming and SQL - Preparing an SQL procedure

hth

sathyaram

mahesh_terdal · #3 (**permalink**) 02-02-11, 09:21

Hi sathyaram,

Great Thanks!!

They are on V9 these things still valid?

Thanks and Regards,
MAhesh

sathyaram_s · #4 (**permalink**) 02-02-11, 09:42

As I mentioned before, I am not sure about recent versions. Do you expect me to find the information for you?

report back if you find the answer please.

mahesh_terdal · #5 (**permalink**) 02-02-11, 09:44

Well certainly not !!

Thanks anyways

Stealth_DBA · #6 (**permalink**) 02-02-11, 13:07

With V9 z/OS, you do not need a C compiler. You can create Native SQL stored procedures or you can create external Stored procedures.
DB2 9 - Administration - Creating stored procedures

mahesh_terdal · #7 (**permalink**) 02-03-11, 04:40

Thanks for that info.

dr_te_z · #8 (**permalink**) 02-03-11, 06:49

Quote:

Originally Posted by mahesh_terdal

We cannot test this as we don't have ZOS.

As long as you are in the phase of developing & unittesting you do not need a mainframe. Just install db2-express-c and open-cobol on a linux machine and start coding your COBOL with inline SQL source. You can db2-precompile/compile and bind like you are used to and test you modules by just calling them. (a cobol SP has exactly the same syntax as a "normal" cobol sub-program). This approach forces you to code in standard cobol-85 syntax... I would not call that a disadvantage

When you reach the system-test phase you'll need the mainframe...But your work as a programmer is done.