Well i have got a half working version. It does do a bulk add, but only
the first row twice. Can anyone see where I went wrong?

SQLUINTEGER    OrderIDArray[3], NumRowsFetched;
SQLCHAR        SalesPersonArray[3][11],
              StatusArray[3][7];
SQLINTEGER     OrderIDIndArray[3],
              SalesPersonLenOrIndArray[3],
              StatusLenOrIndArray[3];
SQLUSMALLINT   RowStatusArray[3], i;
SQLHSTMT       hstmt;

   int loop;
   HDBC hdbc = (HDBC) __externalAddressVal(__INST(parentHandle));
   SQLRETURN sr;

   sr = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
   if(sr != SQL_SUCCESS && sr != SQL_SUCCESS_WITH_INFO)
           printf( "Error in allocating statement in
OnViewBulkinsert");

SQLSetStmtAttr(hstmt, SQL_ATTR_ROW_BIND_TYPE, SQL_BIND_BY_COLUMN, 0);
SQLSetStmtAttr(hstmt, SQL_ATTR_ROW_ARRAY_SIZE, (void *)2, 0);
SQLSetStmtAttr(hstmt, SQL_ATTR_ROW_STATUS_PTR, RowStatusArray, 0);
SQLSetStmtAttr(hstmt, SQL_ATTR_ROWS_FETCHED_PTR, &NumRowsFetched, 0);
// Set the cursor type.
sr = SQLSetStmtAttr(hstmt, SQL_ATTR_CURSOR_TYPE, (void*)
SQL_CURSOR_DYNAMIC, SQL_IS_UINTEGER);
// Lock out other users.
sr = SQLSetStmtAttr(hstmt, SQL_ATTR_CONCURRENCY,
             (void*) SQL_CONCUR_LOCK, SQL_IS_UINTEGER);
      if(sr != SQL_SUCCESS && sr != SQL_SUCCESS_WITH_INFO)
              printf( "Error in setting locking in
OnViewBulkinsert");

// Bind arrays to the OrderID, SalesPerson, and Status columns.
SQLBindCol(hstmt, 1, SQL_C_ULONG, OrderIDArray, 0, OrderIDIndArray);
SQLBindCol(hstmt, 2, SQL_C_CHAR, SalesPersonArray,
sizeof(SalesPersonArray[0]),
           SalesPersonLenOrIndArray);
SQLBindCol(hstmt, 3, SQL_C_CHAR, StatusArray, sizeof(StatusArray[0]),
           StatusLenOrIndArray);

// Execute a statement to retrieve rows from the Orders table.
SQLExecDirect(hstmt, "SELECT OrderID, SalesPerson, Status FROM Orders",
SQL_NTS);

   OrderIDArray[0] = 1;
   OrderIDArray[1] = 2;
   OrderIDIndArray[0] = 0;
   OrderIDIndArray[1] = 0;
   strcpy(SalesPersonArray[0], "Jackson");
   strcpy(SalesPersonArray[1], "Clinton");

   SalesPersonLenOrIndArray[0]= 7;
   SalesPersonLenOrIndArray[1]= 7;

   strcpy(StatusArray[0], "a");
   strcpy(StatusArray[1], "b");

   StatusLenOrIndArray[0] = 1;
   StatusLenOrIndArray[1] = 1;

printf("Do bulk operation");
       sr = SQLBulkOperations(hstmt, SQL_ADD);

       if(sr != SQL_SUCCESS && sr != SQL_SUCCESS_WITH_INFO)
               printf( "Error in bulk insert");

// Close the cursor.
SQLCloseCursor(hstmt);