SampleApp1.js

var dbobj = require('ifxnjs');
var fs = require('fs');

function DirExec(conn, ErrIgn, sql)
{
    try
    {
        var result = conn.querySync(sql);
        console.log(sql);
    }
    catch (e)
    {
        console.log("--- " + sql);
        if (ErrIgn != 1)
        {
            console.log(e);
            console.log();
        }
    }
}

function DoSomeWork(err, conn)
{
    if (err)
    {
        return console.log(err);
    }

    DirExec(conn, 1, "drop table t1");
    DirExec(conn, 0, "create table t1 ( c1 int, c2 char(20) ) ");
    DirExec(conn, 0, "insert into t1 values( 1, 'val-1' )");
    DirExec(conn, 0, "insert into t1 values( 2, 'val-2' )");
    DirExec(conn, 0, "insert into t1 values( 3, 'val-3' )");
    DirExec(conn, 0, "insert into t1 values( 4, 'val-4' )");
    DirExec(conn, 0, "insert into t1 values( 5, 'val-5' )");

    console.log();
    console.log(" --- SELECT * FROM t1 ------ ");
    // blocks until the query is completed and all data has been acquired
    var rows = conn.querySync("SELECT * FROM t1");
    console.log();
    console.log(rows);
};


var MyAsynchronousTask = function (err, conn)
{
    DoSomeWork(err, conn);
    conn.close();
}

function ifxnjs_Open(ConStr)
{
    console.log();
    console.log(" --- MyAsynchronousTask Starting.....");
    dbobj.open(ConStr, MyAsynchronousTask);
    console.log(" --- Log Message sequence... ?");
    console.log(" --- You are on Asynchronous call! :)");
}

function ifxnjs_OpenSync(ConStr)
{
    console.log();
    console.log(" --- Executing ifxnjs.openSync() ....");
    var conn;
    try
    {
        conn = dbobj.openSync(ConStr);
    }
    catch (e)
    {
        console.log(e);
        return;
    }

    DoSomeWork(0, conn);

    try
    {
        //dbobj.closeSync();
        conn.closeSync();
    }
    catch (e)
    {
        console.log(e);
    }
    console.log(" --- End ifxnjs.openSync()");
}

function main_func()
{
    var ConfigFile = "MyConfig.json"
    var ReadFromConfigFile = true;
    var ConnStr = "SERVER=ids0;DATABASE=db1;HOST=127.0.0.1;SERVICE=9088;PROTOCOL=onsoctcp;UID=informix;PWD=xxxx;";

    if( ReadFromConfigFile )
    {
        try
        {
            // do Synchronously read only
            var ConnInfo = JSON.parse(fs.readFileSync( ConfigFile, 'utf8'));
        }
        catch (e)
        {
            console.log(e);
            console.log( "Copy SampleConfig.json to %s and modify connection information", ConfigFile );
            process.exit(1);
        }
        var ConnStr = ConnInfo.AllConns.Conn1.ConnStr;
    }


    //Synchronous Execution
    ifxnjs_OpenSync(ConnStr);

    //Asynchronous Execution
    ifxnjs_Open(ConnStr);
}

main_func();