I am given a requirement to load a sequential file to oracle table.
The sequential file has 133 rows, each row has a final delimiter end.
In the Oracle table, there are two coulmns
1.Clob column
2.filename column.
In the clob column , I need to load load the entire 133 rows as a single row..
When I loaded the data, it is loaded as 133 rows in clob.
Is the requirement a valid one? Can we really achieve this requirement (loading 133 rows delimited by end character into oracle clob as a single row)?
loading sequential file to Oracle CLOB
Moderators: chulett, rschirm, roy
loading sequential file to Oracle CLOB
--
Swathi Ch
Swathi Ch
You might have to play around with the definitions a bit, but it is workable.
Try setting the variable type on your field to LongVarChar with a length > 32K (the Oracle API stage requires it, not certain about other stages).
Also - try setting the file properties (Format Tab) to have a Record Level, Record Type property of "implicit". That should read in the entire file as one big string.
You'll have to pass in your filename as a parameter and add that as the second field in a transformer.
Let me know if it works - don't have access to Oracle at this site.
Try setting the variable type on your field to LongVarChar with a length > 32K (the Oracle API stage requires it, not certain about other stages).
Also - try setting the file properties (Format Tab) to have a Record Level, Record Type property of "implicit". That should read in the entire file as one big string.
You'll have to pass in your filename as a parameter and add that as the second field in a transformer.
Let me know if it works - don't have access to Oracle at this site.
Thanks for your reply,
I tried to read the sequential file by using the below options
Record level:
final delimeter-none
record type- Implicit
Field defaults:
Delimeter - none
Quote - none
I have defined only one column in the sequential as record1 longvarchar(10000000).
After setting this options I could read the sequential file as 40 rows instead of a single row. Is there any other option i need to set in the properties?
I tried to read the sequential file by using the below options
Record level:
final delimeter-none
record type- Implicit
Field defaults:
Delimeter - none
Quote - none
I have defined only one column in the sequential as record1 longvarchar(10000000).
After setting this options I could read the sequential file as 40 rows instead of a single row. Is there any other option i need to set in the properties?
--
Swathi Ch
Swathi Ch