Jump to content

Sql query over odbc from As400


Gardi
 Share

Recommended Posts

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?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...