damoxc

#include <stdlib.h>
#include <sqlfront.h>
#include <sqldb.h>
#include <stdio.h>
#include <string.h>
#define MSDBLIB

int
main (void) {
    LOGINREC *login;
    DBPROCESS *dbproc;
    DBNUMERIC *numeric;
    RETCODE ret;

    char *server = "localhost", *user = "sa", *password = "";
    char *database = "tempdb";

    login = dblogin();

    DBSETLUSER(login, user);
    DBSETLPWD(login, password);
    DBSETLAPP(login, "damoxc");
    dbsetmaxprocs(25);
    DBSETLHOST(login, server);

    dbproc = dbopen(login, server);

    ret = dbcmd(dbproc,
        "SET ARITHABORT ON;"
        "SET CONCAT_NULL_YIELDS_NULL ON;"
        "SET ANSI_NULLS ON;"
        "SET ANSI_NULL_DFLT_ON ON;"
        "SET ANSI_PADDING ON;"
        "SET ANSI_WARNINGS ON;"
        "SET ANSI_NULL_DFLT_ON ON;"
        "SET CURSOR_CLOSE_ON_COMMIT ON;"
        "SET QUOTED_IDENTIFIER ON"
    );
    printf("%d\n", ret);
    ret = dbsqlexec(dbproc);
    printf("%d\n", ret);

    ret = dbcmd(dbproc, "USE tempdb");
    printf("%d\n", ret);
    ret = dbsqlexec(dbproc);
    printf("%d\n", ret);
    ret = dbcancel(dbproc);
    printf("%d\n", ret);

    ret = dbrpcinit(dbproc, "testDecimal", 0);
    printf("%d\n", ret);

    numeric = (DBDECIMAL *)malloc(sizeof(DBDECIMAL));
    numeric->scale = 5;
    numeric->precision = 6;
    numeric->array[0] = 5;
    numeric->array[1] = 1;
    numeric->array[2] = 2;
    numeric->array[3] = 3;
    numeric->array[4] = 4;
    numeric->array[5] = 5;

    ret = dbrpcparam(dbproc, "@idecimal", 0, SYBDECIMAL, -1, sizeof(DBDECIMAL), (BYTE *)numeric);
    printf("%d\n", ret);
    ret = dbrpcsend(dbproc);
    printf("%d\n", ret);
    ret = dbsqlok(dbproc);
    printf("%d\n", ret);

    printf("Succeed: %d\n", SUCCEED);
};