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
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
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    Post subject: How to view the db2-table by using file-aid
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    Post subject:
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    Post subject: Re: How to view the db2-table by using file-aid
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    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm


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