|
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.
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
