Thanks for the reply Thomas.
I could also find a document which said the same (Development wizard
for C++ stored proc is provided in MaxDB 7.5).
But I could find the downloadable for the .NET wizard. Could you
please let me know where to download it from.
I looked into the dbpInstall project, I can add a new function in
this COM object to accomplish my stored proc in C/C++.
But I could not compile the source code of the MaxDB 7.5.0.8 on
WinXP to try this out. I followed the steps as mentioned in the
sources.readme,
I tried "imf.pl all" and "imf.pl allknl", but both of them gave me
compilation errors. Following are the errors
Could you please tell me where I am going wrong.
Create gsp100.h first:
Warning: vmake pidfile (C:\V75_00_08\MaxDB_DEV/sys/wrk/vmake.pid)
already exists !
vmake 10.02.15 20-08-2003
VMAKE_PATH =C:\V75_00_08\MaxDB_DEV,C:\V75_00_08\MaxDB_ORG
11-03-04 15:33:37 start of collection phase
11-03-04 15:33:38 end of collection phase
11-03-04 15:33:38 start of gsp100.h fast
11-03-04 15:33:38 end of gsp100.h fast
Build: 169000008
vmake 10.02.15 20-08-2003
VMAKE_PATH =C:\V75_00_08\MaxDB_DEV,C:\V75_00_08\MaxDB_ORG
11-03-04 15:33:38 start of collection phase
11-03-04 15:34:07 end of collection phase
11-03-04 15:34:09 start of all.mac fast
gsp00
Thu Mar 11 15:34 2004 gsp00.p:
1007 = tsp00_C32;
E ----------------------^--- Duplicate case labels
1016 ^tsp00_Key;
E ----------------------^--- Duplicate case labels
1026 = ^tsp00_ScreenBuf;
E ----------------------^--- Duplicate case labels
1065 (map_c2 : tsp00_C2)
E ----------------------^--- Duplicate case labels
1192 has_sysline : boolean;
E ----------------------^--- Duplicate case labels
1195 rnkeys : tsp00_VtKeys;
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
1200 : boolean;
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
1274 keystroke : tsp00_VtKeyStroke;
E ----------------------^--- Duplicate case labels
1276 boolean;
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
1278 : tsp00_Int2;
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
1280 maximized : boolean;
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
1282 : tsp00_VtRectangle;
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
1284 sp00_VtSplitopt;
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
1286 tsp00_VfBuf = ARRAY [ 1..csp_pool_buffers ] OF
tsp\
00_Page;
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
E ----------------------^--- Duplicate case labels
1313 c18_type :
E ----------------------^--- Duplicate case labels
1373 tsp00_Int2;
E ----------------------^--- Duplicate case labels
1435 00_Int4;
E ----------------------^--- Duplicate case labels
ERROR : gsp00.c is empty ... deleting gsp00.c
Possible previous pascal syntax error!
COMMAND error 2
'hsp100.h' not made because of dependency errors
'vpr100.h' not made because of dependency errors
vsp004
Traceback (most recent call last):
File "C:\DevTool/bin/ptoc00.py", line 89, in ?
('i', 'imake', '', None, 'compile for vmake')
File "C:\DevTool\Lib\Python\optlib.py", line 273, in optMain
optMain2 (mainRoutine, optDesc)
File "C:\DevTool\Lib\Python\optlib.py", line 254, in optMain2
rc = mainRoutine (options, args)
File "C:\DevTool/bin/ptoc00.py", line 70, in main
errors = translateVmake (options, args)
File "C:\DevTool/bin/ptoc00.py", line 58, in translateVmake
ptoc00 = PtoC00Vmake (args, options.include, options)
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1130, in
__init_\
_
constants, types, enumMaxima = self.parseIncludes (includes)
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1154, in
parseIn\
cludes
ConstantExtractorVmake (includes, constants, types,
enumMaxima).tra\
nslate ()
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1092, in
__init_\
_
instream = MultiFileStream (fnames, ignoreConcom)
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1163, in
__init_\
_
self.openNext ()
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1169, in
openNex\
t
self.lines = open (self.fname, "r").readlines ()
IOError: [Errno 2] No such file or directory:
'C:\\V75_00_08\\MaxDB_DEV\
/sys/wrk/incl//gsp00.con'
mf00ccc: p-to-c-00 error!
error during execute: python C:\DevTool/bin/ptoc00.py -i -o
vsp004.h -\
I
C:\V75_00_08\MaxDB_DEV/sys/wrk/incl//gsp00.con,C:\V75_00_08\MaxDB_DEV/\
sys/wrk/incl//gsp00.typ vsp004.con vsp004.typ
COMMAND error 2
'geo102.h' not made because of dependency errors
vsp001
Traceback (most recent call last):
File "C:\DevTool/bin/ptoc00.py", line 89, in ?
('i', 'imake', '', None, 'compile for vmake')
File "C:\DevTool\Lib\Python\optlib.py", line 273, in optMain
optMain2 (mainRoutine, optDesc)
File "C:\DevTool\Lib\Python\optlib.py", line 254, in optMain2
rc = mainRoutine (options, args)
File "C:\DevTool/bin/ptoc00.py", line 70, in main
errors = translateVmake (options, args)
File "C:\DevTool/bin/ptoc00.py", line 58, in translateVmake
ptoc00 = PtoC00Vmake (args, options.include, options)
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1130, in
__init_\
_
constants, types, enumMaxima = self.parseIncludes (includes)
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1154, in
parseIn\
cludes
ConstantExtractorVmake (includes, constants, types,
enumMaxima).tra\
nslate ()
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1092, in
__init_\
_
instream = MultiFileStream (fnames, ignoreConcom)
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1163, in
__init_\
_
self.openNext ()
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1169, in
openNex\
t
self.lines = open (self.fname, "r").readlines ()
IOError: [Errno 2] No such file or directory:
'C:\\V75_00_08\\MaxDB_DEV\
/sys/wrk/incl//gsp00.con'
mf00ccc: p-to-c-00 error!
error during execute: python C:\DevTool/bin/ptoc00.py -i -o
vsp001.h -\
I
C:\V75_00_08\MaxDB_DEV/sys/wrk/incl//gsp00.con,C:\V75_00_08\MaxDB_DEV/\
sys/wrk/incl//gsp00.typ vsp001.con vsp001.typ
COMMAND error 2
'heo03.h' not made because of dependency errors
gsp05
Traceback (most recent call last):
File "C:\DevTool/bin/ptoc00.py", line 89, in ?
('i', 'imake', '', None, 'compile for vmake')
File "C:\DevTool\Lib\Python\optlib.py", line 273, in optMain
optMain2 (mainRoutine, optDesc)
File "C:\DevTool\Lib\Python\optlib.py", line 254, in optMain2
rc = mainRoutine (options, args)
File "C:\DevTool/bin/ptoc00.py", line 70, in main
errors = translateVmake (options, args)
File "C:\DevTool/bin/ptoc00.py", line 58, in translateVmake
ptoc00 = PtoC00Vmake (args, options.include, options)
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1130, in
__init_\
_
constants, types, enumMaxima = self.parseIncludes (includes)
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1154, in
parseIn\
cludes
ConstantExtractorVmake (includes, constants, types,
enumMaxima).tra\
nslate ()
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1092, in
__init_\
_
instream = MultiFileStream (fnames, ignoreConcom)
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1163, in
__init_\
_
self.openNext ()
File "C:\DevTool\Lib\Python\ptoc\ptoc00Lib.py", line 1169, in
openNex\
t
self.lines = open (self.fname, "r").readlines ()
IOError: [Errno 2] No such file or directory:
'C:\\V75_00_08\\MaxDB_DEV\
/sys/wrk/incl//gsp00.con'
mf00ccc: p-to-c-00 error!
error during execute: python C:\DevTool/bin/ptoc00.py -i -o gsp05.h
-I\
C:\V75_00_08\MaxDB_DEV/sys/wrk/incl//gsp00.con,C:\V75_00_08\MaxDB_DEV/s\
ys/wrk/incl//gsp00.typ gsp05.con gsp05.typ
COMMAND error 2
hsp77.h
'heo06.h' not made because of dependency errors
'heo102.h' not made because of dependency errors
vpr05IfCom_String.h
gpr00.h
Include heo102.h not in include list for gpr00.h
(1200 lines examined)
vpi00fc
Terminating on signal SIGINT(2)
> ----------
> From: Anhaus, Thomas[SMTP:[EMAIL PROTECTED]
> Sent: Monday, March 08, 2004 12:24 PM
> To: 'Niranjan K.'; [EMAIL PROTECTED]
> Subject: RE: Triggers
>
> Niranjan wrote :
>
> >Hi All
>
> >My requirement is such that, an action has to be taken when a record is
> >inserted/modified/deleted from a table. The action is implemented in "C"
> >code.
> >I wanted to know whether it is possible to call "C" code (function call)
> or
> >an executable from SQL statements(may be from a "Stored Procedure" or a
> >"Trigger" etc)??
>
> This actually is not possible. For SAP internal purposes we support
> db-procedures written in C++, but this feature is not documented
> so far and only a wizard to create such projects for the MS Visual Studio
> .net is
> available. If you downloaded the source code and the tools, you may have a
> look
> into the dbpInstall project, to get an idea how the C++ embedding is
> working.
> We plan to release this feature in the future.
>
> Best Regards,
> Thomas
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
*********************************************************************
Disclaimer: The information in this e-mail and any attachments is
confidential / privileged. It is intended solely for the addressee or
addressees. If you are not the addressee indicated in this message, you may
not copy or deliver this message to anyone. In such case, you should destroy
this message and kindly notify the sender by reply email. Please advise
immediately if you or your employer does not consent to Internet email for
messages of this kind.
*********************************************************************
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
