using sequential file column value in SQL query

Maximus_Jack · Post by **Maximus_Jack** » Mon Sep 24, 2012 12:00 am

Hi
Is there any way i can use a sequential file column value in a SQL query?
like.......

Oracle SQL Query
===========

insert into tablename1 ( col1)
select col1
from tablename2
where col2 in ( dslink.col1)

ray.wurlod · Post by **ray.wurlod** » Mon Sep 24, 2012 12:22 am

I guess you could define an "external table" in the Oracle database, that refers to the sequential file, and perform the join on that basis.

Other than that, not really.

chulett · Post by **chulett** » Mon Sep 24, 2012 6:33 am

Like.... what? Which part of your example is the "sequential file column value"?

As noted, unless you pass the value as a parameter you'd need an external table to use the file as if it were a table in a SQL query.