Page 1 of 1
Datastage PX Warning: Import consumed only 27bytes of the re
Posted: Mon Aug 04, 2008 9:41 am
by hemanthakumar
Hi,
My source is sequential file .txt formate,while loading to the target sequential file iam getting some contol characters in source file.How to remove the control characters in source sequential file.
Posted: Mon Aug 04, 2008 3:16 pm
by ray.wurlod
What "control characters" are you getting in your data?
Posted: Mon Aug 04, 2008 10:37 pm
by chulett
You need to determine what that character actually is - the ASCII value. Do you have a hex editor/viewer on your server? Can you do an "od -x" (or something similar) on the file?
Also, where do you see this "control character"? End of every record? Once at the end of the file? Something else entirely?
Posted: Tue Aug 05, 2008 12:47 am
by chulett
Ok, now how about the rest of it?
Posted: Tue Aug 05, 2008 3:51 am
by mahadev.v
Using a "tr" command in external source stage would help.
See if this post helps:
viewtopic.php?t=113640
Posted: Tue Aug 05, 2008 4:03 am
by ray.wurlod
Don't get hung up on control characters. Look at the message. Import (read) consumed only 27 bytes. This means either that your metadata only describes a 27-byte record, or that there is a line terminator (record delimiter) in your data.