Re: Office objects in DB2 & STRPCCMD

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

How about just storing the IFS path in the table and forget the BLOB 
thing - you take up no additional space to speak of and even save the 
space and time it takes to get the BLOB into basically a copy in the 
IFS. You could even mount a Windows network machine as an NFS server 
in the IFS. That network machine could be visible directly to the 
Windows desktop machine. And, yes, it is possible also to mount a 
Windows box under /QNTC but is rather a small pain to work with - NFS 
is much simpler.

I might also suggest using RUNRMTCMD instead of STRPCCMD - you have 
to install the incoming remote command feature of iSeries Access on 
the PC where you sending the command and optionally set up user and 
password to it. This is an implementation of the REXEC server. 
RUNRMTCMD lets you run a longer command string than STRPCCMD.

<vendor>
Or you might want to look at our Office Integrator product - it 
started out as a replacement for the mail merge that was lost when 
OfficeVision was dropped. It has much more to it, however. 
www.rjssoftware.com or call us in the USA at 888.RJS.SOFT or email 
sales@xxxxxxxxxxxxxxx
</vendor>

At 07:58 PM 5/30/2006, you wrote:

> I have been playing with the STRPCCMD to invoke WORD via a vbscript
> script, and to pass in substitution values. During my web meanderings
> trying to gather information on this integration I came across one
> reference which implied that an Office object could be stored in a BLOB
> field in DB2, but only by using SQL INSERT. Unfortunately I can't find
> this item again, but am desperate for some information on how the BLOB
> column contents (say a Word document) can then be rendered on the user's
> PC presumably by placing it in the IFS temporarily and firing up WORD
> with the path/document name.
>
> I am waiting for the iSeries/Ofice integration book from MC Press, but
> would like to create a proof of concept now. Any other references people
> know about? I have scanned the usual places.
>
> I am fighting a civil war at my site trying to convince the boss that we
> can do everything we need on the iSeries rather than fragmenting our
> department into a myriad of machines & platform. So I need to get this
> proof of concept working soon.
>
> Thanks....
>
>
> Mike Pantzopoulos
>
> EIG-Ansvar Limited
> Tel  : 61 (3) 8630 3193
> Fax:
>
>
> *********************************************************************************************************
> This email and any files transmitted with it are confidential and 
> intended solely for the use of the individual or entity to whom they 
> are addressed. If you are not the intended recipient, any use, 
> disclosure or copying of this message is unauthorised. If you have 
> received this message in error, please reply using the sender's email address.
>
> This footnote confirms that this email message has been scanned for 
> computer viruses. EIG-Ansvar Limited does not accept liability for 
> any loss or damage, whether caused by our own negligence or not, 
> that results from a computer virus or defect in the transmission of 
> this email or any attached file.
>
> EIG-Ansvar Limited - Australia (A.B.N. 21 007 216 506)
> Email : insure@xxxxxxxxxxxxxxxx
>
> Eig-Ansvar Limited - New Zealand
> Email : insure@xxxxxxxxxxxxxxxx
>
> *********************************************************************************************************
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.