biggexpress
IS-IT--Management
I've got a member that I'd like to run sql commands against and do not have command line access due to this system being an ASP. My only way to retrieve information is via IBM client access tools or using odbc connections. I prefer the later to use with web pages for many reasons.
I have a library called "ibger7" it contains a file called "arfile". "ARFILE" has a member called "arhst". This is the member that I'm trying to access.
Anyway, here is what I've tried:
select * from arhst
select * from arfile.arhst
select * from arfile(arhst)
select * from ibger7.arfile.arhst
select * from ibger7.arfile(arhst)
select * from IBGER7/ARFILE.ARHST
select * from IBGER7/ARFILE(ARHST)
I can't seem to figure it out. Given that I don't have command line, is there anything I can do with a SQL statement to accomodate my needs!?
Thanks,
Ryan
I have a library called "ibger7" it contains a file called "arfile". "ARFILE" has a member called "arhst". This is the member that I'm trying to access.
Anyway, here is what I've tried:
select * from arhst
select * from arfile.arhst
select * from arfile(arhst)
select * from ibger7.arfile.arhst
select * from ibger7.arfile(arhst)
select * from IBGER7/ARFILE.ARHST
select * from IBGER7/ARFILE(ARHST)
I can't seem to figure it out. Given that I don't have command line, is there anything I can do with a SQL statement to accomodate my needs!?
Thanks,
Ryan