DSXchange: DataStage and IBM Websphere Data Integration Forum
  Home  •  Forum  •  Search  •  Favorites  •  Register  •  Log in
Usergroups  •  Contact  •  FAQ  •  Privacy Policy  •  Log in to check your private messages
Record Length of a sequential file
 View next topic
View previous topic
Add To Favorites
Post new topic   Reply to topic    DSXchange Forum Index » IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Author Message
olgc
Participant



Joined: 18 Nov 2003
Posts: 116

Points: 1336
Post Posted: Fri Sep 21, 2012 2:20 pm Reply with quote    Back to top    
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi there,

In the record length field of a sequential file stage, only one choice: fixed. How can variable be chosed? When the empty is chosen, it's changed back to fixed. Except fixed, what can be chosen?

Thanks,
View user's profile  Send private message    
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 49968
Location: Canberra, Australia
Points: 271564
Post Posted: Fri Sep 21, 2012 3:19 pm Reply with quote    Back to top    
Fixed is the only choice. You specify the actual length through choice of data type for each individual column.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong
Delivering Outcomes Together
View user's profile  Send private message  Send e-mail  Visit poster's website
Rate this response: 0  1  2  3  4  5   
Not yet rated
olgc
Participant



Joined: 18 Nov 2003
Posts: 116

Points: 1336
Post Posted: Mon Sep 24, 2012 1:09 pm Reply with quote    Back to top    
Thanks ray.wurlod, 8.7 does not support variable length of records. Only fixed length of record. Then the length of a record is fixed. You don't have choice. The length of the record is calculated from its columns. Why is there for you to type in the length? That's a drawback of 7.5. What's the reason?

Thanks,
View user's profile  Send private message    
Rate this response: 0  1  2  3  4  5   
Not yet rated
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 15367
Location: Germany
Points: 86605
Post Posted: Tue Sep 25, 2012 3:52 am Reply with quote    Back to top    
olgc wrote: ...8.7 does not support variable length of records. Only fixed length of record... No, that is incorrect. If you do not specify a length then the record is deemed to be of va ...

_________________

Image
View user's profile  Send private message  Send e-mail  Visit poster's website
Rate this response: 0  1  2  3  4  5   
Not yet rated
Display posts from previous:       
Post new topic   Reply to topic    DSXchange Forum Index » IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)


 Jump to:   



Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours