db2 dbvisualizer create stored procedure

#Db2 dbvisualizer create stored procedure pro#
#Db2 dbvisualizer create stored procedure professional#

Roles, Responsibilities and Accomplishments Improve the ways of interaction and streamline communication with other applications like ordering and provisioning systems.

To migrate several legacy billing systems into the Next Generation system model provided by the Business and consolidate billing programs into a generalized way easier for scaling up and maintaining. Verizon's global network includes over 800,000 route miles, including terrestrial and undersea cable, spanning six continents. Verizon has more than 180,000 employees and has global operations, with more than 200 data centers in 24 countries.

Verizon Communications, branded as Verizon, is an American broadband and Telecommunications Company and a corporate component of the Dow Jones Industrial Average.

#Db2 dbvisualizer create stored procedure professional#

Professional Experience: Verizon, Boston, MA.

Other Tools : DB2 Utilities, SORT Utilities, ENDEVOR, CRISS, TSO/ISPF, MQ Series, IBM SPUFI, QMF, INSYNC, FTP, NDM, Lotus Notes, MS Excel with VBA, MS Word with VBA, MS Outlook with VBA, MS Visio, MS PowerPoint, SAR, DB Visualizer, HP Quality Centre, Eclipse, Adobe PhotoShop, Adobe Java Scripting, XAMPP.

Database : DB2, VSAM, MS Access, MySQL, Teradata, IMS DB, XML, JSON.

Web Technologies : Java, HTML, JavaScript, PHP, AJAX, Spring, Swing, Struts, JQuery.

Programming Languages : COBOL, JCL, PL/1, REXX, CICS, EZtrieve, VB Script.

Excellent interpersonal skills, strong communication and presentation skills.

Highly motivated team player with immense ability to grasp new concepts and apply.

Worked as Programmer, Analyst and played a Team Leader.

Proficient in QA Testing, Test Plans, Test Scenarios / Test Cases and documentation.

Responsible for maintaining and support production systems at different clients by 24X7.

Experience on traditional Waterfall model as well as the emerging Agile Methodology.ĭesigned and developed complex reports for the business purpose.

Actively looked for scope of Automation in various time consuming tasks and developed tools using REXX and VBA.

Infosys Certified in Mainframe Technology Level 1 and Level 2.

Infosys Certified in Retail Domain Retailing Level 1, Consumer Product Goods Level 1, and Merchandise Management Level 2.

IBM Certified - Database Associate DB2 9 Fundamentals, Solution Developer DB2 9.5 SQL Procedure Developer and Application Developer Programming with Enterprise PL/I.

Experience in Web Applications using Java, JavaScript, Spring, Swing, Struts, AJAX, HTML, MySQL, PHP, SOAP, JQuery.

Proficient in DB2 SQL, PL/SQL, Embedded Programming, Utilities, Stored Procedures and other supporting tools like SPUFI, INSYNC, EXPLAIN and DBVisualizer.

Comprehensive experience using Structured Methodology covering entire life cycle of the system in Mainframe applications of Retail Industry and Telecom Industry billing systems.

Over 6.5 years of work experience in Requirements Gathering, Analysis, Design, Development, Testing, Implementation and Maintenance.

Which is correct, because the table is empty. 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.019/0.000 sec However, if I open a SQL commander tab instead, type the 'DB2RN'.'DUMMY_EXP1'()Īnd click the green triangle there, I don't get any error message, butġ2:26:27 - 0 row(s), 0.019 secs] Command processed. When I click it, I get the error messageġ2:27:06 - 0 row(s), 0.000 secs] 1) DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=DUMMY_EXP1 PROCEDURE, DRIVER=4.13.127. Inside the Procedure Editor Tab, I find a green triangle which, when I hover over it, I see 'execute stored procedure'. Using 'StoredProcedures/Create Stored Procedure', and the Procedure editor, I made a simple procedure without parameters:

#Db2 dbvisualizer create stored procedure pro#

(I am using DbVisualizer Pro 9.0.9 running on Windows 7, connecting to DB2 9.5.7 please note that while I'm familiar with DB2, I have no previous experience with DB2 and DbVisualizer)