Hi,
Is there a way to read datasets using a DB stage as we do for a hash file with UV.
Reading a Dataset with a DB stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
No, DataSets are not "SQL" compatible and can only be read using the builtin stage or, for the brave, via the orchadmin dump command.
Last edited by ArndW on Thu Jul 29, 2010 6:02 am, edited 1 time in total.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
I should also have added that doing a "dump" of the dataset to a sequential file would only allow SQL-like queries when using an ODBC stage on that file. Rather complicated when DataStage itself allows some extended processing on data...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>