OraFAQ Forum: Server Utilities » SQL Loader

Home » RDBMS Server » Server Utilities » SQL Loader - loading binary data fields

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Loader - loading binary data fields [message #181073]

Thu, 06 July 2006 10:51

roopuv
Messages: 1
Registered: July 2006

Junior Member

When trying to load EBCDIC data file using SQL loader, having issue with the fields which are defined as "COMP".

Cobol Declaration -
CC-YY PIC 9(04) COMP

Oracle Column -
CC_YY INTEGER

Control file specification -
CC_YY POSITION(100:101) INTEGER

Example of one record -
Value of "1994" but its getting loaded as "-151729657"

Not sure if I am using right data representation in CTL file,
would be great if anyone knows a workaround.

Thanks,
Roop

Report message to a moderator

Previous Topic:	using sqlldr i am not able to add data more than 255 character in Varchar2(4000) defined field
Next Topic:	unable to load data using SQLLDR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 20:27:28 CDT 2024