size of longnvarchar datatype (Datastage SQL Datatype)

userds · Post by **userds** » Tue May 17, 2005 8:53 am

Can anyone please let me know the size of longnvarchar SQL Datatype in Datastage 7.5 I am using this datatype in folder stage to retrieve an xml file which will then passed to xml input stage for loading into Oracle.

Using this datatype longnvarchar what will be the maximum size of file we can retrieve.

Thanks.

ArndW · Post by **ArndW** » Tue May 17, 2005 9:14 am

I think the LongVarChar is limited to 2Gb per Oracle, so that will be what DS limits it to. If you are still on an old-style disk system with a 2Gb file limit then your longvarchar limit in XML will be somewhat smaller than that - due to the XML text surrounding the string.

roy · Post by **roy** » Thu May 19, 2005 4:25 am

Hi,
I never seen a folder stage passing a bigger file then several hunderds of MB.
It is configurable or system dependant (I don't know how

) I assume since different machines had different thresh-holds.

Test the folder stage with large file to see your limit.

I'd recommend trying to use URLs, if you can, instead of folder stage.

IHTH,