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?

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 tasl 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?