query in server jobs

sunitha_cts · Post by **sunitha_cts** » Thu Jun 18, 2009 7:29 am

Hi,

My data is in as/400 In As/400, we had to run multiple queries that is done in by using sequeals but now we are migrating that data is in form of flat files ,now in datstage server edition so how can we run those multipe queries .,and extract a single column data.
Thanks
sunitha

ArndW · Post by **ArndW** » Thu Jun 18, 2009 7:32 am

My suspicion is that the answer is going to be "you can't". Specifically what kind of queries - SQL type subselects? DataStage will allow you to do certain joins and queries but SQL is limited to databases.

chulett · Post by **chulett** » Thu Jun 18, 2009 7:36 am

If you really need to use sql for these joins, you may end up needing to load the files into work/temp tables in an accessible database and perform them there.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 18, 2009 4:32 pm

Why can't you just use the DB2 stage and connect through DB2 Connect to the DB2/400 database?

chulett · Post by **chulett** » Thu Jun 18, 2009 4:43 pm

From my reading of the post, the source was DB2 but is now flat files.