IBM Unload/Load Question

Sam Orner

IBM Unload/Load Question
I am using IBM's unload and load utilities under DB2 V8. The unload places
spaces (x'40') for a decimal nullable field in the output unload file, as
well as the leading null indicator (x'FF'). When I use the load without
using field specifications, it fails when it reads the decimal field data.
If I use field specifications in the load, I.E, for a decimal
column....NULLIF a certain position = x'FF'....the load works.

I need to be able to load a table without field specifications. What
option(s) in the unload do I need to make this work.

Sam Orner
Senior Database Administrator
Information Technology / Architecture & Technology
[login to unmask email] / 717-720-2925


=====
This message contains privileged and confidential information intended for the above addressees only. If you
receive this message in error please delete or destroy this message and/or attachments.

The sender of this message will fully cooperate in the civil and criminal prosecution of any individual engaging
in the unauthorized use of this message.
=====

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Phil Grainger

Re: IBM Unload/Load Question
(in response to Sam Orner)
Before we answer that, what do you want to have loaded when you unload
one of these null decimal columns?

Phil Grainger
CA
Senior Principal Product Manager
Phone: +44 (0)1753 577 733
Mobile: +44 (0)7970 125 752
eMail: [login to unmask email]

Ditton Park
Riding Court Road
Datchet
Slough
SL3 9LL

CA plc a company registered in England and Wales under company
registration number 1282495 with its registered office at the address
set out above. VAT number 697904179.



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Sam Orner
Sent: 11 December 2008 16:05
To: [login to unmask email]
Subject: [DB2-L] IBM Unload/Load Question

I am using IBM's unload and load utilities under DB2 V8. The unload
places
spaces (x'40') for a decimal nullable field in the output unload file,
as
well as the leading null indicator (x'FF'). When I use the load without
using field specifications, it fails when it reads the decimal field
data.
If I use field specifications in the load, I.E, for a decimal
column....NULLIF a certain position = x'FF'....the load works.

I need to be able to load a table without field specifications. What
option(s) in the unload do I need to make this work.

Sam Orner
Senior Database Administrator
Information Technology / Architecture & Technology
[login to unmask email] / 717-720-2925


=======================
======
This message contains privileged and confidential information intended
for the above addressees only. If you
receive this message in error please delete or destroy this message
and/or attachments.

The sender of this message will fully cooperate in the civil and
criminal prosecution of any individual engaging
in the unauthorized use of this message.
=======================
======

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms