Originally posted by: steverats

Hai all,

I have a requirement where I need convert a compiled map (.mmc or .znx) file into binary format and store it in database. 

Is it possible? If yes , How?

In ITX9.0 version .....

Thanks,

Originally posted by: RichMcFate

I'm a little confused about what you're really after.   Both .mmc and .znx files are already binary formats.  You could certainly store them as is in a database as a CLOB object -- no conversion necessary.

What are you actually trying to do here?  Why do you want them in a database and what are you going to do with them once you have them there?

Thanks,

Rich

Originally posted by: DSTX_HOME

Hi Rich,

If lets say I am storing .znx or.mmc file as BLOB or CLOB in Database,  Can I call that map through a Java apps passing CLOB as parameter using WTX API ?  if so, how exactly should I pass CLOB executable files to run under WTX API using a java apps ? 

Originally posted by: RichMcFate

Yes, exactly.  In fact that's what IBM does with Sterling B2Bi and ITX Advanced.  The .mmc files are stored in a map repository (database) and passed to the internal java code as a byte array, which is then passed through the API for execution.   

If you have the Design Studio installed, there is an example in <DesignStudioRoot>/examples/dk/dtxpi/java..  I think it might be Example6 that shows how to invoke a map passed as a byte array.

Have fun!

Rich McFate

Originally posted by: RichMcFate

Actually, a BLOB would probably be preferable to a CLOB, but the principle is the same.

Originally posted by: DSTX_HOME

Thanks, yeah I figured out.  :)