Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 06 Dec 2001 @ 15:16:00 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: ����'s
From:   Michael Bach

Cheers Geoff

The reference table is that small (at least the number of rows added at a time is small), the colleague types them in manually via Queryman using 'insert into tableA values (v1,v2,...vx)' as and when new values are required.

The colleague in question comes from Marketing who do not use MVS. I suppose the other option would be to import a text file to the table destination via Queryman, still not the best method, rather the last resort.

By retrieve I meant that I was just running a simple select via ITEQ to see how the values were brought back in TSO against those from the answer set in Queryman - TSO brings back ", Queryman brings back �.

However the binary values you state are correct - it should be x'5B' (�) but reverts to x'7F'(") if you look at it in the retrieve. The output after the export changes to x'65' for the =C1 value? The binary for $ is x'4A', IBM reverts the $ in ASCII to x'5B' to get the desired result when retrieved in ITEQ and in the export. Clear as Mud !


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