ASP (Auxiliary Storage Pool) / SQL problem.

[g***@yahoo.com]

Hello,

I have a C application, ('spawn'ed by another application), which is
using precompiled SQL (for dynamic SELECT statements);

The C application is only able to access to files located in the system
ASP.
I get a -204 error if I try to access files located in another ASP.
I would like to be able to access files in another ASP

I have tried to run "SETASPGRP MyASP" in the C application, with the
help of the C system() function, but it does not seem to help.

Does someone know what I should do to access a specific ASP please ?
Is there an API to use ? or should I compile with a specific parameter
?
or ... ?

Thanks in advance for any help,
kind regards,
olivier.

[Rodney Johnson]

The approach you use to access DB information in an ASP group is through
the DB name. Historically there was only one DB on a iSeries
partition. With the introduction of independent disk pools (iASPs),
each iASP group was treated as an independent DB.

Go to the iSeries information center and read through the independent
disk pools (under disk management) topic. There should be some red
books as well. Somewhere I got to believe there is a discussion on how
to access the db in an iASP.

Post by g***@yahoo.com
Hello,
I have a C application, ('spawn'ed by another application), which is
using precompiled SQL (for dynamic SELECT statements);
The C application is only able to access to files located in the system
ASP.
I get a -204 error if I try to access files located in another ASP.
I would like to be able to access files in another ASP
I have tried to run "SETASPGRP MyASP" in the C application, with the
help of the C system() function, but it does not seem to help.
Does someone know what I should do to access a specific ASP please ?
Is there an API to use ? or should I compile with a specific parameter
?
or ... ?
Thanks in advance for any help,
kind regards,
olivier.

--
Rodney A Johnson
Technical Team Lead for AS/400 Spool
Dept GJC
IBM Rochester, Minnesota

The contents of this message express only the sender's opinion.
This message does not necessarily reflect the policy or views of
my employer, IBM. All responsibility for the statements
made in this Usenet posting resides solely and completely with the
sender.

[g***@yahoo.com]

Thank you for the answer.

I have not found the discussion you were mentioning, but I have found
out how it's working now, so my problem is solved.

Kind regards,
olivier.