390 DB2I DCLGEN Source Table Setup for SPUFI



IBM's flagship relational database management system

390 DB2I DCLGEN Source Table Setup for SPUFI

Postby ignacio » Mon Mar 03, 2008 2:26 am

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.
ignacio
 
Posts: 5
Joined: Sun Mar 02, 2008 10:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

Postby dick scherrer » Mon Mar 03, 2008 6:07 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

Postby ignacio » Mon Mar 03, 2008 8:42 pm

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.
ignacio
 
Posts: 5
Joined: Sun Mar 02, 2008 10:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

Postby dick scherrer » Mon Mar 03, 2008 9:16 pm

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

Postby ignacio » Sun Mar 09, 2008 5:07 pm

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.
ignacio
 
Posts: 5
Joined: Sun Mar 02, 2008 10:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

Postby dick scherrer » Tue Mar 11, 2008 8:07 am

Best of luck to you :)

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

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

Postby progressabhi1 » Mon Apr 28, 2008 5:15 pm

I think this table's query will help u in what u r searching for.
SELECT * FROM SYSIBM.SYSDBAUTH;
progressabhi1
 
Posts: 17
Joined: Tue Apr 01, 2008 6:07 pm
Has thanked: 0 time
Been thanked: 0 time

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

Postby progressabhi1 » Mon Apr 28, 2008 5:24 pm

cont.

select * from sysibm.SYSTABAUTH;
here this sort of information u can get:-
GRANTOR GRANTEE GRANTEETYPE DBNAME
progressabhi1
 
Posts: 17
Joined: Tue Apr 01, 2008 6:07 pm
Has thanked: 0 time
Been thanked: 0 time

Re: 390 DB2I DCLGEN Source Table Setup for SPUFI

Postby progressabhi1 » Mon Apr 28, 2008 5:40 pm

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

WHERE CREATOR= ‘Creator name’ AND TYPE=’T’
progressabhi1
 
Posts: 17
Joined: Tue Apr 01, 2008 6:07 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post