Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 05 Jun 2006 @ 18:55:48 GMT


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


Subj:   Re: Newlines in BTEQ EXPORT under Unix
 
From:   Castelli Emanuel Alejandro

OK!!!!! THANKS A LOT!!!!!

Now, I use the od -c modificator to obtain that:

     0000000   \0   k  \0   i   u   p   d   a   t   e       t   m   p   _   m
     0000020    o   d   e   l   o   _   c   o   n   t   r   o   l   .   t   m
     0000040    p   _   p   a   s   o  \n  \t   s   e   t       f   l   _   e
     0000060    j   e   c   u   t   a   d   o       =       '   S   '  \n  \t
     0000100    w   h   e   r   e       c   d   _   s   c   r   i   p   t
     0000120    =       '   S   C   P   0   0   1   '  \n  \t   a   n   d
     0000140    c   d   _   p   a   s   o       =       1   0   ;  \n  \0 024
     0000160   \0 022   .   L   a   b   e   l       P   a   s   o   2   0
     0000200                :  \n  \0   Q  \0   O   .   L   a   b   e   l
     0000220    E   R   R   E   X   I   T  \n   .   r   e   m   a   r   k
     0000240    '   E   l       u   l   t   i   m   o       q   u   e   r   y
     0000260        d   e   v   o   l   v   i   o       u   n       E   R   R
     0000300    C   O   D   E       >       0   .   '  \n   .   l   o   g   o
     0000320    f   f  \n   .   q   u   i   t  \n  \0   &  \0   $   .   i   f
     0000340        E   R   R   O   R   C   O   D   E       >       0       t
     0000360    h   e   n       .   G   O   T   O       E   R   R   E   X   I
     0000400    T  \n  \0   k  \0   i   u   p   d   a   t   e       t   m   p
     0000420    _   m   o   d   e   l   o   _   c   o   n   t   r   o   l   .
     0000440    t   m   p   _   p   a   s   o  \n  \t   s   e   t       f   l
     0000460    _   e   j   e   c   u   t   a   d   o       =       '   S   '
     0000500   \n  \t   w   h   e   r   e       c   d   _   s   c   r   i   p
     0000520    t       =       '   S   C   P   0   0   1   '  \n  \t   a   n
     0000540    d       c   d   _   p   a   s   o       =       3   0   ;  \n
     0000560   \0 024  \0 022

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

Thanks!!!!! You are very helpful, thanks again!

Bye

Castelli, Emanuel Alejandro
Desarrollo DataWarehouse - IBM Argentina



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