Sql query over odbc from As400

[Gardi]

Hi I`m a bit confussed, my english is not so good, and so i am not sure if the Posts above solve my problem...

here is my task

i am working on a skript, which includes an sql query to an DSN, so far so good,

im using an odbc and i need a direct access, my db is an AS400 db and its called Ci98PROD

and my query is a kind of complicated^^

Querry:

(select vhistory, fo.fo_id from vhistory vh

inner join vinstanz vi on vi.vinstanz=vh.vinstanz

left outer join titel ti on ti.titel_nr=vi.ankervar1

left outer join forderun fo on fo.fo_nr=vi.ankervar1

where vh.vhistory ="value*")

union

(select vhistory, fo1.fo_id from vhistory vh

inner join vinstanz vi on vi.vinstanz=vh.vinstanz

left outer join titel ti on ti.titel_nr=vi.ankervar1

left outer join forderun fo1 on ti.leitford=fo1.fo_nr

where vh.vhistory ="vallue*")

* value that needs to be transformed

so my problem is, how can I get this in a script?

however, my programming skill is very low when it comes to such specific problems, can anybody help me out?