Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Newlines in BTEQ EXPORT under Unix
From:   Victor Sokovin

> 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.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020