Using Text files as Tables

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
asitagrawal
Premium Member
Premium Member
Posts: 273
Joined: Wed Oct 18, 2006 12:20 pm
Location: Porto

Using Text files as Tables

Post by asitagrawal »

Hi,


Has any one tried using a text file ( created using the Sequential File Stage ) by configuring an ODBC for text files ??
My idea is to be able to treat the file with some SQL queries...
Share to Learn, and Learn to Share.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Perfectly functional, provided your text files meet the requirements of the ODBC text driver (column headings, no "strange" rows).

Just don't complain about the speed.
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