Page 1 of 1

390 DB2I DCLGEN Source Table Setup for SPUFI

PostPosted: Mon Mar 03, 2008 2:26 am
by ignacio
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.

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

PostPosted: Mon Mar 03, 2008 6:07 am
by dick scherrer
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.

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

PostPosted: Mon Mar 03, 2008 8:42 pm
by ignacio
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.

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

PostPosted: Mon Mar 03, 2008 9:16 pm
by dick scherrer
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.

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

PostPosted: Sun Mar 09, 2008 5:07 pm
by ignacio
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.

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

PostPosted: Tue Mar 11, 2008 8:07 am
by dick scherrer
Best of luck to you :)

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

d

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

PostPosted: Mon Apr 28, 2008 5:15 pm
by progressabhi1
I think this table's query will help u in what u r searching for.
SELECT * FROM SYSIBM.SYSDBAUTH;

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

PostPosted: Mon Apr 28, 2008 5:24 pm
by progressabhi1
cont.

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

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

PostPosted: Mon Apr 28, 2008 5:40 pm
by progressabhi1
SELECT DBNAME, TSNAME, CREATOR, NAME, CREATEDTS, ALTEREDTS
FROM SYSIBM.SYSTABLES
WHERE CREATOR='RBIRTGS' AND TYPE='T';

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