HOW TO HANDLE LONG DATATYPES

dr.murthy · Post by **dr.murthy** » Fri Jan 02, 2009 2:54 am

HI ,

iam working on datastage parallel jobs ,ver 7.5.1(a).my reqirement is extract the data from oracle8i database applying some trasformations and load it into target.when extracting the tables from oracle 8i through oci stage i found out some fields having datatype as LONG,but my ds version is not supporting LONG datatypes.

any suggestions .............

ray.wurlod · Post by **ray.wurlod** » Fri Jan 02, 2009 4:50 am

Search

dr.murthy · Post by **dr.murthy** » Fri Jan 02, 2009 4:55 am

ray.wurlod wrote:Search ...

hi ray.wurlod,

i searched in the dsxchange forums to get the solution for my issue.i haven't yet get.

ray.wurlod · Post by **ray.wurlod** » Fri Jan 02, 2009 5:01 am

Be more intuitive about your search criteria. An exact match search for "LONG data" returned 33 matches.

dr.murthy · Post by **dr.murthy** » Fri Jan 02, 2009 5:54 am

ray.wurlod wrote:Be more intuitive about your search criteria. An exact match search for "LONG data" returned 33 matches. ...

THANKS RAY,

FINALLY I GOT A SOLUTION,I JUST DEFINE THE DATATYPE AS VARBINARY AND LENGHT AS 1000000 WHILE EXTRACTING THE DATA FROM OCI8 AFTER I CHANGED THE DATATYPE AS VARCHAR.IT WORKS FINE

zuzuou · Post by **zuzuou** » Sun Jan 04, 2009 8:52 pm

A very useful experience,thanks!