Introduction to SQL - Stored Procedure in IBM i (AS400) | yusy4code

This video explains the basic concept of SQL stored procedure and how to create and execute that in IBM i (AS400) server.

[rmite]

Thank you for your video, your explanation is very educational and the examples are very good.

[venkatpullalarevu]

Good work Yusuf. Concepts are explained in easy language.

[benp]

Thank You. Keep up with your passion and commitment to make these great video's

[giovavalencia]

Thank you Mohammed, very good and usefull

[gamerboy]

Its really good for beginners. Explained it very well. Kudos!!

[Svetlana]

Thank you for the great video!!! I needed to refresh my knowledge on this subject and really enjoyed your video!

[syedfaisal]

Thanks a lot for all the videos brother. Very much useful..

[higiniofuentes]

Thank you for this interesting video Yusuf!
If I want to run the stored procedure for create a sample database from IBM DB2:

[RishiLabs]

How to write a stored procedure for ibm db2 luw that contains delete commands; insert into select commands and at the end select query that returns result set

[sbmahapatra]

Hello Yusuf, Is there a way to debug the Stored Procedures?

[saathana]

How to compile or save that text file to use? I too created text file in wrkmbrpdm but after created it not sure how to use as I haven't saved or compiled to make it as object. Plz help

[kashifkamran]

Hello Yusuf
Can you please advise how can I check what statements are written in a stored procedure

[arumugaraj]

Can we use more than one field in place of empsal in select query inside cursor?

[dreameronbike]

Hello, where can I get a tutorial for DB2 in As400 right from basics

[halkapadvin]

Hey Yusuf,
Thanks a lot for the video. Can you please explain one Stored Procedure which has result set and if we can call the same SP from STRSQL ?

[spv]

I tried the same steps and got the result as 0.how do I debug a stored procedure.?

[babuganesh]

i have following stored procedure in db2
create or replace procedure customer_p(in cids int )
RESULT SETS 1
language sql
begin
declare cursor1 cursor for
select cid from customer
where cid > cids ;
open cursor1;
end
when i call this using " call customer_p(5); "


it throwing me following error


call procedure customer_p(5)
Error report -
DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=procedure;BEGIN ;RETURN, DRIVER=4.25.13


help me solve this issue

[geethikaganesula]

Sir, could you please explain what is commitment control and importance of it. Thank you

[chetan]

Hi, is there something like rowid in as400 database??

[danieljones]

any examples on remote database connection from AS400 to another database?