Connect to Pick Database using Odbc C# .Net
How to Connect to PickBasic database using Ole db driver .. I need it badly help me out ...
pick
UniCommand differences for UniData.
I'm new to the world of UniObjects as I've been in .NET land since it debuted. After building a simple app to return the select list of a UniCommand statement I noticed that there are some major differences in how UniData and how UniObjects parses the UniCommand statments. From what I've found it looks like it is differences in the flavo...
Pick and RDF/SPARQL
Anyone have any interest in intergrating RDF and/or SPARQL with a PICK database? Has anyone tried this yet? I have some thoughts about what to try. One idea is to figure out how to create a file with a dictionary that defines some correlatives that allow data to be pulled from the file as RDF, as one or many of n-triple, turtle, n3 or XM...
Multi-valued Database (UniVerse) -- SM (MV) vs SM (VS) and ASSOC()
I have a question taken from pg 16 of IBM's Nested Relational Database White Paper, I'm confused why in the below CREATE command they use MV/MS/MS rather than MV/MV/MS, when both ORDER_#, and PART_# are one-to-many relationships.. I don't understand what value, vs sub-value means in non-1nf database design. I'd also like to know to know ...
How do I find the column listing in UniVerse with RetrieVe or SQL?
I've got an issue where a table (file) is set up to return column foo on LIST table and SELECT * FROM table. I need to know the other possible columns in table. I'm pretty sure this was achieved by setting @ (behavoir definition of unqualified LIST), and @select (behavoir definition of * with very SELECT) but I don't know how to get the ...
UniVerse RetreiVe how do I query a file for all of its column's values?
Kind of a follow up to my self-answered question about finding the column names. In UniVerse you can't query a file for all of its columns unless the @ phrase in your file's dictionary is set to all of the tables columns. If it isn't how do you query a table for all of its column's values? So I can get the total column listing (column ...
UniTransaction throwing NullReferenceException
I'm trying to begin a transaction however on calling the .Begin() method throws a NullReferenceException and the stacktrace shows that it is coming from IBMU2.UODOTNET.UniTransaction.ServerTransaction(Int32 aKey). Has anyone successfully used UniTransaction, if so is there something that i'm missing? // note: Session is already connec...