View Full Version : Embedded SQL Retrieve Mystery
10-26-2004, 08:15 AM
Sorry, Here's a more formatted version of the dump info: <hr width=50 align=left>Code ('http://www.mcpressonline.com/mc/showcode@@.6b181d3e/0')
10-26-2004, 09:02 AM
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
10-26-2004, 09:58 AM
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.
10-27-2004, 03:04 PM
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.
10-27-2004, 03:04 PM
NEVER MIND!!! It looks like an external program was messing up the data prior to processing.
Powered by vBulletin® Version 4.1.5 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.