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
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
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
Don't get confuse with STMF. STMF is just stream file. If you have uploaded the txt file then you should be able to see the .txt extension and should be able to open it using option 5.
Thank you for your video, your explanation is very educational and the examples are very good.
Thank You. Keep up with your passion and commitment to make these great video's
Very much useful content. Thank you.
Good work Yusuf. Concepts are explained in easy language.
Thank you Mohammed, very good and usefull
Nicely Explained
Useful information Bro
Its really good for beginners. Explained it very well. Kudos!!
Thanks for ur feedback
Thanks a lot for all the videos brother. Very much useful..
Syed Faisal thanks bro...
Thank you for the great video!!! I needed to refresh my knowledge on this subject and really enjoyed your video!
muchas gracias por esta gran ayuda!!
Bienvenido
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
Can we use more than one field in place of empsal in select query inside cursor?
Thank you for this interesting video Yusuf!
If I want to run the stored procedure for create a sample database from IBM DB2:
Hello Yusuf
Can you please advise how can I check what statements are written in a stored procedure
Hi, is there something like rowid in as400 database??
Hello, where can I get a tutorial for DB2 in As400 right from basics
Hello Yusuf, Is there a way to debug the Stored Procedures?
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
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
I tried the same steps and got the result as 0.how do I debug a stored procedure.?
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 ?
Ok.. I will do it soon...
What is PF?
any examples on remote database connection from AS400 to another database?
Checkout RUNRMTCMD. If you just want to get data from one DB of another AS400 then try DDM.
Sir, could you please explain what is commitment control and importance of it. Thank you
This could help you
m.czcams.com/video/_4GwqDfXfRI/video.html
Hi Yusuf,
How do you upload a file as a txt file to AS400
i do it through FTP and it comes as a stream file?
gumbystern you can watch my below video for this
m.czcams.com/video/_fk_ECaTQqQ/video.html
@@yusy4code When i upload through FTP my files just come as stream files , STMF files not txt
Don't get confuse with STMF. STMF is just stream file. If you have uploaded the txt file then you should be able to see the .txt extension and should be able to open it using option 5.
@@yusy4code ok i will check again, i am uploading this to home/USER0270 , it has STMF as the file type. i will look again at this
If you have confusion use below command
WRKLNK OBJ('/home/user0270') DETAIL(*NAME)
Please make video on BRMS Network
Sorry Akshit, I have not worked on IBM Administration.
mohammed yusuf m ok thanks for reply but can you please ask someone to help me on this😟
May be this video helps you.. czcams.com/video/tn9xz1SpuyE/video.html