Home » RDBMS Server » Server Utilities » Warning when using sql loader
icon1.gif  Warning when using sql loader [message #251362] Fri, 13 July 2007 04:48 Go to next message
ssunda6
Messages: 28
Registered: June 2007
Junior Member
Hi All,

I am using Datastage (an ETL Tool) to load data from a file to oracle table.

In oracle stage, when i specified UPSERT mode, I did not get any warnings.

But when used LOAD option(oracle in turn uses SQL Loader when specified this option), it is generating a warning:

Formatted length of fields and record (272) less than declared length (273)

In the control file, the record length is being shown as 272.

Any inputs would be of great help.

Thanx and regards,
ssunda
Re: Warning when using sql loader [message #251363 is a reply to message #251362] Fri, 13 July 2007 05:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is more a question for Datastage.
Is actual recordlength 272 or 273?
What does it do in UPSERT mode?
What is the control file?
What do the records look like?

Regards
Michel

[Updated on: Fri, 13 July 2007 05:50]

Report message to a moderator

Re: Warning when using sql loader [message #251376 is a reply to message #251363] Fri, 13 July 2007 06:52 Go to previous messageGo to next message
ssunda6
Messages: 28
Registered: June 2007
Junior Member

I couldnt figure out if the problem was with oracle or datastage.

Control file is the sql loader control file. It is automatically generated when we use LOAD option.

272 is the actual record length (as specified by sql loader control file)

The job appends data into oracle table. When we used UPSERT, performance of the job was low. Hence shifted to sql loader. The performance improved but this warning is coming. When UPSERT was used, we dint get this warning.

The records don't have field delimiters. Character set is EBCDIC and the data format is Binary.

Regards,
ssunda.
Re: Warning when using sql loader [message #251383 is a reply to message #251376] Fri, 13 July 2007 07:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is definitively a datastage problem.

Regards
Michel
Re: Warning when using sql loader [message #251390 is a reply to message #251383] Fri, 13 July 2007 07:21 Go to previous message
ssunda6
Messages: 28
Registered: June 2007
Junior Member
Thank you.

Regards,
ssunda
Previous Topic: Export problem
Next Topic: Using sql loader of 9i client to load data on Oracle 10g.
Goto Forum:
  


Current Time: Sun Dec 04 10:47:18 CST 2016

Total time taken to generate the page: 0.03992 seconds