View previous topic :: View next topic
|
Author |
Message |
anadhamohan
New User
Joined: 27 Sep 2005 Posts: 25 Location: india
|
|
|
|
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 |
|
|
anadhamohan
New User
Joined: 27 Sep 2005 Posts: 25 Location: india
|
|
|
|
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 |
|
|
karthi_ind
Active User
Joined: 24 Feb 2004 Posts: 131 Location: Chennai
|
|
|
|
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 |
|
|
anadhamohan
New User
Joined: 27 Sep 2005 Posts: 25 Location: india
|
|
|
|
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 |
|
|
anadhamohan
New User
Joined: 27 Sep 2005 Posts: 25 Location: india
|
|
|
|
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 |
|
|
karthi_ind
Active User
Joined: 24 Feb 2004 Posts: 131 Location: Chennai
|
|
|
|
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 |
|
|
|