Error code -406 & -408
Posted in 1993
Topics: Stored Procedures & SPL, Error Codes & Troubleshooting, Connectivity: ESQL/C, 4GL & Embedded SQL
Hi, We port customer's AP to DEC 3000/400 OSF/1, but we get some Informix ESQL/C error code 406 and 408. Could you someone can give us the suggestion or ideal for this problem ? Pls refer to the attachment source file and result of error code. Thanks, and Regards Steve Hsu Internet Address : stevehsu@tpovc.enet.dec.com ============================================================================== /********************************************************* source file ***********************************************************/ #include <string.h> #include <stdio.h> #include <curses.h> $include sqlca; main() { int err, no_record; $database trunk; for(;;) { for(no_record=1; no_record <= 8000; no_record++) { if( (err=get_spdat(no_record)) != 0) fprintf(stderr,"sqlcode = %d\\n", err); } } } get_spdat(no_reco) int no_reco; { int err; $char seloi[400]; $int splsq, sp_length, sp_resid, sp_dblos, sp_rate; $char splno[16], spano[16], spo_loc[21], spi_loc[21], sp_sta[2]; $char spsta[2], sp_unit[2], sp_sect[2], sp_route[51], sp_spec[2]; $char sp_date[11], sp_class[3]; sprintf(seloi,"select splno,spano,spo_loc,spi_loc,sp_date,spsta,\\ sp_length,sp_resid,sp_dblos,sp_rate,sp_unit,\\ sp_sect,sp_route,sp_class,sp_spec,sp_sta \\ from spdat01 where splsq=%d", no_reco); $prepare cur_pid from $seloi; if(sqlca.sqlcode != 0) { fprintf(stderr,"$prepare => # = %d, sqlcode = %d\\r", no_reco, sqlca.sqlcode); return(sqlca.sqlcode); } $declare cur_sp cursor for cur_pid; if(sqlca.sqlcode != 0) { fprintf(stderr,"$declare => # = %d, sqlcode = %d\\r", no_reco, sqlca.sqlcode); return(sqlca.sqlcode); } $open cur_sp; if(sqlca.sqlcode != 0) { fprintf(stderr,"$open => # = %d, sqlcode = %d\\r", no_reco, sqlca.sqlcode); return(sqlca.sqlcode); } $fetch cur_sp into $splno,$spano,$spo_loc,$spi_loc,$sp_date,$spsta, $sp_length,$sp_resid,$sp_dblos,$sp_rate,$sp_unit, $sp_sect,$sp_route,$sp_class,$sp_spec,$sp_sta ; if(sqlca.sqlcode != 0) { fprintf(stderr,"$fetch => # = %d, sqlcode = %d\\n", no_reco, sqlca.sqlcode); } err=sqlca.sqlcode; $close cur_sp; return(err); } /***********************************************/ /* Table "spdat01" has more than 8000 records. */ /* execution results are as follows: */ /***********************************************/ ...... /* normal part */ $fetch => # = 7914, sqlcode = 100 sqlcode = 100 $fetch => # = 7915, sqlcode = 100 sqlcode = 100 $fetch => # = 7917, sqlcode = 100 sqlcode = 100 $fetch => # = 7920, sqlcode = 100 sqlcode = 100 $fetch => # = 7927, sqlcode = 100 sqlcode = 100 $fetch => # = 7934, sqlcode = 100 sqlcode = 100 sqlcode = -406= 7941, sqlcode = -406 sqlcode = -408= 7942, sqlcode = -408 Unable to obtain requested swap space sqlcode = -1257 7943, sqlcode = -1257 Unable to obtain requested swap space sqlcode = -1257 7944, sqlcode = -1257 Unable to obtain requested swap space sqlcode = -1257 7945, sqlcode = -1257 Unable to obtain requested swap space sqlcode = -1257 7946, sqlcode = -1257 Unable to obtain requested swap space ================================================================================ps) DEC OSF/1 1.3 Informix On-Line Ver. 5.0 & ESQL/C