Re: SQL issues in program

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Kelly, what's the status of the job that is hung?  If you look at the 
job in WRKACTJOB is the status LCKW?

Joe

> Hello,
>
>
>
> I have an SQLRPGLE program that first calls a procedure to insert records
> into File A. I then have another procedure that is called repeatedly for
> different files. This procedure uses dynamic SQL to insert records into
> different files using certain criteria along with File A. Then it uses
> dynamic SQL to delete the same records it inserted, also using File A.
>
>
>
> My program will run okay for a few files, then it just hangs up on the
> insert or delete portion of the SQL. I have put it in debug and it remains
> on the execute statement, it isn't looping within the program. There is
> nothing changing in the call stack or open files. I removed the file it got
> hung up on and ran it again. It will run then it will hang up on a different
> file.
>
>
>
> Is there something specific that needs to be done in my program to allow it
> to properly handle repeated dynamic SQL's? I can include portions of my code
> if helpful. I am not using cursor open/close. I just have Prepare and
> Execute statements.
>
>
>
> Any help would be appreciated.
>
>
>
> Thanks,
>
>
>
> Kelly