IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
karthikuma

New User


Joined: 29 Mar 2005
Posts: 62

PostPosted: Thu May 19, 2005 11:26 am
Reply with quote

hi,

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

regards,
kumar
Back to top
View user's profile Send private message
ashokreddy

New User


Joined: 20 May 2005
Posts: 4
Location: india

PostPosted: Fri May 20, 2005 12:23 pm
Reply with quote

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
Back to top
View user's profile Send private message
karthikuma

New User


Joined: 29 Mar 2005
Posts: 62

PostPosted: Mon May 23, 2005 10:22 am
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts Selecting the max value from a file. DFSORT/ICETOOL 3
No new posts Change history of vsam file. JCL & VSAM 3
No new posts Split large FB file based on Key coun... DFSORT/ICETOOL 4
No new posts EMPTY file check scenario JCL & VSAM 6
No new posts SORT deletes the SORTOUT file DFSORT/ICETOOL 8
Search our Forums:

Back to Top