应用程序 - 问题 [英] application program - question

问题描述

大家好！

我想使用包含以下声明的应用程序将记录插入表格中：


EXEC SQL BEGIN DECLARE SECTION;

long hvInt_Stor;

long hvExt_Stor;

EXEC SQL END DECLARE SECTION;

hvInt_Stor = MMDB_STORAGE_TYPE_INTERNAL;

hvExt_Stor = MMDB_STORAGE_TYPE_EXTERNAL;

EXEC SQL INSERT INTO EMPLOYEE VALUES（

''128557''，/ * id * /

''Anita Jones''，/ * name * /

DB2IMAGE（/ * Image Extender UDF * /

CURRENT SERVER，/ *数据库服务器名称在* /

/ CURRENT SERVER寄存器* /

''/ employee / images / ajones.bmp''/ *图像源文件* /

''ASIS''，/ *保留图像格式* /

：hvInt_Stor，/ *将图像存储在DB中作为BLOB * /

''Anita'''s'''''，* * comment * /

DB2AUDIO（/ * Audio Extender UDF * /

CURRENT SERVER，/ *数据库服务名字在* /

/ * CURRENT SERVER寄存器* /

''/ employee / sounds / ajones.wav''，/ *音频源文件* /

''WAVE''，/ *音频格式* /

：hvExt_Stor，/ *保留服务器文件中的内容* /

