SQLCODE = 1077952576

940 pts.
Tags:
iseries v5r4
RPGLE
RPGSQL
V5R4M0
All-

I'm getting the above error code from an RPGSQL program. This is just after a DECLARE statement. Other fields in the SQLCA are blank. I can run the statement in Interactive SQL w/o errors.

I should be getting a small subset. I get 0 records.

Any Ideas?  It's not in the SQLCODE finder.

Phil



Software/Hardware used:
iSeries V5R4M0

Answer Wiki

Thanks. We'll let you know when a new response is added.

Note that dec(1077952576) = hex(40404040).

Tom

“Very interesting” (said in a German accent.)

Discuss This Question: 9  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    I think you might have looked at this value at the wrong step. My guess is you got zero returned records because that was the result of your query. Perhaps if we see the code ...
    51,355 pointsBadges:
    report
  • MurrayInfoSys
    Code:
    Declare C01 cursor for                                       
     Select INWIP100.Activ, MSPMP100.Activ, INWIP100.PrdNo, House
             WIPID, INWIP100.SgVnd, MSPMP100.Obsol, INWIP100.MinB
             INWIP100.OrdPt, INWIP100.LeadT, INWIP100.Buyer      
       FROM INWIP100 inner join MSPMP100                         
         on INWIP100.PrdNo = MSPMP100.PrdNo                      
                                                                
        WHERE MSPMP100.ITTYP = :ITTYP    and                     
              House = :House and WIPID = :Planner                
    EVAL ITTYP ITTYP = 'B' EVAL House HOUSE = 'AD' EVAL Planner PLANNER = 'PLINE '
    940 pointsBadges:
    report
  • philpl1jb
    So you're saying that the variables have their values Then you declare the cursor Then you open the cursor Then you fetch the cursor into ... and you get no records ??? what is the SQLCode and other values when you do the fetch? Phil
    51,355 pointsBadges:
    report
  • TomLiotta
    If all that's happened so far is the DECLARE, then I wouldn't expect anything in any SQLCA value to be populated yet. Nothing SQL has executed. The DECLARE is really only for the pre-compiler to generate its structures. AFAIK, until you at least OPEN the cursor, no actual SQL has executed. No status or code exists yet. Tom
    125,585 pointsBadges:
    report
  • MurrayInfoSys
    HUuummm ... I thought that the Declare statement loaded the variables and did some basic error checking.. Thanks. I'll run the code again and keep that in mind. Dang, makes sense. PS: Tom - > Programming since unit-record machine days Does a 026 or a 82 or a 1402 ring a bell?
    940 pointsBadges:
    report
  • MurrayInfoSys
    AFAIK means?
    940 pointsBadges:
    report
  • TomLiotta
    Does a 026 or a 82 or a 1402 ring a bell? Yep. The 1402 was almost as big as the 1401 next to it. Hard to imagine nowadays that the 1401 was an 8K box; we had a 4K expansion unit to bring us up to 12K. Eventually, the 026s were replaced with 129s. We already had a couple 029s, so getting the 026s totally gone made a real difference. (About as much as moving from the 10CPS TTY remote terminal connections up to 30CPS! Wow!) AFAIK means? AFAIK, "as far as I know". Tom
    125,585 pointsBadges:
    report
  • OleVillumsen
    I had the same problem and solved it.
    I had commented out an embedded SQL delete statement from a PL/I program. I assumed that sqlCa would then remain untouched, so I left the check on sqlCa.sqlCode. However, this turned out to be 1077952576 or the same as hex 40404040. Apparently someone had filled my sqlCa (or at least the sqlCode field) with spaces (the space character is hex 40 in ASCII). So I had to comment out the check too. Or comment the delete statement back in.
    10 pointsBadges:
    report
  • OscarOrtizM
    You are missing the "open cursor" statement
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following