Hi,

When using monetdb, one questions that I need your suggestions is how to load a table column to MAL client and manipulate it.

For example,

sql>create table gzhang_test (intcol1 int,varcharcol1 varchar(50));

sql>insert into gzhang_test values (1,'value1');

sql>insert into gzhang_test values (2,'value2');

I know how to load a BAT by name in MAL, but for this table, I don't know how to get the name.

If I do:

mal>X_3 := sql.mvc();

mal>X_4:bat[:oid,:int] := sql.bind(X_3,"midas","gzhang_test","intcol1",0);

mal>io.print(X_4);

I will get ERROR = !SQLException:mvc:SQL module not initialized. Should I load the SQL module in a MAL session, what's the correct way to get the column if not?

Thanks,

George Zhang