Hi,
I have a table in the Oracle Database which as Three coloumns with metadata as
DOCUMENT_ID NUMBER 14
PAGE_NUM NUMBER 14
CONTENTS LONG
I want to dupe this data into a Sequnetial File, While i imported the Metadata through Manager and try to view the data in the Designer, it is not showing the data, So can any one know how to handle a coloumn in the DataStage which has datatype LONG in the Database.
Please throw some inputs.
Thanks
Chowdary.
LONG DataType
Moderators: chulett, rschirm, roy
Try to set the data type to VARCHAR and the width of the column to 4000. DS does not support CLOBS, so you'll have to fool the stage and see if it will bind using VARCHAR. If it does (I don't know your Oracle release or DS version) then you will be okay to pull upto 4000 chars from the column. Try upping the 4000 to the maximum you can get without error messages. Worst case, you'll have to spool the data using sqlplus and a query.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Thanks for the reply, I will give a shot for what you have suggested, for you info my database is Oracle 9i and DS is 7.5.kcbland wrote:Try to set the data type to VARCHAR and the width of the column to 4000. DS does not support CLOBS, so you'll have to fool the stage and see if it will bind using VARCHAR. If it does (I don't know your Oracle release or DS version) then you will be okay to pull upto 4000 chars from the column. Try upping the 4000 to the maximum you can get without error messages. Worst case, you'll have to spool the data using sqlplus and a query.
Thank you very much
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: