DSXchange

I cannot find any information about DataStage support for Geospatial data types, such as shape files, coordinates, etc.

Has anyone used DataStage for this purpose?

DataStage does not even support CLOBs or LOBs, only the "BASIC" things.

Ogmios

Hi,
Ogmios is right.
the only thing I can think of regarding this is that if you can do it with a client of your DB you can create, using DS, the sql statement and send it to your DB ( might need to transfer the data file/s to the DB server ) or invoke the client software utilities to perform the task from your DS server if possible.

IHTH,

If you think about it, there's no valid "transformation" you would do with these data types.
DataStage can move them, but only if they're encoded into a text stream first. But why would you use DataStage just to move things, when FTP is so much cheaper and, some would argue, simpler?