Hi all -

I’m creating a large db table with several columns.  To speed it up, I’m using monetdb’s “COPY BINARY” command.  I have a question on creating the binary files.  What I’ve done is use java’s DataOutputStream to create the binary file – using code that looks as below (sometimes an int, sometimes a real or byte):

writerChr = new DataOutputStream(new BufferedOutputStream(new FileOutputStream(chrFile)));

writerChr.writeInt(intChrom);

When I read this file using a test program and java’s DataInputStream, it correctly shows me the integer values I’ve written.  In the “writerChr” case, all values in this particular column are “10”.

However, when I load this into monetdb the value is way off – it shows a large number.  The command I am using to copy this file and one other into a table with 2 “int” columns is:

COPY binary into justchrpos from ('/home/lcj34/chrFileC10.bin','/home/lcj34/posFileC10.bin’);

It copies in fine, but when I cheek the values I see this:  (not 10!)

sql>\d justchrpos

CREATE TABLE "testbig"."justchrpos" (

"chr" INTEGER,

"pos" INTEGER

);