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

Obtaining data from DB2 table based on field position


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
nmr4u

New User


Joined: 14 May 2007
Posts: 9
Location: India

PostPosted: Wed Sep 05, 2007 10:47 am
Reply with quote

Hi,

I would need to retrieve data from a DB2 table based on the field position in the database record. I don't have the field name. This needs to be a part of a COBOL-DB2 program.

How could this be achieved?

Thanks,
Mohan
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Thu Sep 06, 2007 12:59 am
Reply with quote

Hello,

I'd suggest you do the research and find the field name. If you have the table name, you can easily get the column names (either by a query or from your DBAs).

"Field position" is not used in database applications.
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 -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Store the data for fixed length COBOL Programming 1
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
Search our Forums:

Back to Top