Olq Batch

[Michael J. Moore]

Hello,
I am running an olq batch job that outputs into a file. I then take the file
and FTP it to a PC where I try to use sqlldr.exe to load it into an Oracle
database. Oracle's loader is supposed to be able to deal with ZONE DECIMAL
and COMP-3 fields, but I am running into a lot of trouble. ALPHA/NUMERIC
DISPLAY fields are NO problem. So in order to get around the problem I would
like to have OLQBATCH output every field as a DISPLAY field.

Is there a way to do this and still use the OUTPUT OUTFILE command?
I hesitate to use the DISPLAY command because then I have to deal with
headers and other problems like what happens if the data is more than 132
characters.

To make matters more challenging, I don't have a manual.
Thanks for any help or advice.
Mike

[Cherlet, Gary , JTD]

I don't have an OLQ manual handy either - but there is a NOHEADER or
NOOLQHEADER option that can be set - so you woould be able to use the
DISPLAY command. The other option would be to use Culprit - the world's best
data extraction tool IMHO.

Cheers - Gary

[Anh Wong - Fairfax]

Do you have the IDMS SQL Option ? We do a lot of downloading to Oracle and
other SQL databases. From the OLQ reports display, we invoke TABLE and save
the data as a SQL table. From there we use Visual Express and ODBC to access
the data and export it to other databases. No JCL and no manual
intervention. If you need more information, my email is
awo...@co.fairfax.va.us
Anh Wong
Fairfax County Govt

[Jim Phillips]

SQL Loader can't handle a number which is written to the file as packed or
zoned and then ftp'd as ASCII. Neither can it handle a file which is ftp'd
without translation.

You'll have to translate the data to display on the mainframe, insert the
decimal points and send the converted data. You may also want to scan the
character data for embedded quotes and double them. Since the target is
Oracle you'll also need a whole bunch of control statements to tell SQL
Loader what the table looks like.

I don't know how one goes about doing all this with OLQ since I work for a
firm which provides tools for this sort of thing.

Jim Phillips
(800) 295-7608 x23
www.ispinfo.com

>From: "Michael J. Moore" <Michael...@WCOM.COM>
>Reply-To: IDMS Public Discussion Forum <IDM...@LISTSERV.IUASSN.COM>
>To: IDM...@LISTSERV.IUASSN.COM
>Subject: Olq Batch
>Date: Wed, 14 Mar 2001 14:01:17 -0800
>
>Hello,
>I am running an olq batch job that outputs into a file. I then take the
>file
>and FTP it to a PC where I try to use sqlldr.exe to load it into an Oracle
>database. Oracle's loader is supposed to be able to deal with ZONE DECIMAL
>and COMP-3 fields, but I am running into a lot of trouble. ALPHA/NUMERIC
>DISPLAY fields are NO problem. So in order to get around the problem I
>would
>like to have OLQBATCH output every field as a DISPLAY field.
>
>Is there a way to do this and still use the OUTPUT OUTFILE command?
>I hesitate to use the DISPLAY command because then I have to deal with
>headers and other problems like what happens if the data is more than 132
>characters.
>
>To make matters more challenging, I don't have a manual.
>Thanks for any help or advice.
>Mike

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

[Michael J. Moore]

Okay, thanks for the thoughts. I completely forgot about Culprit. It's been
a very long time.
Thanks to all you other people who replied. Basically I get that my FTP is
corrupting my
comp-3 and possibly my signed decimal fields.

Since this is a ONE-TIME project ( which means it will probably go on
forever ) I think that
I will use OLQBATCH DISPLAY when dealing with numeric fields. This may force
me to split
up the data due to the width limit of a DISPLAY, but I can always re JOIN
the data on the
PC/ORACLE side.

regards,
Mike

-----Original Message-----
From: IDMS Public Discussion Forum [mailto:IDM...@LISTSERV.IUASSN.COM]On
Behalf Of Cherlet, Gary (JTD)
Sent: Wednesday, March 14, 2001 3:01 PM
To: IDM...@LISTSERV.IUASSN.COM