DevOps, CI/CD and Automation

Hello,

I have the following select statement and it works fine.
SELECT extractvalue(ISBN_PAYLOAD, '/ISBNdb/BookList/BookData/Subjects/Subject[1into Subject1
FROM LIB_ISBN_T
WHERE LIB_ISBN_T_PK = 1;

It returns the first subject.

I'd like to loopy through all the subjects, replacing the "1" by a numeric variable. I tried the following, and I get blanks.

SELECT extractvalue(ISBN_PAYLOAD, '/ISBNdb/BookList/BookData/Subjects/Subject[(Current_Count)into Subject1
FROM LIB_ISBN_T
WHERE LIB_ISBN_T_PK = 1;

In a Select / Extractvalue statement, how can I replace the value inside of the square brackets with a variable?

Many Thanks