sql*loader problems SOLVED

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Fri, 31 Aug 2001 08:51:37 -0700
Message-ID: <F001.0037F7B7.20010831090410@fatcity.com>

In case you are interested...

I found out what the problem was..  my numbers were padded with SPACES.  Freaking mainframe...

So here's how I solved it, after I dumped the whole thing in a VARCHAR2(4000) and substring'd it:

FPS_ACC_HK_POINTS1      POSITION(1281:1283)

                                        CHAR
                                        NULLIF FPS_ACC_HK_POINTS1=BLANKS
                                        "TO_NUMBER(REPLACE(:FPS_ACC_HK_POINTS1, CHR(0)))",
that should allow for me to post something off-topic next week!

Have a great weekend all

Lisa Koivu
Pc Breaker (I'm up to TWO!) and DBA
Ft. Lauderdale, FL, USA

GO VIKINGS !!!  WOO HOO! Received on Fri Aug 31 2001 - 10:51:37 CDT