Datastage PX Warning: Import consumed only 27bytes of the re

hemanthakumar · Post by **hemanthakumar** » Mon Aug 04, 2008 9:41 am

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.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 04, 2008 3:16 pm

What "control characters" are you getting in your data?

chulett · Post by **chulett** » Mon Aug 04, 2008 10:37 pm

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?

chulett · Post by **chulett** » Tue Aug 05, 2008 12:47 am

Ok, now how about the rest of it?

mahadev.v · Post by **mahadev.v** » Tue Aug 05, 2008 3:51 am

Using a "tr" command in external source stage would help.
See if this post helps:

viewtopic.php?t=113640

ray.wurlod · Post by **ray.wurlod** » Tue Aug 05, 2008 4:03 am

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.