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
 

 

Fetching a Particluar ROW

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

New User


Joined: 01 Oct 2008
Posts: 11
Location: Philadelphia, USA

PostPosted: Wed Oct 01, 2008 7:27 pm    Post subject: Fetching a Particluar ROW
Reply with quote

IS there any way to fetch a particular ROW id record thru any query or in FILEAID for DB2 ??

Actually i have done a Mass load on the table but while running the CHECK, one table is not going out of the CHECK PENDING.

As per the Spool, there is one record which has no Parent in the master table.

Since huge amount of data is involved i need to extract or see the record once.

ROW (RID=X'0001168702') HAS NO PARENT FOR TABLESPACE.TABLE.INDEXNAME
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Oct 01, 2008 9:36 pm    Post subject: Reply to: Fetching a Particluar ROW
Reply with quote

Hello,

Please do not post the same question multiple times - the other topic has been deleted.

d
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 Can we use OPTIMIZE FOR 1 ROWS for fe... cvijay784 DB2 1 Fri Aug 05, 2016 11:56 am
No new posts Fetching CLOB data suzeet COBOL Programming 2 Thu Jul 23, 2015 11:47 am
No new posts TBSARG fetching lastrecord of a Parti... iqbal.mallick TSO/ISPF 7 Wed Jun 11, 2014 12:44 pm
No new posts Error in fetching the details from PANEL Ramsee TSO/ISPF 11 Mon Nov 18, 2013 1:31 pm
No new posts fetching Job details from spool using... smijoss CLIST & REXX 6 Fri Jul 13, 2012 11:38 pm


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