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: 12378 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: 12378 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 |
|
 |
|
|