| View previous topic :: View next topic | 
	
	
		| Author | Message | 
	
		| vani Beginner
 
 
 Joined: 28 May 2003
 Posts: 51
 Topics: 30
 
 
 | 
			
				|  Posted: Wed Oct 01, 2003 6:10 am    Post subject: SQLDA |   |  
				| 
 |  
				| Hi, 
 We have changed a standard db2 header "sqlda.h" on AIX according to our program requirements
 can you please guide us as to where this standard header is located on Mainframe.
 And in case it is present how do we insure that this new header is picked up before the standard header.
 
 Regards,
 vani
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| kolusu Site Admin
 
  
 
 Joined: 26 Nov 2002
 Posts: 12394
 Topics: 75
 Location: San Jose
 
 | 
			
				|  Posted: Wed Oct 01, 2003 8:19 am    Post subject: |   |  
				| 
 |  
				| vani, 
 The standard headers are defined in the DSNTIPU - INSTALL DB2 - DATA SET NAMES PANEL 2.DSNHCPPS contains the header file search path to be used by DSNHCPP and DSNHCPP2.
 
 Both DSNHCPP and DSNHCPP2 are sample procedures which can precompile and prepare an application program.
 
 I would really appreciate if you can post feedback on your older queries
 
 Thanks
 
 kolusu
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| vani Beginner
 
 
 Joined: 28 May 2003
 Posts: 51
 Topics: 30
 
 
 | 
			
				|  Posted: Fri Oct 03, 2003 3:43 am    Post subject: |   |  
				| 
 |  
				| Thanks, but now I a getting some problem while compiling.It displays error messge as DSNH312I E     DSNHSMUD LINE 101 COL 48  UNDEFINED OR UNUSABLE HOST VARIABLE "h_sqlstr"
 DSNH080I E     DSNHSM3D LINE 101 COL 48  STRING VARIABLE "h_sqlstr" IS NOT "VARCHAR" type
 PREPARE Q1 INTO:*sqlDATemp FROM:h_sqlstr
 
 DSNH312I E     DSNHSMUD LINE 282 COL 39  UNDEFINED OR UNUSABLE HOST VARIABLE "h_qry"
 DSNH080I E     DSNHSM3D LINE 282 COL 39  STRING VARIABLE "h_qry" IS NOT "VARCHAR" type
 PREPARE S1 FROM:h_qry
 
 Also it display another error message as
 "'SYS03276.T134615.RA000.DBSMUKIN.DSNHOUT.H01'", line 187.11: CBC1055(S) "unsigned char [5]" cannot be converted to
 "char*".
 "'SYS03276.T134615.RA000.DBSMUKIN.DSNHOUT.H01'", line 458.11: CBC1055(S) "unsigned char [5]" cannot be converted to
 "char*".
 CBC1793(I) Compilation failed for file //'SYS03276.T134615.RA000.DBSMUKIN.
 
 Please advice me on this.
 Vani
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| kolusu Site Admin
 
  
 
 Joined: 26 Nov 2002
 Posts: 12394
 Topics: 75
 Location: San Jose
 
 | 
			
				|  Posted: Fri Oct 03, 2003 5:56 am    Post subject: |   |  
				| 
 |  
				| vani, 
 You need to define H-SQLSTR as follows
 
 
  	  | Code: |  	  | 01 H-SQL-STR.
 49 H-SQL-LENGTH   PIC S9(4) COMP.
 49 H-SQL-TEXT     PIC X(NNNN).
 
 | 
 
 
 You need to populate the length of sql you are trying to execuete.
 
 check this topic which discusses the same problem.
 
 http://www.mvsforums.com/helpboards/viewtopic.php?t=1214
 
 Hope this helps...
 
 cheers
 
 kolusu
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		|  | 
	
		|  |