How to view the db2-table by using file-aid

karthikuma · New User Joined: 29 Mar 2005 Posts: 65

hi,

how to view the db2-table by using file-aid.give me the options.

regards,
kumar

ashokreddy · New User Joined: 20 May 2005 Posts: 4 Location: india

hi karthik,
on primary option menu type fd(fileaid db2) and then you will get a screen just like normal fileaid, then you can use browse,edit,view. same as normal fileaid.

after typing FD, YOU WILL GET THE BELOW SCREEN

1 DB2T - TEST
2 DB2P - PRODUCTION
3 DB2W - DATA WAREHOUSE

then select an option.

0 DEFAULTS and USER PARMS TIME - 02:50
1 BROWSE TERMINAL - 3278
2 EDIT PF KEYS - 24
3 UTILITIES
3.2 - Create, Drop, Alter DB2 Objects
3.3 - Copy Rows Between Tables
3.4 - Object List Processing
3.5 - SQL Command Manager
3.6 - Display, Grant, Revoke or Modify DB2 Privileges
3.7 - Extract and Load Tables
3.8 - DBA-XPERT Column Impact Analysis
4 SQL ANALYSIS - SQL Development and Analysis
5 PRINT - Print table Data or Audit Trail
6 RELATIONSHIPS - Maintain relationship definitions
R File-AID/RDX - Transfer to File-AID/Related Data XPERT
XP XPEDITER - Transfer to XPEDITER
T TUTORIAL - Display information about File-AID for DB2
X EXIT - Exit File-AID for DB2

if we press 3.7

1 - Extract from a Table to a dataset

2 - Load from a dataset to a Table

bye,
ashok

karthikuma · New User Joined: 29 Mar 2005 Posts: 65

hi,

thankz a lot friend ,but i'm still having doubt on file-aid,by presing 3.7 we can directly view the DB2 contents.plz give me explanation how to see the DB2 table.plz any one give me a sugestion.

regards
kumar