Archives of the TeradataForum

Message Posted: Mon, 05 Jun 2006 @ 20:45:05 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

> How do I pass it to a normal file in ascci???

"od" is quite useful for visualization of data but it is less useful for actual data conversion because of its very special layout.

I am not sure I am giving the right advice because you provide little context but try another Unix command: strings. It displays ASCII strings in binary data. It might work for you because your record layout seems to be simple but if it doesn't you can look into more serious Unix char conversion utilities (this is a big topic which probably does not belong on a Teradata forum).

The syntax to try:

     cat  | strings -n1

-n1 instructs the utility to extract strings of length >=1, and this is important because the default minimum length (at least on Solaris) is 4, if I recall correctly.

This is just to give you an idea in which direction you might need to go. Please do read the manuals before you apply anything in your application. Unix utilities are powerful but they should be used with great care.

Regards,

Victor

	<Prev	Next>		<<First	<Prev	Next>	Last>>