Unable to load LONG data.

ArndW · Post by **ArndW** » Wed Jun 20, 2007 1:00 am

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

ArndW · Post by **ArndW** » 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?

ArndW · Post by **ArndW** » 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?

chulett · Post by **chulett** » 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.