Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Creation of tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
anadhamohan

New User


Joined: 27 Sep 2005
Posts: 25
Location: india

PostPosted: Wed Sep 28, 2005 10:34 am    Post subject: Creation of tables
Reply with quote

hi,
can anyone help me, i just want to create a table using QMF, what is the procedure should i follow to create a table.
also is there any option to create table from TSO/ISPF then which is the option to do so?

Thanks in advance
regards
anadha
Back to top
View user's profile Send private message

anadhamohan

New User


Joined: 27 Sep 2005
Posts: 25
Location: india

PostPosted: Wed Sep 28, 2005 3:27 pm    Post subject: Re: Creation of tables
Reply with quote

anadhamohan wrote:
hi,
can anyone help me, i just want to create a table using QMF, what is the procedure should i follow to create a table.
also is there any option to create table from TSO/ISPF then which is the option to do so?

Thanks in advance
regards
anadha
Back to top
View user's profile Send private message
karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Thu Sep 29, 2005 3:59 pm    Post subject: Re: Creation of tables
Reply with quote

hi,

Suppose in ur project more than one region is thre , first
u hve to use SET CURRENT command,

For example (in qmft just give this command)


SET CURRENT SQLID=regionname
CREATE TABLE regionname.tablename
(fieldname CHAR(4),
fieldname CHAR(4),
fieldname CHAR(7),
in databasename.tablespacename
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC;
commit;



Karthi G.
Back to top
View user's profile Send private message
anadhamohan

New User


Joined: 27 Sep 2005
Posts: 25
Location: india

PostPosted: Thu Sep 29, 2005 4:24 pm    Post subject:
Reply with quote

thanks kathir..
i'll try this one and let you know within two days..
can you suggest me for some Good books for db2 admin person..it'll be gr8 helpfull for me..
thanks again..
Back to top
View user's profile Send private message
anadhamohan

New User


Joined: 27 Sep 2005
Posts: 25
Location: india

PostPosted: Thu Sep 29, 2005 4:27 pm    Post subject:
Reply with quote

hi,
can any one tell me how to do this table creation and creation of load cards using JCL segment
thanks in advance
Back to top
View user's profile Send private message
karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Thu Sep 29, 2005 5:29 pm    Post subject: Re: Creation of tables
Reply with quote

Hi Mohan,


If u search in this Forum u can find the name of
good books for db2 admin.

Thnks

Karthi G.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts To know activities on db2 tables ashek15 DB2 4 Fri Mar 03, 2017 11:23 pm
No new posts ERM-Diagram of SysIBM-Catalog-Tables Auryn DB2 2 Fri Feb 17, 2017 6:22 pm
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us