Re: SQLLDR Loading Question

Oracle SQL*Loader: The Definitive Guide is the best book on the market for this
http://www.oreilly.com/catalog/orsqlloader/

Personally I would extract the mainframe data as much as possible, extract the numeric data unpacked and negate it if its negative. Then use the extract with Excel to clean it even further, make names, etc all uppercase and be sure users dont use mixed cases since oracle accepts mixed cases.

http://www.cathycakebread.com/papers/_tips.htm - has good conversion tips

http://www.uvsoftware.ca/sqljobs.htm

http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96652/ch06.htm#1006715
http://www.csee.umbc.edu/help/oracle8/server.815/a67792/ch05.htm
http://cma.zdnet.com/book/oracle/chapters/0-672-31148-8/ch16/ch16.htm

Good luck

George Received on Tue Feb 22 2005 - 22:25:01 CET