Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Embedded SQL Retrieve Mystery

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    Embedded SQL Retrieve Mystery

    Sorry, Here's a more formatted version of the dump info:
    Code
    Tags: None
  • #2
    Embedded SQL Retrieve Mystery

    First, make sure you are current PTFs. The latest Cumulative package and group PTFs. Second search the IBM PTF listing for PTFs that sound like what you are experiencing and if they are not in the lists mentioned above, order them seperately. The fact that both SQLCODE and SQLSTT are 0 leads me to believe that the problem is not and SQL problem. Have you checked the joblog for any diagnostic messages? Can you show us the code? Good luck, Kevin

    Comment

    • #3
      Embedded SQL Retrieve Mystery

      Kevin, This is happening on both a V5R2 machine and a V4R5 machine. Since it is a client's machine, I do not know what level the PTF's are at. I also thought of the DB2 PTF's, but don't know whether the client will do the checking, or not. I even tried to create a logical file with selections, and I used the SQL cursor over that logical, but it still gave me the wrong data. The entire program is quite large and complex. I have a .TXT version that I can uload when I get home. I was just wondering whether anyone had encountered this error before, and knew what was going on.

      Comment

      • #4
        Embedded SQL Retrieve Mystery

        Hello, I am having a very hard time tracking down what is going on in some embedded SQL. It appears to be only retrieving part of the current record, then retrieving part of the previous cursor's record. The SQLCA structure from the Dump is as follows: SQLCA DS SQLABC BIN(9,0) 000000136. '00000088'X SQLAID CHAR(8) 'SQLCA ' 'E2D8D3C3C1404040'X SQLCOD BIN(9,0) 000000000. '00000000'X SQLERL BIN(4,0) 0022. '0016'X SQLERM CHAR(70) 'C1 ' VALUE IN HEX 'C3F1404040404040404040404040404040400000000100000 0000000000000000000000000000000'X 41 '0000000000000000000000000000000000000000000000000 00000000000'X SQLERP CHAR(8) 'QSQROUTE' 'D8E2D8D9D6E4E3C5'X Page 70 ILE RPG/400 FORMATTED DUMP SQLERR CHAR(24) ' 7963' VALUE IN HEX '00000000000000000000000100000D0000000000F7F9F6F3' X SQLERRD BIN(9,0) DIM(6) (1-2) 000000000. '00000000'X (3) 000000001. '00000001'X (4) 000003328. '00000D00'X (5) 000000000. '00000000'X (6) -134613261. 'F7F9F6F3'X SQLER1 BIN(9,0) 000000000. '00000000'X SQLER2 BIN(9,0) 000000000. '00000000'X SQLER3 BIN(9,0) 000000001. '00000001'X SQLER4 BIN(9,0) 000003328. '00000D00'X SQLER5 BIN(9,0) 000000000. '00000000'X SQLER6 BIN(9,0) -134613261. 'F7F9F6F3'X SQLSTT CHAR(5) '00000' 'F0F0F0F0F0'X SQLWNA CHAR(1) ' ' '40'X SQLWN0 CHAR(1) ' ' '40'X SQLWN1 CHAR(1) ' ' '40'X SQLWN2 CHAR(1) ' ' '40'X SQLWN3 CHAR(1) ' ' '40'X SQLWN4 CHAR(1) ' ' '40'X SQLWN5 CHAR(1) ' ' '40'X SQLWN6 CHAR(1) ' ' '40'X SQLWN7 CHAR(1) ' ' '40'X SQLWN8 CHAR(1) ' ' '40'X SQLWN9 CHAR(1) ' ' '40'X SQLWRN CHAR(11) ' ' VALUE IN HEX '4040404040404040404040'X I cannot find what the SQLERR or SQLERRD means. My SQL statment processes, and the following is my select to determine whether to process the record of not: select when sqlcod < 0 or sqlcod = 100 eval w_recs3 = *off other . (processing goes here) . endsl As you will note in the dump, SQLCOD = 0, but I'm still getting errors.

        Comment

        • #5
          Embedded SQL Retrieve Mystery

          NEVER MIND!!! It looks like an external program was messing up the data prior to processing.

          Comment

          Previous template Next
          Working...
          X