Datablade List Forum

Re: Re: WebExplode

Posted By: Tony Salerno
Date: Monday, 5 January 2004, at 4:30 p.m.

In Response To: Re: Re: WebExplode (ANATOLI LEVIN)

Anatoli,

I unload web pages to a file in a shell script.
Set the variables DB, INFORMIXSERVER, OUTFILE and PAGE_ID
to be what you need them to be. Make sure INFORMIXDIR and
the ones I listed above are set and exported. The
HTMLTOFILE function got installed with the version of the
web blade I use. Your's may differ (of course).

======================
#!/bin/ksh
INFORMIXDIR=/usr/informix
export INFORMIXDIR
INFORMIXSERVER=iserv
PAGE_ID=mywebpage
DB=mydb
TMP=/tmp
PATH=$PATH:$INFORMIXDIR/bin
OUTFILE=/tmp/${$}.html
export PATH INFORMIXSERVER OUTFILE TMP DB PAGE_ID

dbaccess ${DB}@${INFORMIXSERVER} << !
SELECT DISTINCT
HTMLTOFILE('$OUTFILE',WEBEXPLODE(object,'')) FROM wbpages
WHERE
id = '${PAGE_ID}';
!
======================

Let me know if you were trying to do something different
than this.

Tony
Virtual-DBA Delivery Manager
http://www.Xtivia.com
http://www.Virtual-DBA.com

--- ANATOLI LEVIN <levin@cbs.gov.il> wrote:
> when i work with "select webexplode(object,..." from
> wbpages it does not activate the dynamic tags which are
> stored in wbtags so the whole complex does not work
> i would like to write somthig like
> unload to file.file
> select WebExplod(object,'') from wbpages where id =
> 'id_name'
> any solution???
>


=====
--
mailto:asalerno1964@yahoo.com
AIM: asalerno1964
Y!: asalerno1964
ICQ: 1406681
MSN: asalerno1964@yahoo.com

__________________________________
Do you Yahoo!?
Find out what made the Top Yahoo! Searches of 2003
http://search.yahoo.com/top2003

Messages In This Thread

• WebExplode
  CARIN PRETORIUS -- Monday, 22 December 2003, at 8:24 a.m.
  • Re: WebExplode
    Donald Payne -- Wednesday, 31 December 2003, at 3:58 p.m.
    • Re: Re: WebExplode
      ANATOLI LEVIN -- Monday, 5 January 2004, at 5:07 a.m.
      • Re: Re: WebExplode
        Tony Salerno -- Monday, 5 January 2004, at 4:30 p.m.

Datablade List Forum is maintained by Administrator with WebBBS 5.12.