On Java Development

All things related to Java development, from the perspective of a caveman.

Archive for the ‘Spring stored procedures’ Category

Calling Stored Procedure SECGETUSERROLES

without comments

Introduction

This post shows how to use the stored procedure SECGETUSERROLES. This stored proc is designed to return records created by a join of 4 files. The record provides information about a discrete user’s role for a given application. This information can then be used to control the behavior of the application.
Read the rest of this entry »

Written by admin

October 3rd, 2014 at 8:03 am

Using Spring to call a Stored Procedure

without comments

Introduction

This post shows how to leverage Spring to call a stored procedure to retrieve a result set or update records in a file. Spring makes the process simple enough so that the developer is focused more on the parameters to pass (if any) and calling the methods of the project’s Service and DAO layer.
Read the rest of this entry »

Written by admin

June 4th, 2014 at 4:52 am

Calling RPG or CL Programs with SETLIBLEXEC

without comments

Introduction

This post shows how to call RPG and CL programs using SETLIBLEXEC which is a stored procedure residing on the iSeries (only in QGPL). SETLIBLEXEC accepts parameter values for the environment name of the library list to be used when it runs the name of the program to be called and the parameter values needed by that program.
Read the rest of this entry »

Written by admin

April 3rd, 2014 at 1:42 pm