Q:
DB2 Select on a large number of rows/
I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the
records I want to select for example
MyFile: Contains the records I want to select
SELECT A.FELD1, A.FIELD2, B.FIELD1, B.FIELD2
FROM tableA A, tableB B
where A.acc = b.acc
AND a.acc in ( <myFile >)
records I want to select for example
MyFile: Contains the records I want to select
SELECT A.FELD1, A.FIELD2, B.FIELD1, B.FIELD2
FROM tableA A, tableB B
where A.acc = b.acc
AND a.acc in ( <myFile >)
ASKED:
Aug 22 2008 3:52 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
+1
Click to Vote:
+1
Click to Vote:
- 1
0
SELECT A.FELD1, A.FIELD2, B.FIELD1, B.FIELD2
FROM tableA A, tableB B
where A.acc = b.acc
AND a.acc in ( select column1 from my_table) <---
Steve
