Re: Strange SQL dumps

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Frank,

I received those errors too, when using the QSQPRCED API. The query will not 
run. After recompiling the PGM with ALLWNULL(*YES) the PGM runs without 
failure. 

So my guess is null values.

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 12-2-03 at 12:38 Frank.Kolmann@revlon.com wrote:

>I checked the archives and IBMs APARS but connot find anything.
>
>We are on V5R1 and are getting dumps from SQL.
>
>Does anyone know what it means or any suggestion on what to do.
>
>Thanks for any help,
>Frank Kolmann
>
>This is the SQL DUMP
>
>>From file . . . . . :  QTEMP/QAP0ZDMP            Member  . . :  QP0Z945654
>Record format . . . . . :  QAP0ZD
>Record length . . . :  512
>To file . . . . . . :  *PRINT
>          RCDNBR  *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...
>+... 6 ...+... 7 ...+... 8 ...+... 9 ...+...
>1  User Trace Dump for job 945654/SSA/MSSDAYEND. Size: 300K, Wrapped 0
>times.
>2
>3  --- 02/11/2003 23:33:55 ---
>4     0000007A:862592 SQ Run Time Dump of SQLCA section:
>5     0000007A:877192 CCEA88F70E:02D750 L:0008 EyeCatch:
>6     0000007A:877312  CCEA88F70E:02D750  E2D8D3C3 C1404040
>*SQLCA   ........*
>7     0000007A:877376 CCEA88F70E:02D758 L:0004 Length of SQLCA:
>8     0000007A:877456  CCEA88F70E:02D750                    00000088
>*...........h....*
>9     0000007A:877520 CCEA88F70E:02D75C L:0004 SQL return code:
>10     0000007A:877608  CCEA88F70E:02D750
>FFFFFC7B     *...............#*
>11     0000007A:877664 CCEA88F70E:02D760 L:0048 SQL error message:
>12     0000007A:877816  CCEA88F70E:02D760  000BD4C3 C8F3F4F0 F2000004
>B7000000     *..MCH3402.......*
>13     0000007A:877936  CCEA88F70E:02D770  00000000 00000000 00000000
>00000000     *................*
>14     0000007A:878072  CCEA88F70E:02D780  00000000 00000000 00000000
>00000000     *................*
>15     0000007A:878192  CCEA88F70E:02D790  00000000 00000000 00000000
>00000000     *................*
>16     0000007A:878272  CCEA88F70E:02D7A0  00000000 00000000
>*................*
>17     0000007A:878336 CCEA88F70E:02D7A8 L:0008 Program name:
>18     0000007A:878424  CCEA88F70E:02D7A0                    D8E2D8C6
>C5E3C3C8     *........QSQFETCH*
>19     0000007A:878496 CCEA88F70E:02D7B0 L:0018 Diag information:
>20     0000007A:878624  CCEA88F70E:02D7B0  00000000 00000000 00000000
>00000000     *................*
>21     0000007A:878712  CCEA88F70E:02D7C0  00000000 00000000
>*................*
>22     0000007A:878768 CCEA88F70E:02D7C8 L:000B Warning flag:
>23     0000007A:878856  CCEA88F70E:02D7C0                    40404040
>40404040     *........        *
>24     0000007A:878928  CCEA88F70E:02D7D0  404040
>*   .............*
>25     0000007A:878992 CCEA88F70E:02D7D3 L:0005 SQL state:
>26     0000007A:879080  CCEA88F70E:02D7D0        F5 F8F0F0F4
>*...58004........*
>27
> 27 records copied to member or label *N in file QSYSPRT in library QSYS. 0
>records excluded.
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.