Classics Forum

Re: Unix-Informix to AS/400

Posted By:
Date:

Sorry, I meant to say, log into your server that your informix database runs
on and at the unix prompt, type echo $INFORMIXDIR, etc.

John
----- Original Message -----
From: "John Elser" <jElser@ck8.uscourts.gov>
To: <classics@iiug.org>
Sent: Friday, February 14, 2003 10:22 AM
Subject: Re: Unix-Informix to AS/400 [52]


> If you are not sure of what the INFORMIXDIR, etc. variables are set to,
log
> into your informix database and type: echo $INFORMIXDIR (just put a $
sign
> in front of the variable.) It should return the values that you will need
> in your script.
>
> If you can not reboot your unix system to activate the crontab entry, you
> can edit the crontab by: log in as root or informix, type: EDITOR=vi ;
> export EDITOR. Then type, crontab -e (you can echo $EDITOR and if an
> editor is already set, you do not have to do set the EDITOR and you don't
> have to do the export EDITOR).
>
> John
>
> ----- Original Message -----
> From: "RAFFAELE BE...." <r.bertoni@aliasnet.it>
> To: <classics@iiug.org>
> Sent: Friday, February 14, 2003 9:41 AM
> Subject: Re: Unix-Informix to AS/400 [49]
>
>
> > :
> > # file CREATE.sh
> > PATH=/bin:/etc:/usr/bin:/tcb/bin:/usr/informix/bin
> > INFORMIXDIR=/usr/informix
> > INFORMIXSERVER=local_se
> > DBPATH=/usr2/dbgioiae
> > DBDATE=DMY4/
> >
> > export PATH INFORMIXDIR INFORMIXSERVER DBPATH DBDATE
> >
> > isql - - <<!
> > database dbgioia;
> >
> > unload to file_name.txt select * from file_name;
> >
> > close database;
> > !
> >
> >
> > Create this file with wordpad or edit or vi (in unix). And locale in the
> $DBPATH directory then change permission to execute whit this command :
> >
> > chmod +x CREATE.sh
> >
> > Change the value in INFORMIXSERVER / INFORMIXDIR / DBPATH / DBDATE whit
> the value setting on your unix file.
> > dbgioia is the name of the database, you must change also it.
"file_name"
> is the name of the file to export.
> >
> > Next to lauch this file, in the crontab file (usually stored in
> /usr/spool/cron/crontabs) edit the file root (whit a vi editor) add the
> following row :
> >
> > 20 6 * * * /usr2/dbgioiae/CREATE.sh > /dev/null
> >
> > This command execute CREATE.sh every day ad 6:20 AM and so create a file
> file_name.txt that's contaies the data from file_name.
> >
> >
> >
> > Restart the unix system to activate the crontab changes.
> >
> > From the AS/400 system, with an ftp command "get" transfer the ascii
file.
> >
> > I hope this can help you.
> >
> > Bye
> >
>
>

Messages In This Thread

• Unix-Informix to AS/400
  J WILSON -- Tuesday, 15 April 2003, at 3:55 p.m.
  • Re: Unix-Informix to AS/400
    Kipp Sherry -- Tuesday, 15 April 2003, at 3:55 p.m.
  • Re: Unix-Informix to AS/400
    RAFFAELE BERTONI -- Tuesday, 15 April 2003, at 3:55 p.m.
    • RE: Unix-Informix to AS/400
      Konikoff, Rob (Contractor) -- Tuesday, 15 April 2003, at 3:55 p.m.
    • Re: Unix-Informix to AS/400
      John Elser -- Tuesday, 15 April 2003, at 3:55 p.m.
      • Re: Unix-Informix to AS/400
        John Elser -- Tuesday, 15 April 2003, at 3:55 p.m.
      • RE: Unix-Informix to AS/400
        Phillips, Ken -- Tuesday, 15 April 2003, at 3:55 p.m.
        • Re: Unix-Informix to AS/400
          Mark D. Stock -- Tuesday, 15 April 2003, at 3:55 p.m.
    • Re: Re: Unix-Informix to AS/400
      J WILSON -- Tuesday, 15 April 2003, at 3:55 p.m.
      • RE: Re: Unix-Informix to AS/400
        Konikoff, Rob (Contractor) -- Tuesday, 15 April 2003, at 3:55 p.m.
      • Re: Re: Unix-Informix to AS/400
        Jack Parker -- Tuesday, 15 April 2003, at 3:55 p.m.
      • Re: Re: Re: Unix-Informix to AS/400
        RAFFAELE BERTONI -- Tuesday, 15 April 2003, at 3:55 p.m.

Classics Forum is maintained by Administrator with WebBBS 5.12.