Recent content by jsplice

Sorry I got caught up in work and never got around to it. I was going to ask how to call a procedure remotely, but there is no clear cut way to do it. I see "Scott Klement" has some uncompleted source on his site that attempts to implement remote procedure calls in RPG. I opted to just...

Thanks for the help. I've put together a program that successfully uses this API. But now I am posing another question. I've created another thread for it. Thanks

No. I want to retrieve locks on a particular file, but not the file locks created by a particular job. This would be the same as if you were to do WRKOBJLCK filename *FILE. You could then do F6 to get a list of specific member locks. It would be nice to record which particular job is locking...

Hello all. I've been trying to find a way to remotely check for an object lock. I've looked through the APIs but haven't come across anything yet that can do this. The reason for needing to do this is that I'm planning to install a lot of indicies to many production files that are locked at...

I can't seem to figure out how to change a job so that it will keep the job log after the job completes. I'm hoping that I can just put the job queue on hold, submit the job, change it, then release the queue. I can't seem to tweak any of the parm in the CHGJOB command to get it to keep the...

Actually I kinda figured this one out myself. It looks like I accidentally omitted the SQLPKG( ) parameter on the CRTSQLRPGI on my install request. Because of this, it appears to have used the default value, which is the library in which the object was created. Our software installation...

I've been trying to create an SQL package on a remote system. However, the command is trying to put the SQL package in strange libraries on the remote system. How does this command determine which library the remote SQL package will be made in? I've tried several different methods but I can't...

I tried both ways and didn't notice a difference in performance between the two. It runs pretty quick using either method, so I think I'm going to stick with *ENDMOD. Thanks for the set option tip; it is much easier to do it that way than have to change the compile parameters during each compile.

Thanks for the link. I actually ended up going with the exit(0) method for ending the program and it seems to work pretty well. I also found it important to add the CLOSQLCSR(*ENDMOD) paramter to the CRTSQLRPGI compile command, otherwise it defaults to CLOSQLCSR(*ENDACTGRP).

Well I appreciate the link, but unfortunately I'm only an "associate member" of that site and cannot view the article.

Well my question from before is negligible if there is a way to exit the program from within a procedure. I know that "return" can be used in either the mainline or in a subroutine to exit the program; but if it's used in a procedure, it simply returns control to the caller. I don't really...

I want to make some procedures that can accept parms and will do simple embedded sql functions such as open and close a cursor, and fetch. I want to do this so I can clean up the way my code looks. Because SQL errors don't always cause a program to end when it should, I had to incorporate some...

Hello all. I'm trying to run a query that pulls data from two files. One of the files is going to be on the local system in which the program is running, and the second file will be on a remote system. The query looks like this: SELECT A.CUSTNUM FROM LocalFile A...

Thanks for the replies everyone. I managed to get this working finally and it was definitely needed.

Nevermind, I had to change the user from mine to SISADMIN because that's what the job runs under. I am now in a debug session in WebSphere. This is pretty neat and a LOT easier than what i was trying to do before. However, I have run into another problem. When I set the service entry point...