Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
krishna81
Premium Member
Posts: 78 Joined: Tue May 16, 2006 8:01 am
Location: USA
Post
by krishna81 » Thu Mar 11, 2010 3:05 pm
Hi Folks,
How can we read file by giving more than one string as a Record delimiter in CFF stage.
Here is My job flow
Mq --->Seq(Here i am creating file with ~~ as record delimiter)
Reading above file using CFF
CFF --->Peek
Thanks
Krish
Datastage User
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Mar 11, 2010 3:22 pm
Use Record Delimiter String property rather than Record Delimiter property.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
krishna81
Premium Member
Posts: 78 Joined: Tue May 16, 2006 8:01 am
Location: USA
Post
by krishna81 » Fri Mar 12, 2010 8:58 am
I did not see Record delimiter string property in CFF stage.We are using 8.0.1 verson.
Datastage User
asorrell
Posts: 1707 Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas
Post
by asorrell » Fri Mar 12, 2010 9:35 am
Is there any particular reason you are using the CFF stage to read it? I normally use that just to read COBOL data. If you used a sequential file to create the file, why not use a sequential file to read the file?
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Mar 12, 2010 9:46 am
Yes... what is the C in your FF?
-craig
"You can never have too many knives" -- Logan Nine Fingers
krishna81
Premium Member
Posts: 78 Joined: Tue May 16, 2006 8:01 am
Location: USA
Post
by krishna81 » Fri Mar 12, 2010 10:07 am
Yes There is specific reason why i am using CFF stage.I have to split the date based on my record type.
For chulett C is Complex
Datastage User
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Fri Mar 12, 2010 10:12 am
Stage -> Record Options -> Record Delimiter.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Mar 12, 2010 10:32 am
krishna81 wrote: For chulett C is Complex
That I know. What I was asking was: what is the Complexity of your Flat File? What was driving you to using the CFF stage in other words.
-craig
"You can never have too many knives" -- Logan Nine Fingers
krishna81
Premium Member
Posts: 78 Joined: Tue May 16, 2006 8:01 am
Location: USA
Post
by krishna81 » Fri Mar 12, 2010 2:12 pm
Here my source is MQ.Because of this i am writing data using Seq file stage and later using CFF to read the same.
The reason i am using CFF is the data iis in hexa and variable length.
Still i am wondering the Record Delimiter String property is not there in CFF stage as Ray mentioned above.
Datastage User
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Mar 12, 2010 3:44 pm
Look again, if it is truly not there then perhaps it was something added in a later version / patch, in which case I would check with your official support provider.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Sat Mar 13, 2010 2:32 pm
I'm not able to check now. But the Sequential File stage definitely has it, as does the Column Import stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Mon Mar 15, 2010 2:12 am
krishna81 - I think you missed my post.
ArndW wrote: Stage -> Record Options -> Record Delimiter.