Stored procedure content

Is there a way to "retrieve source" on a Stored Procedure ?  I need to find out what 2 of our Stored Procedures do - especially what programs thay call. Of course, no documentation and no methodology for source-based creation.  

aceofdelts2,465 pointsBadges:

AS/400 Program To List Physcial Files with Deleted Records

We currently have a program to list Physical Files with Deleted Records. The CLP utilizes the DSPFD command to build an out-file. The parameter for 'Type of Information' is *MBRLIST and 'File Attributes' is *PF. However, the out-file lists the data at the member level. Also, teh job takes TOO LONG...

Jmnram40 pointsBadges:

How to parse a file for a specific pattern?

Hello! i'm new to AS400, and I've been trying to figure out for the whole day how to have the similar behavior as the following unix command: grep "pattern" my_file exit $? 1) Grep a pattern in a log file 2) exit OK (or echo OKmessage) if the pattern is found,      exit NOT OK or echo NOT OK...

Psjylife25 pointsBadges:

CGI loses percent sign

We have a web app ( a CGI) written in RPGLE and HTML that prompts for several data fields and writes a record to our web iseries. When the Comments field contains a percent sign ("%"), the data file ends up without that symbol and the next character is gone, too. Is there a simple way to fix this ?...

aceofdelts2,465 pointsBadges:

Auto reply for end of forms message PQT4103

Printers send to operator: [strong]Message ID . . . . . . :   PQT4103       Severity . . . . . . . :   99       Message type . . . . . :   Inquiry                                           Date sent  . . . . . . :   10/27/09     ...

Bigmac461,000 pointsBadges:

iSeries

what is mean by "CHANGEMANAGEMENT TOOL"?where we can use this and why we want to use this?Please give me with example?

Girilakshmi50 pointsBadges:

Message Queue

Lets say a user "accidently" sends the wrong message to a user. How can an administrator go into that message queue while its being used and delete it. This can be done when the user is signed off but now while in use. A sensitive message was sent and it needed to be deleted. I told them not to use...

RonKoontz1,810 pointsBadges:

calling a URL from RPG OR CL

I would like to call a html. page from either a RPGLE or CL program.

Andyguad5 pointsBadges:

Cost per GB of disk for iSeries? Please could some one help me on this.

Cost per GB of disk for iSeries? Please could some one help me on this.

harisudhan211,005 pointsBadges:

RPG vs Java vs Others

Hi, With the possibilities of using all sorts of C and Java type functions now available in RPG and bearing in mind that (in my experience) Java is difficult to tune to perform reasonably on the i-Series is there any benefit for an RPG programmer to learn Java? Or would some other language be a...

Gilly40023,730 pointsBadges:

HOW TO MAKE A PRTFILE – COBOL CODE

HI, THANK you very much, your opinions always are good. In fact i found one right. However i havea point  and i'd like to check. how to make a cobol program using a prtfile?    Regards. Sylvana :)

Sylvana185 pointsBadges:

Order in which security is checked

When accessing an object what is the order in which the security on the object is checked? Does it check the profile user class first then group authority, then private authority ?

Alison88380 pointsBadges:

Ability to change a users password

Without making everybody *secadm to have the ability to change the user's password and reset a disabled user. We have a program to reset the user but not the password. I need some information on how to to this.

Curtiss10 pointsBadges:

How to upload files from windows 2000 to i-series .

I need to upload .csv files to iseries. These files are residing on windows 2000 system. Will appreciate any help with this regard. TIA.

Manish1230 pointsBadges:

Setting up AS400 User Profile

Currently, our users all have command line access and they have figured out how to change their batch jobs to run in another job queue. I set up a test user with user class=*user, limit capabilities=*yes and special authority=*no. However, the user can still change his jobs to run in another queue...

GHENDER220 pointsBadges:

iSeries Object Authority vs. Menu Security

Hello, I am new to iSeries and OS/400. Here is my question: Let's say in a level 30 security environment, user access is controlled through a menu, which does not alow them to access any sensitive objects. But a number of sensitive objects have been assigned *ALL authority for *PUBLIC. Can these...

Mimia5 pointsBadges:

Retrieve the RPGLE program from object

Hi all, I accidently deleted my program. Is there any way to retrive the program from its object.

vipin2m55 pointsBadges:

The most-watched IT questions this week: Nov. 3, 2009

Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...

Michael Morisy8,643 pointsBadges:

AS400 user profile and owned objects accidentally deleted

A critical AS400 user profile and all owned objects were accidentally deleted from the system. Is there a way to identify and restore the profile and all owned objects from a full system21 save to tape to the 400? Any help would be greatly appreciated. Thanks.

Crazyrosie0 pointsBadges:

AS400 configuration management tools

I am new to AS400 platform, and looking for a tool that will allow me to monitor configuration changes on multiple as400 servers and report daily on configuration changes per box and per aome sort of baseline. Any help will be greatly appreciated.

AWHITSTON0 pointsBadges: