There's never any harm in stating the obvious. People should do it more often. My problem is on unidata, not universe, so there is no UNIVERSE.INCLUDE or BCI.H (mentioned in another response). There's an ODBC.H in INCLUDE though, and unfortunately I've already included it and successfully used equates from it in other bci functions. No help there. The compiler still seems to think I'm referencing an unDIMed array with too many dimensions. There's a sample program in the back of the unidata bci manual (available at http://publibfi.boulder.ibm.com/epubs/pdf/25124330.pdf), and on page B-8 they demonstrate the SQLBindParameter function. Apparently the code printed in the manual was never entered into a real computer and tested, because there is no closing parenthesis on the function call (on any one of the four examples). I also get the same result using the unidata PE on redhat. I think that's version 6.0 as well. Is there anyone out there who has ever used SQLBindParameter on unidata 6.0, or on any version of unidata?
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan > Sent: Friday, January 14, 2005 11:47 PM > To: [email protected] > Subject: RE: [U2] unidata bci commands not compiling > > > Hi > > It might be stating the obvious, but it has caught me once or > twice, did you include $INCLUDE UNIVERSE.INCLUDE ODBC.H at > the beginning of the program. > > I have used this in UniVerse for years, the problem maybe > using a wrong parameter code. The following is from some of my code > > ST=SQLBindParameter(STMTENV,1,SQL.B.BASIC,SQL.CHAR,0,0,CLIENT. > NO,SQL.PARAM.I > NPUT) > > Hope it gives you some ideas to try. > > Regards > > David Jordan > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ed Clark > Sent: Saturday, 15 January 2005 8:58 AM > To: [email protected] > Subject: [U2] unidata bci commands not compiling > > I'm attempting to use BCI on unidata 6.0 under hpux on a > pa-risc box. The simple commands work--I can open and close > connections and statement handles and execute statements that > affect remote databases. However, when I attempt to do > something more complicated and efficient--use > SQLBindParameters--the statement will simply not compile. I > can make a call to SQLPrepare, but the SQLBindParameters > function apparently doesn't exist in my version of unidata. I > have also tried the documented synonym SQLSetParam with the > same result. The compiler thinks I'm referencing an array > with too many dimensions, as the following compiler output shows: > > main program: syntax error at or before > <line 19> ST=SQLBindParameter(STMT.HANDLE,1,0,SQL.NUMERIC,0,0,0) > -----------------------------------^ > Expecting: > array,string,number,function,variable,OR,AND,!,>,>=,<,<=,=,<>, MATCH,CAT,:,+, > - > > Has anyone else experienced this? > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
