I am trying to create a stored procedure on z/OS DB2. After the create runs successfully, what is the next step so that DB2 knows it's there? When I run a program with sqlexec invoking a the stored procedure, it says it can't be found.
Here is the stored procedure.
create procedure...
On Unix (AIX)
How does one create a user 'inside' DB2?
New to DB2 and would like to do this..
Another question: If I have a OS level user with DB2 Admin privileges, would this suffice without having to create a user 'inside' db2?
Hi,
I have written scripts before, but I am not a full timer script person anymore and I have forgotten so much. It has been over 24 months since I touched a script. I am starting from scratch here.
I would like to create a shell script that will gather CPU, Memory, IO, and other performance...
Hello..
Can somebody please assist me here?
My goal is to have a sql script that will parse a DB2 schema and help identify the following:
NOTE: I HAVE ONE (WORKING SQL SCRIPT) FOR ORACLE AND IT WORKS, BUT WHAT SQL SCRIPTING DIFFERENCES WILL I HAVE TO ACCOUNT FOR, FOR DB2 UDB.
My goal is to...
Hello
Below is a snipit of shell script and the process works, but was wondering the chmod part is not working.
if test ! -f /var/logs/collect$month.log
then
touch /var/logs/collect$month.log
chmod 662 /var/logs/collect$month.log
chown userid:usergroup /var/logs/collect$month.log
Also..
I...
I was wondering if any of you had tried any exisiting php built Admin Panels that I can use. I would like to use it to upload pictures and update news via an admin panel.
Are any of you using one already that you copied from some trusted online source? I have googled this, but thought i would...
I am trying to create a website for a Church. What I want to do is make it a 4-8 page website with basic information. I do not have frontpage, so I am doing this from scratch. Any help is greatly appreciated.
I can't find the terms that it would take for me to do this.. Terms meaning the...
Hello All,
I have a parsing question. I have a formated report that I need to parse through and extract certain pieces of the text file.
Firsl of all, I am new to Perl, and I am not sure where to begin.
What I would like to do is:
1. Create a GUI interface so users can input where their...
I have an extensive output file <report> that is built on our z/OS using some jcl, and I can with success send this report to my pc as .txt file, but it is ugly.. I tried to export this file into excel, but my end goal is to only grab a few pieces of information from this lengthy report.
Okay...
What is the VBA code/method to parse an excel worksheet.
I am searching in various places to find the code/method to parse worksheet1 and once the specific keyword is found, I need to grab what is after the keyword and a comma and two spaces <example: Keyword, 12345.34>. And place 12345.34...
Hello All,
I have this txt file that I am trying to import into an excel file. I only need bits and pieces of info within this txt file. Here is a sample of what the txt file that I need to import looks like: How to I pars this file on a windows platform. Or is there some VB code I can use...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.