× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Based on my other post, I dumped my compound SQL statement into a
stored procedure so that I could run it through the SQL interactive
debugger. What I found is that a PREPARE statement is failing (based on
message SQL0204 in the joblog) but the SQL state is coming back as all
zero. Thus, my code goes on to EXECUTE the prepared statement and fails
with SQL state 07003 because the statement didn't actually get prepared.
How can I resolve this?

Basically, this code is checking to see if a file is in a
particular library, and if it is not, it is supposed to loop to the next
company and check again.

Begin
Declare Continue Handler for SQLSTATE '42704' Begin End; -- notfnd
Set ErrText = 'Checking for LIFO Details backup failed.';
Set CompanyNo3 = SubStr(CompanyNumber,3,3);
Set SqlStmt = 'Values('
||'Select 1 FROM LIFOLIB/IMLFDTL'
||CompanyNo3
||' Fetch First Row Only'
||') Into ?';
Prepare CheckBackup_Stmt
from SqlStmt;
Get Current Diagnostics Condition 1 CurState = Returned_SqlState;
If Substr(CurState,1,2) <> '00' Then
Set BackupPresent = NULL;
Else
Execute CheckBackup_Stmt
using BackupPresent;
Get Current Diagnostics Condition 1 CurState =
Returned_SqlState;
If Substr(CurState,1,2) <> '00' Then
Set BackupPresent = NULL;
End If;
End If;
Release CheckBackup_Stmt;
End;

If BackupPresent is NULL Then
Iterate Company_Loop;
End If;


Sincerely,

Dave Clark

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.