473,320 Members | 1,868 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Any body could help me out on DB2 stored procedure on Z/OS

db2
Hi,
I have heard that stored procedure on Z/OS can be written on
assembler language only. Can any body could help me out on DB2 stored
procedure on Z/OS. If you recommend me any materials, that would be
great helpful for me.

Thanks,
Joseph
http://db2examples.googlepages.com
Jan 9 '08 #1
2 1547
db2 wrote:
Hi,
I have heard that stored procedure on Z/OS can be written on
assembler language only.
This is not correct. You can use pretty much any of the common languages
these days. Have a look at the manuals:
http://publib.boulder.ibm.com/infoce...reexternal.htm

There is a clause LANGUAGE, which must be used to specify the programming
language of the external module (because it determines language
environment, for example).
Can any body could help me out on DB2 stored
procedure on Z/OS. If you recommend me any materials, that would be
great helpful for me.
There is a red book available:
http://www.redbooks.ibm.com/abstracts/sg247083.html

(The book is currently in the process of being updated.)

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jan 9 '08 #2
db2
Thanks a lot.
Regards,
Joseph
http://db2examples.googlepages.com

On Jan 9, 5:58*pm, Knut Stolze <sto...@de.ibm.comwrote:
db2 wrote:
Hi,
* * * * I have heard that stored procedure on Z/OS can be written on
assembler language only.

This is not correct. *You can use pretty much any of the common languages
these days. *Have a look at the manuals:http://publib.boulder.ibm.com/infoce.../topic/com.ibm....

There is a clause LANGUAGE, which must be used to specify the programming
language of the external module (because it determines language
environment, for example).
Can any body could help me out on DB2 stored
procedure on Z/OS. If you recommend me any materials, that would be
great helpful for me.

There is a red book available:http://www.redbooks.ibm.com/abstracts/sg247083.html

(The book is currently in the process of being updated.)

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jan 10 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: berthelot samuel | last post by:
Hi everyone, I am currently trying to write a report based on a View of SQL Server. Basically, I have 3 tables : Hardware, SoftwareInstalled and Software with SoftwareInstalled that keeps track of...
2
by: eczino | last post by:
I currently have a web form posting back to a SQL table using a Stored Procedure. Part of this SP is that it pulls data from another table and inserts a new row into the registration table. I...
1
by: Kumar | last post by:
Hi I am trying to recreate a database under the following environments : From: Solaris with DB2UDB version 7.2 with FP 9 To: Linux with DB2UDB version 7.2 with FP 9 It will be of really a...
2
by: Dino L. | last post by:
How can I run stored procedure (MSSQL) ?
7
by: Siv | last post by:
Hi, I have a stored procedure that I want to execute and then wait in a loop showing a timer whilst it completes and then carry on once I get notification that it has completed. The main reason...
1
by: peaceburn | last post by:
Hi, I'm gonna pull my hair in the coming days with these DB2 stored procedures. So the issue, let's assume a simple stored procedure like this : CREATE PROCEDURE MYSCHEMA.PROCEDURE1 ( )...
3
by: Darth Ferret | last post by:
This thing is about to drive me crazy. I have about 50 queries in the AS400 that I need to put on a menu. Once I conquer this I have a bunch more rpg reports that I need to pass a date to. In the...
17
by: Riaaaa | last post by:
Pls check my code for the stored procedure which i created for the companydetails including companyid P.K. Not Null int(4), companyname Not Null varchar (20), address varchar(30) where...
0
by: SOI_0152 | last post by:
Hi all! Happy New Year 2008. Il hope it will bring you love and happyness I'm new on this forum. I wrote a stored procedure on mainframe using DB2 7.1.1 and IBM language c. Everything works...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.