05-03-2011
Dataset Library for C?
I am looking for an opensource dataset library for C. Something equivalent to ADO.Net.
Specifically, I am looking for the following features:
1. Create a Dataset from a file (XML or CSV).
2. Create a Dataset from a select query using an ODBC connection.
3. Load a created Dataset into a database table using an ODBC connection.
4. (Optional) Compare two datasets and report differences (an "expected vs. actual" comparison, which reports missing fields, missing records, mismatched field values etc.).
So far, I have not been able to find any open source project that provides such functionality.
I am thinking of developing something of my own by using SQLite's in-memory databases at the core, but would prefer to use an existing solution if available.
Do you know of any opensource projects providing some or all of the desired functionality? Any pointers would be appreciated.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi
May I know is there a way to read/copy a mainframe (IBM OS/390) dataset (sequential file) into a UNIX directory?
Thank you for your time.
IcyGuava (4 Replies)
Discussion started by: IcyGuava
4 Replies
2. Shell Programming and Scripting
I'm declaring a variable within a Korn shell to represent the total number of records in a SAS dataset and could use a little help with the syntax. This is what I have thus far:
#!/usr/bin/ksh
RecCount = `sas -x "select count(*) from /users/abc/123/sas_dataset.sas7bdat"` (2 Replies)
Discussion started by: sasaliasim
2 Replies
3. Programming
I am running the following Korn shell script:
#!/usr/bin/ksh
num_records=`sas "select count(*) from /users/abc/123/sasdata.sas7bdat"`
echo "$num_records"
The script keeps returning an invalid file error even though I am certain that the file really exists. Does anyone see anything wrong... (1 Reply)
Discussion started by: sasaliasim
1 Replies
4. Shell Programming and Scripting
Hello everyone,
i have to normalize this dataset (with 20.000 rows):
2,4,4,3,2,7,8,2,9,11,7,7,1,8,5,6
4,7,5,5,5,5,9,6,4,8,7,9,2,9,7,10
7,10,8,7,4,8,8,5,10,11,2,8,2,5,5,10
4,9,5,7,4,7,7,13,1,7,6,8,3,8,0,8,8
6,7,8,5,4,7,6,3,7,10,7,9,3,8,3,7,8
in this form:... (1 Reply)
Discussion started by: [raven]
1 Replies
5. Shell Programming and Scripting
Hello everybody,
I want to compute a data file in awk. I am new in awk and I need your help. The data file has the following fields. It has thousands of records.
Col1 Col2 Col3 Col4 Col5
0.85 0.07 Fre 42:86 25
0.73 0.03 frp 21:10 28
0.64... (12 Replies)
Discussion started by: ubeejani
12 Replies
6. Shell Programming and Scripting
Hi, All
I have a huge file which has 450G. Its tab-delimited format is as below
x1 A 50020 1
x1 B 50021 8
x1 C 50022 9
x1 A 50023 10
x2 D 50024 5
x2 C 50025 7
x2 F 50026 8
x2 N 50027 1
:
:
Now, I want to extract a subset from this file. In this subset, column 1 is x10, column 2 is... (3 Replies)
Discussion started by: cliffyiu
3 Replies
7. Solaris
Hi All,
I want to write a script to create flar images on multiple servers. In non zfs filesystem I am using -X option to refer a file to exclude mounts on different servers.
but on ZFS -X option is not working. I want multiple mounts to be ignore on ZFS base system during flarecreate.
I... (0 Replies)
Discussion started by: uxravi
0 Replies
8. Solaris
I messed up my pool by doing zfs send...recive So I got the following :
zpool list
NAME SIZE ALLOC FREE CAP DEDUP HEALTH ALTROOT
rpool 928G 17.3G 911G 1% 1.00x ONLINE -
tank1 928G 35.8G 892G 3% 1.00x ONLINE -
So I have "tank1" pool.
zfs get all... (8 Replies)
Discussion started by: eladgrs
8 Replies
9. UNIX for Advanced & Expert Users
Hello
I have a data set which looks like this :
progeny sire dam gender
12 1 3 M
13 2 4 F
14 2 5 F
15 6 5 ... (13 Replies)
Discussion started by: sajmar
13 Replies
10. UNIX for Advanced & Expert Users
Hi Guys,
Is there a way to export a sas file i.e .sas7bdat file to .csv file with header and data using unix. I dont want to use SAS program instead using unix tool or unix scripting is it possible ? (25 Replies)
Discussion started by: Master_Mind
25 Replies
LEARN ABOUT MOJAVE
dbix::class::storage::dbi::ado::microsoft_sql_server::cursor5.18
DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::CuUser(Contributed Perl DocumDBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor(3)
NAME
DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor - Remove trailing NULLs in binary data and normalize GUIDs for MSSQL over ADO
DESCRIPTION
This class is for removing trailing "NULL"s from binary data and removing braces from GUIDs retrieved from Microsoft SQL Server over ADO.
You probably don't want to be here, see DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server for information on the Microsoft SQL Server
driver for ADO and DBIx::Class::Storage::DBI::MSSQL for the Microsoft SQL Server driver base class.
Unfortunately when using DBD::ADO, binary data comes back padded with trailing "NULL"s and GUIDs come back wrapped in braces, the purpose
of this class is to remove the "NULL"s and braces. DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server sets cursor_class to this class by
default. It is overridable via your connect_info.
You can use DBIx::Class::Cursor::Cached safely with this class and not lose the binary data normalizing functionality, ::Cursor::Cached
uses the underlying class data for the inner cursor class.
AUTHOR
See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.18.2 2013-12-16 DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor(3)