Page 1 of 1
Reading a Dataset with a DB stage
Posted: Wed Jul 28, 2010 9:05 am
by arunkumarmm
Hi,
Is there a way to read datasets using a DB stage as we do for a hash file with UV.
Posted: Wed Jul 28, 2010 9:55 am
by ArndW
No, DataSets are not "SQL" compatible and can only be read using the builtin stage or, for the brave, via the orchadmin dump command.
Posted: Wed Jul 28, 2010 11:21 am
by arunkumarmm
Thank You! ArndW...
I will go for the Built-In, Not grown that brave yet
Posted: Thu Jul 29, 2010 6:04 am
by ArndW
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...