IBM Mainframe Forum

Hi all. I am a new member.
Which command will inform me about the value of the parameter SOURCE TABLE NAME in the DB2I.DCLGEN menu, to allow me to execute sql sentences with SPUFI?
I have added extended information at this web: http://docs.google.com/Doc?id=dfcv7kck_2cdvkqqd3

Kind regards,

Ignacio.

Hello,

I'd suggest you talk with your dba for a list of table names that your id or group has permission(s) to use.

There is no dba available in this system. In AS400, the smaller brother of 390, you just need one command to know the list of tables that you can access from your user profile or group. I thought it should not be that complicated in s/390-z.

Regards,
Ignacio.

Hello,

The as400 is nowhere near a "little brother" to os390 or z_os. The as400 is largely operated by clerks rather than data processing professionals. They are often/usually installed "turn-key" and do not have a local technical support staff - they are primarily "user" systems rather than development systems (at least the several hundred i've seen).

The os390/z_os world has far more capability and is almost always supported by multiple admin people. Someone is responsible for db2 on the system you are using. Whoever that is, can get a list of tables that you have permission to use. It is not complicated, it is just not the same as the as400 environment.

I paid a course thru the web. Now the system admin is not available since the course has finished. I have an extended time period because I started the course after it began, but without system admin. But I think I am going to give it up.
Regards.
Ignacio.

Best of luck to you

When you start working on a system and have questions, someone will be here.

d

I think this table's query will help u in what u r searching for.
SELECT * FROM SYSIBM.SYSDBAUTH;

cont.

select * from sysibm.SYSTABAUTH;
here this sort of information u can get:-
GRANTOR GRANTEE GRANTEETYPE DBNAME

SELECT DBNAME, TSNAME, CREATOR, NAME, CREATEDTS, ALTEREDTS
FROM SYSIBM.SYSTABLES
WHERE CREATOR='RBIRTGS' AND TYPE='T';

WHERE CREATOR= ‘Creator name’ AND TYPE=’T’