December 7, 2020 at 10:27 pm
Sorry for posting this here... tried in the DB2 section but no joy. So I'll keep it short - I can write stored procedures in T-SQL to receive parameters and do spatial comparisons etc. Is there a good tutorial anywhere for SQL Server people that covers writing stored procs in DB2? I've looked and as yet haven't found anything. Most point to IBM websites and their examples are paltry at best.
December 8, 2020 at 11:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 10, 2020 at 4:20 pm
You could try posting here:
https://code400.com/forum/forum/iseries-programming-languages/sql
Not a lot of traffic, but a few very knowledgeable people.
December 10, 2020 at 8:50 pm
I'll give it a try... did an initial search for "stored procedure" + db2, and came up empty.... so I searched for just "DB2"... also empty. =(
Maybe IBM doesn't like people using their database engine?
I already wrote a stored procedure in T-SQL and it works... I was just trying to port it to DB2. Oh well.
I guess if you bring a lot of water, you can read through the super dry documentation...
Case closed, I guess.
December 11, 2020 at 11:02 pm
I'll suggest the following search...
https://www.google.com/search?create+a+stored+procedure+in+DB2
--Jeff Moden
Change is inevitable... Change for the better is not.
December 12, 2020 at 12:12 am
Jeff,
Yes, I did that... Found a bunch of stuff from IBM's website. Not much of it is terribly helpful, though. That's why I was asking here. There's a little on youtube, too, but I'd rather read it.
December 12, 2020 at 3:17 am
Ah, gotcha. I found the following in another search. Will this help?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply