V7 Load Problem

Susan Lawson

V7 Load Problem
Hello all,

I have a quick question...

We are running an IBM Load utility in V7 attempting to
Load a field defined as integer external into a
smallint column.

The input can be a number, blank or hex zeros. The
numbers and zeros load fine, but we are getting
conversion errors on the blanks (we are using NULLIF).

Any thoughts?


Susan Lawson
DB2 UDB OS/390 & z/OS Certified DBA
IBM DB2 and S/390 Gold Consultant
Database Performance Professionals

Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com