DSXchange

Posted: **Wed Jun 20, 2007 1:00 am**

The answer is to lie to DataStage. Specify a length of 2Gb for the field.

Posted: **Wed Jun 20, 2007 1:28 am**

Are you reading from or writing to this stage? In your first post you stated "loading" but now I am not sure. It seems that the OCI stage has truncated the string, so the OCI stage definitions are relevant.

In DataStage Server the length of a VarChar field does not actually limit the length of the string that is stored.

I don't have access to DS right now, but I do remember that Longvarchar or BLOBs have a limit of 2Gb.

Have you looked into the Oracle PDF file to see if it makes mention of the limitations?

Posted: **Wed Jun 20, 2007 2:23 am**

The quote from the documentation recommends choosing a length greater than 4Kb.

Are you reading from or writing to the database?

Posted: **Wed Jun 20, 2007 6:55 am**

How exactly was this 'resolved'? Can you please post that so the rest of the world knows? Thanks.

DSXchange

Unable to load LONG data.