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

header in View


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

New User


Joined: 04 Dec 2006
Posts: 44
Location: Pune,India

PostPosted: Fri Sep 30, 2011 10:46 pm
Reply with quote

Hello all,

Require your urgent help in one issue Iam facing.
I am creating a view by joining several tables and then unloading the data to a dataset using the unload criteria. While I am unloading, I require the headers which resembles the column name also to be present in the dataset.

appreciate a quick response.
many thanks
Prasanth
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: Fri Sep 30, 2011 11:19 pm
Reply with quote

Hello,

You have been long enough to understand we don't do urgent . . .

One easy way to do what i believe you want is to add a step to generate a delimited "header" using the same dcb attributes the unloaded file has.

Then concatenate both with the header first.
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 SET PATH in View DDL DB2 2
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts Insert header record with record coun... DFSORT/ICETOOL 14
No new posts Issues with VIEW DATASET Command CLIST & REXX 2
No new posts Difference when accessing dataset in ... JCL & VSAM 7
Search our Forums:

Back to Top