Import warning

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

Post Reply
Nagac
Premium Member
Premium Member
Posts: 127
Joined: Tue Mar 29, 2011 11:39 am
Location: India

Import warning

Post by Nagac »

ray.wurlod wrote:Or use pxEreplace() function, documented on DSXchange.
Hi ray,

I tried searching in this forum for this routine. I could not find it. Can you please tell me where it is? As i am getting warning messages while reading files with CR/LF format(Cobol files) Warning message is like we are reading the less no.of bytes something like that.

Can we resolve these warnings using this routine
jhmckeever
Premium Member
Premium Member
Posts: 301
Joined: Thu Jul 14, 2005 10:27 am
Location: Melbourne, Australia
Contact:

Post by jhmckeever »

pxEreplace (string, substring, replacement [ ,number ] )

viewtopic.php?t=106358
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Nagac
Premium Member
Premium Member
Posts: 127
Joined: Tue Mar 29, 2011 11:39 am
Location: India

Post by Nagac »

Do we have any other way to resolve the warning

Actual warning:
Import consumed only 39bytes of the record's 40 bytes (no further warnings will be generated from this partition)
input file is CFF file and CR/LR format.

I am not sure whether we can use this routine in this situation. If yes, what would be the string , substring and replacement number?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

This is not the same problem and really warranted a new thread. Actually it really warranted a search, in which you would have found that you need to set the Record Delimiter String property to "DOS style".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

ray.wurlod wrote:This is not the same problem and really warranted a new thread.
Done. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply