Search results for query: *

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

...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 a member in the...

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.

...sql Open Generic_Cursor; CheckSQLErrors(); PCheckSQLErrors B /free If SQLSTT <> '00000' and SQLSTT <> '02000'; RegExcpHandler('SQL0000':*ON:*OFF); ThrowAndCatch ( SqlMsgid(SQLCOD): *OMIT: SQLERM ); *INLR = *ON return; //**EXIT PROGRAM EndIf; /end-free P...

...I then force the program to quit, which must be done from the mainline (as far as I know): Exec sql Open Generic_Cursor; If CheckSQLErrors(); *INLR = *ON; return; EndIf; PCheckSQLErrors B D PI N /free If SQLSTT <> '00000' and SQLSTT <> '02000'...

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.

...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, I get an error on opening of a file because of UPDPRD(*NO). How can you change this for service entry points? Thanks

I just tried doing that and it didn't work. The job started in batch but nothing happened in RSE. I know this works for interactive programs because I've used it before, but I didn't know you could use it for batch debugging. Am I doing something wrong here?

I have a transmissions job that I'm testing on the target system (this is using the old style ICFF files and separate transmission jobs on the sending and target systems). I need to debug the target program which is being submitting into batch by the job running on the sending system. While...

That actually sounds like a good idea if it will work. I've never made a join logical before. Basically what I have is one file that is my main data file that is going to used on the report. This file only contains the region number and facility number, and not the division number. So what I...

I'm not so sure that a data queue would work. I need to have this file sorted by several more fields, not just the division. Sorry for not specifying that earlier.

Hey everyone. I'm trying to think of ways to simulate a workfile without actually creating a physical file on the system. I've used arrays and data structures in the past, but that was for small amounts of data; the file I am processing now will most likely have 10s of thousands of records, if...