Reading a Dataset with a DB stage

arunkumarmm · Post by **arunkumarmm** » Wed Jul 28, 2010 9:05 am

Hi,

Is there a way to read datasets using a DB stage as we do for a hash file with UV.

ArndW · Post by **ArndW** » Wed Jul 28, 2010 9:55 am

No, DataSets are not "SQL" compatible and can only be read using the builtin stage or, for the brave, via the orchadmin dump command.

arunkumarmm · Post by **arunkumarmm** » Wed Jul 28, 2010 11:21 am

Thank You! ArndW...

I will go for the Built-In, Not grown that brave yet

ArndW · Post by **ArndW** » Thu Jul 29, 2010 6:04 am

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...