请教，在unix下用ec编程?

zjlx_wylx

请教，在unix下用ec编程，向程序中传入的数据个数是不确定的，怎样调用存储过程 CREATE PROCEDURE FROM " " 先进行数据的存储－－＞然后用 SELECT * FROM TABLE WHERE TAB1='被存储的数据1' AND TAB2='被存储的数据2' AND .....

请各位大侠帮帮忙！(急盼）

zjlx_wylx

比如，一个数据库名为aaa，表名为bbb，此表存放通讯录，当我用EC进行数据库查询时，有时我输入的条件是年龄为VAR1,有时我输入的条件是年龄VAR1、性别VAR2（如男），在对表进行查询"WHERE"后的条件是怎样编写的？

大梦

根据条件用动态sql语句

zjlx_wylx

请问大梦，能否用一个简单的语句来说明一下？？

                谢谢！

大梦

用prepare 语句！

zjlx_wylx

请大梦帮一下忙，详细解译　prepare 的用法，谢谢！！

大梦

prepare 名称 from “sql语句”

zoukunhong

首先根据输入的参数情况组织SQL语句，然后prepare。

]-unixman-[

#include <stdio.h>;

EXEC SQL define FNAME_LEN15;
EXEC SQL define LNAME_LEN15;

main()
{
EXEC SQL BEGIN DECLARE SECTION;
    char demoquery[80];
    char queryvalue[2];
    char fname[ FNAME_LEN + 1 ];
    char lname[ LNAME_LEN + 1 ];
EXEC SQL END DECLARE SECTION;

    printf("DEMO2 Sample ESQL Program running.\n\n";
    EXEC SQL WHENEVER ERROR STOP;
    EXEC SQL connect to 'stores_demo';

    /* These next three lines have hard-wired the query. This
     * information could have been entered from the terminal
     * and placed into the demoquery string.
     */
    sprintf(demoquery, "%s %s",
              "select fname, lname from customer",
           "where lname < ? ";

    EXEC SQL prepare demo2id from :demoquery;
    EXEC SQL declare demo2cursor cursor for demo2id;

    /* This next line has hard-wired the value for the parameter.
     * This information could also have been entered from the
     * terminal and placed into the queryvalue string.
     */
    sprintf(queryvalue, "C";
    EXEC SQL open demo2cursor using :queryvalue;

    for (;
        {
        EXEC SQL fetch demo2cursor into :fname, :lname;
        if (strncmp(SQLSTATE, "00", 2) != 0)
            break;

        /* Print out the returned values */
        printf("Column: fname\tValue: %s\n", fname);
        printf("Column: lname\tValue: %s\n", lname);
        printf("\n";
      }

    if (strncmp(SQLSTATE, "02", 2) != 0)
        printf("SQLSTATE after fetch is %s\n", SQLSTATE);

    EXEC SQL close demo2cursor;

    EXEC SQL free demo2id;
    EXEC SQL free demo2cursor;

    EXEC SQL disconnect current;
    printf("\nDEMO2 Sample Program over.\n\n";
}
这是一个模板,你看懂后些就可以了.

大梦

对～～
informix的demo例程中有的～～