Re: SQR Anyone?

In article <3p86i0$54u_at_redstone.interpath.net>, "Howard L. Curtis" <hcurtis_at_hcurtis.pdial.interpath.net> writes:
::From: "Howard L. Curtis" <hcurtis_at_hcurtis.pdial.interpath.net>
::Newsgroups: comp.databases.oracle
::Subject: Re: SQR Anyone?
::
::Timing's pretty good. A sales brochure just crossed my desk. I have a
::quick and dirty task in mind. The problem: We don't have a mid-tier
::(i.e. HPUX development platform) in place. The need: take MVS data,
::ftp to HPUX (data includes a BLOB) and update/insert into an Oracle
::7.0.16 database (the actual updates will be to several Oracle data
::structures comprising the "transaction."
::
::The Question: (1) can this be handled by SQR (2) how easily and (3) can
::SQR call PL/SQL blocks ?
::
::Thanks... -Howie
::
::

 Howie,  

 We have used SQR extensivley for loading/unloading tables to/from  flat files - Its a doddle

 Dunno about the blobs though - never used them.

 You can include PL/SQL in SQR or call stored procedures - take your choice.

 Feel free to mail me if you require any further information.

 Ian
 -

+--------------------------+-------------------------+-----------------------+
| Ian Bainbridge           | bainbridge.i_at_bgers.co.uk|Phone: (44)191-216-0202|
| British Gas ERS          | Newcastle Upon Tyne, UK |            x2790      |
+--------------------------+-------------------------+-----------------------+