Extracting Data

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
pradkumar
Charter Member
Charter Member
Posts: 393
Joined: Wed Oct 18, 2006 1:09 pm

Extracting Data

Post by pradkumar »

Hi

I am trying to extract the data from a table.
I am using a DRS stage as source.I loaded the table definitions and thereby columns.

When I click on View Data button, it is giving warning as
"OCI has fetched truncated data"
When i say ok, it is displaying some of the data.

what might be the problem?
Pradeep Kumar
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

Do a search on "OCI has fetched truncated data", Check if any of the results help you. I got 15 results, I did not check if they got resolved though.
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Could you post the database metadata here - there are occasionally datatype issues where the type isn't loaded in correctly
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Datatype and data length issues.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply