| View previous topic :: View next topic | 
	
	
		| Author | Message | 
	
		| somuk Beginner
 
 
 Joined: 04 Feb 2003
 Posts: 113
 Topics: 37
 
 
 | 
			
				|  Posted: Tue Jul 22, 2003 8:36 am    Post subject: DB2 Call Level Interface error |   |  
				| 
 |  
				| Hi , I'm getting the following error when running a COBOL-DB2 program.
 I'm not able to understand the reason for this. Can anybody help me
 out..?
 
  	  | Code: |  	  | "Error messages seen in job log:                                      +IDI0082E DB2 Call Level Interface error: SQL return code -1 for SQLAllocConnect to DB2 system DSFP
 A system abend 04E occurred in an undetermined module.
 A DB2 reason code X'00E70007' is associated with this abend and indicates that:
 A bad application-supplied address was encountered while trying to copy SQLCA back to the application program.
 SQLCA information: SQLCODE = -804, SQLSTATE = 07002    Explanation for -804:  The call parameter list or the SQLDA is invalid.
 Sysout directed to SYSOUT = V"
 
 | 
 _________________
 Regds,
 Somu
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| kolusu Site Admin
 
  
 
 Joined: 26 Nov 2002
 Posts: 12394
 Topics: 75
 Location: San Jose
 
 | 
			
				|  Posted: Tue Jul 22, 2003 10:25 am    Post subject: |   |  
				| 
 |  
				| Somu, 
 check if there is any internal table defined in the working storage of the program just before where sqlca is defined.
 
 There is a likely chance that the internal table over flowed and corrupted the contents of sqlca.
 
 Hope this helps...
 
 cheers
 
 kolusu
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| somuk Beginner
 
 
 Joined: 04 Feb 2003
 Posts: 113
 Topics: 37
 
 
 | 
			
				|  Posted: Tue Jul 22, 2003 11:01 pm    Post subject: |   |  
				| 
 |  
				| Kolusu, Yes..There is an internal table defined just above the SQLCA definition. I'm going to increase the size of the table and will test it..
 Thanks for your timely and valuable suggestion.
 _________________
 Regds,
 Somu
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		|  | 
	
		|  |