Geospatial data types?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
rdy
Participant
Posts: 38
Joined: Wed Nov 05, 2003 2:40 pm

Geospatial data types?

Post by rdy »

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?
ogmios
Participant
Posts: 659
Joined: Tue Mar 11, 2003 3:40 pm

Re: Geospatial data types?

Post by ogmios »

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

Ogmios
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

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,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply