Re: Finding service program -- C400-L

Thanks guys.

I was trying to import some sample code from DB2 UDB documentation. I guessit is not that universal. I managed to compile the code removing somenon-existent headers, like sqlenv.h, but I got stuck on binding these twoAPI's:

sqlogstt()
sqlaintp()

You're right I didn't find the API's in iSeries documentation. It isdescribed in the DB2 UDB documentation:

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0001659.htm

The funny thing that when I commented the API's the program actually workedand produced the expected result.

Maybe I'm on the wrong course at all. Somebody suggested to me to use CLI.I'm still checking it. I kind of preferred embedded SQL to ODBC functions.


Thanks
Boris.

----- Original Message -----From: <c400-l-request@xxxxxxxxxxxx>

To: <c400-l@xxxxxxxxxxxx>
Sent: Friday, January 27, 2006 8:00 PM
Subject: C400-L Digest, Vol 4, Issue 12

Send C400-L mailing list submissions to
c400-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/c400-l
or, via email, send a message with subject or body 'help' to
c400-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
c400-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of C400-L digest..."


Today's Topics:

  1. Finding service program (Boris)
  2. Re: Finding service program (Scott Klement)
  3. Re: Finding service program (Simon Coulter)


----------------------------------------------------------------------

message: 1
date: Thu, 26 Jan 2006 20:14:51 +0200
from: "Boris" <bbresc512@xxxxxxxxxx>
subject: [C400-L] Finding service program

Is there a way, in general, to find a service program that exports a
specific function?
I'm trying to find a service for sqlogstt API, declared in sql.h

Thanks



------------------------------

message: 2
date: Thu, 26 Jan 2006 12:46:38 -0600 (CST)
from: Scott Klement <c400-l@xxxxxxxxxxxxxxxx>
subject: Re: [C400-L] Finding service program


FWIW, I you can use the QBNLSPGM API to dump all procedure exports from
service programs to a user space.  You could then search the user space
for the export, and find which service program it belongs to.  Of course,
if you have enough service programs, there'll be too many for the user
space, and you'll have to do it on a per-library or even per-service
program basis, populate a file or user index, and look it up in there...
so this could get to be rather complicated.

I don't see why you'd ever want to do this.  Why does it matter what
service program IBM puts it's APIs in?  As long as your programs work, who
cares?  Are you trying to intercept the function call and make it work
against your service program instead of IBM's?

Does this API (sqlogstt) even exist on iSeries?  I can't find it in any of
the include files.

---
Scott Klement  http://www.scottklement.com

On Thu, 26 Jan 2006, Boris wrote:

Is there a way, in general, to find a service program that exports a
specific function?
I'm trying to find a service for sqlogstt API, declared in sql.h

Thanks

--
This is the C programming iSeries / AS400 (C400-L) mailing list
To post a message email: C400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/c400-l
or email: C400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/c400-l.



------------------------------

message: 3
date: Fri, 27 Jan 2006 09:07:28 +1100
from: Simon Coulter <shc@xxxxxxxxxxxxxxxxx>
subject: Re: [C400-L] Finding service program


On 27/01/2006, at 5:14 AM, Boris wrote:

Is there a way, in general, to find a service program that exports a
specific function?
I'm trying to find a service for sqlogstt API, declared in sql.h


If it is a real API as opposed to just a language function then the API
documentation names the service program. Otherwise use DSPSRVPGM
DETAIL(*PROCEXP) or the QBNLSPGM API.

In this case sql.h is a new include supplied at 530 and it does not
contain a definition for sqlogstt so it is unlikely that any service
program exports such a function. I suspect sqlogstt is a function from
some other dialect of SQL and may not exist on DB2/400.


Regards,
Simon Coulter.
--------------------------------------------------------------------
   FlyByNight Software         AS/400 Technical Specialists

   http://www.flybynight.com.au/
   Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
   Fax:   +61 3 9419 0175                                   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------




------------------------------

--
This is the C programming iSeries / AS400 (C400-L) digest list
To post a message email: C400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/c400-l
or email: C400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/c400-l.



End of C400-L Digest, Vol 4, Issue 12

*************************************