''Anita' '''s'''）/ *评论* /

）;


也许这是个愚蠢的问题，但是：我应该使用什么编译器？我应该包括哪些
图书馆？我辛苦工作了两个星期......我现在正在使用

Microsoft Visual C ++（之前是Borland C 5.5编译器），但是

我可以''编译这个程序没有错误（通常错误是库里面的
：sqltypes.h）

1.如何强制这个编译器只在可能的情况下使用IBM库？

2.也许有人可以告诉我如何编写程序，包括上面显示的

语句？


我接近崩溃:-（


Vavel

Hi all!
I want to insert the record into the table by
using an application program that includes the following statements:

EXEC SQL BEGIN DECLARE SECTION;
long hvInt_Stor;
long hvExt_Stor;
EXEC SQL END DECLARE SECTION;
hvInt_Stor = MMDB_STORAGE_TYPE_INTERNAL;
hvExt_Stor = MMDB_STORAGE_TYPE_EXTERNAL;
EXEC SQL INSERT INTO EMPLOYEE VALUES(
''128557'', /*id*/
''Anita Jones'', /*name*/
DB2IMAGE( /*Image Extender UDF*/
CURRENT SERVER, /*database server name in*/
/CURRENT SERVER register*/
''/employee/images/ajones.bmp'' /*image source file*/
''ASIS'', /*keep the image format*/
:hvInt_Stor, /*store image in DB as BLOB*/
''Anita''''s picture''), /*comment*/
DB2AUDIO( /*Audio Extender UDF*/
CURRENT SERVER, /*database server name in*/
/*CURRENT SERVER register*/
''/employee/sounds/ajones.wav'', /*audio source file*/
''WAVE'', /* audio format */
:hvExt_Stor, /*retain content in server file*/
''Anita''''s voice'') /*comment*/
);

Maybe that''s silly question,but : what compiler should I use? and which
libraries should I include? I toil over this for 2 weeks... I''m using
Microsoft Visual C++ at this moment( Borland C 5.5 compiler before),but
I can''t compile this programme without errors (commonly errors are
inside library: sqltypes.h)
1. How to force this compiler to use IBM libaries only when it is possible?
2. Maybe someone could tell me how to write programme,that include
statements that were shown above??

I''m close to break down :-(

Vavel

推荐答案

" Vavel" ch **** @ any.fm>在留言中写道

news：ct ********** @ inews.gazeta.pl .. 。

"Vavel" <ch****@any.fm> wrote in message
news:ct**********@inews.gazeta.pl...

大家好！
我想用
使用包含以下语句的应用程序将记录插入表中：

EXEC SQL BEGIN DECLARE SECTION;
long hvInt_Stor;
long hvExt_Stor;
EXEC SQL END DECLARE SECT ION;
hvInt_Stor = MMDB_STORAGE_TYPE_INTERNAL;
hvExt_Stor = MMDB_STORAGE_TYPE_EXTERNAL;
EXEC SQL插入员工价值（
''128557''，/ * id * /
'' Anita Jones''，/ * name * /
DB2IMAGE（/ * Image Extender UDF * /
CURRENT SERVER，/ *数据库服务器名称在* /
/ CURRENT SERVER寄存器* /
''/employee/images/ajones.bmp''/ *图像源文件* /
''ASIS''，/ *保留图像格式* /
：hvInt_Stor，/ *存储图像在DB中作为BLOB * /
''Anita'的图片''），/ * comment * /
DB2AUDIO（/ * Audio Extender UDF * /
CURRENT SERVER，/ *数据库服务器名称在* /
/ * CURRENT SERVER寄存器* /
''/mployee / sounds / ajones.wav''，/ *音频源文件* /
''WAVE'' ，/ *音频格式* /
：hvExt_Stor，/ *保留服务器文件中的内容* /
''Anita的声音''）/ *评论* /
）;

也许这是个愚蠢的问题，但是：我应该使用什么编译器？我应该包括哪些图书馆？我辛苦工作了两个星期......我现在正在使用
Microsoft Visual C ++（之前是Borland C 5.5编译器），但是我无法编译这个程序而没有错误（通常错误是在库内部：sqltypes.h）
1.如何强制这个编译器只在
可能的情况下使用IBM库？ 2.也许有人可以告诉我如何编写程序，包括上面显示的语句？

我接近崩溃： - （

Hi all!
I want to insert the record into the table by
using an application program that includes the following statements:

EXEC SQL BEGIN DECLARE SECTION;
long hvInt_Stor;
long hvExt_Stor;
EXEC SQL END DECLARE SECTION;
hvInt_Stor = MMDB_STORAGE_TYPE_INTERNAL;
hvExt_Stor = MMDB_STORAGE_TYPE_EXTERNAL;
EXEC SQL INSERT INTO EMPLOYEE VALUES(
''128557'', /*id*/
''Anita Jones'', /*name*/
DB2IMAGE( /*Image Extender UDF*/
CURRENT SERVER, /*database server name in*/
/CURRENT SERVER register*/
''/employee/images/ajones.bmp'' /*image source file*/
''ASIS'', /*keep the image format*/
:hvInt_Stor, /*store image in DB as BLOB*/
''Anita''''s picture''), /*comment*/
DB2AUDIO( /*Audio Extender UDF*/
CURRENT SERVER, /*database server name in*/
/*CURRENT SERVER register*/
''/employee/sounds/ajones.wav'', /*audio source file*/
''WAVE'', /* audio format */
:hvExt_Stor, /*retain content in server file*/
''Anita''''s voice'') /*comment*/
);

Maybe that''s silly question,but : what compiler should I use? and which
libraries should I include? I toil over this for 2 weeks... I''m using
Microsoft Visual C++ at this moment( Borland C 5.5 compiler before),but
I can''t compile this programme without errors (commonly errors are
inside library: sqltypes.h)
1. How to force this compiler to use IBM libaries only when it is possible? 2. Maybe someone could tell me how to write programme,that include
statements that were shown above??

I''m close to break down :-(

你有没有考虑过查看你的DB2副本附带的应用程序

编程/构建手册？这些手册

描述了编译你的程序并描述哪些编译器已用DB2测试过。他们还提供了许多你可以模仿的各种语言的程序示例。


我必须假设您没有看到这些示例中的任何一个因为您出现

以在整个插入中散布大量评论

声明。如果你删除那些评论，我希望你的编译好多了。

运气好。


犀牛

Have you given any thought to looking at the Application
Programming/Building manuals that come with your copy of DB2? These manuals
describe the process of compiling your programs and describe which compilers
have been tested with DB2. They also give many examples of programs in a
variety of languages that you can imitate.

I have to assume you didn''t look at any of these examples because you appear
to have a large number of comments interspersed throughout your Insert
statement. If you remove those comments, I expect you''ll have much better
luck with your compile.

Rhino

Rhino写道：

Rhino wrote:

你有没有想过看您的DB2副本附带的应用程序编程/构建手册？这些手册描述了编译程序的过程，并描述了哪些编译器已经过DB2测试。他们还提供了许多您可以模仿的各种语言的程序示例。

1.应用程序开发指南：构建和运行应用程序

2.Quick DB2客户端的起点

3. DB2环境对Windows环境的利用


我知道如果有人在多次询问某些事情的第一个答案

是RTFM。但是我看过上面列出的手册，但是我没有找到答案。
没有找到答案。我不是说这本手册里没有答案

但是我找不到它。这就是我寻求帮助的原因。
我我必须假设您没有看到这些示例中的任何一个，因为您似乎在整个Insert
语句中散布了大量的注释。如果你删除这些评论，我希望你的编译能有更好的运气。

Have you given any thought to looking at the Application
Programming/Building manuals that come with your copy of DB2? These manuals
describe the process of compiling your programs and describe which compilers
have been tested with DB2. They also give many examples of programs in a
variety of languages that you can imitate.
1.Application Development Guide:Building and Running Applications
2.Quick Beginnings for DB2 Clients
3. DB2 UDB Exploitation of the Windows Environment

I know that if someone asked about something first answer in many times
is RTFM. But I''ve looked at manuals that I''ve listed above, but I
didn''t find answer. I don''t say that there is no answer in this manuals
but I can''t find it.That''s why I asked for help.
I have to assume you didn''t look at any of these examples because you appear
to have a large number of comments interspersed throughout your Insert
statement. If you remove those comments, I expect you''ll have much better
luck with your compile.

但是我的编译器根本没有查看我的陈述，因为在库中有一个

错误，而编译语句。也许有人看到了这个可以帮助我的例子。这很容易说：一切都在

手册......


问候

Vavel

But my compiler didn''t look at my statement at all because there was an
errors in libaries,while statements were compiled. Maybe someone have
seen example that would help me. It''s easy to say: "everything is in
manual"...

greetings
Vavel

Vavel写道：

Rhino写道：

Rhino wrote:

你有没有考虑过查看应用程序<您的DB2副本附带的编程/构建手册？这些
手册描述了编译程序的过程，并描述了哪些编译器已经过DB2测试。他们还提供了许多可以模仿的各种语言的程序示例。

Have you given any thought to looking at the Application
Programming/Building manuals that come with your copy of DB2? These
manuals
describe the process of compiling your programs and describe which
compilers
have been tested with DB2. They also give many examples of programs in a
variety of languages that you can imitate.

1.应用程序开发指南：构建和运行应用程序
2. DB2客户端的快速入门
3. DB2 UDB对Windows环境的利用

我知道，如果有人在多次询问某些问题的第一个答案
是RTFM。但我看过上面列出的手册，但是我没有找到答案。我不是说这本手册没有答案
但是我找不到。这就是我寻求帮助的原因。

1.Application Development Guide:Building and Running Applications
2.Quick Beginnings for DB2 Clients
3. DB2 UDB Exploitation of the Windows Environment

I know that if someone asked about something first answer in many times
is RTFM. But I''ve looked at manuals that I''ve listed above, but I
didn''t find answer. I don''t say that there is no answer in this manuals
but I can''t find it.That''s why I asked for help.

I我必须假设您没有看到这些示例中的任何一个，因为您看起来
在整个Insert
语句中散布了大量的注释。如果你删除这些评论，我希望你的编译能有更好的运气。

I have to assume you didn''t look at any of these examples because you
appear
to have a large number of comments interspersed throughout your Insert
statement. If you remove those comments, I expect you''ll have much better
luck with your compile.

但是我的编译器根本不看我的陈述，因为在库中有一个
错误，而编译语句。也许有人看到了可以帮助我的例子。很容易说：一切都在
手册中......

But my compiler didn''t look at my statement at all because there was an
errors in libaries,while statements were compiled. Maybe someone have
seen example that would help me. It''s easy to say: "everything is in
manual"...

代码看起来像C中的嵌入式SQL - Informix术语，ESQL / C.


您需要找到将其转换为

a C源文件的正确预处理器，然后使用正确的文件编译该C源代码

标题（和库）到对象或可执行文件中。

-

Jonathan Leffler #include< disclaimer.h>

电子邮件： jl******@earthlink.net ， jl ****** @ us.ibm.com

DBD守护者:: Informix v2003.04 - - http://dbi.perl.org/

The code looks like Embedded SQL in C - in Informix terms, ESQL/C.

You need to find the correct preprocessor that will convert that into
a C source file, and then compile that C source with the correct
headers (and libraries) into an object or executable.
--
Jonathan Leffler #include <disclaimer.h>
Email: jl******@earthlink.net, jl******@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

这篇关于应用程序 - 问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！