The documentation says that @NULL is represented externally as CHAR(128). What I would like is some way of representing @NULL externally as a non-printable character, such as CHAR(128)! There is no way to get DataStage to actually do what the documentation says it does!
If you hold down Alt and type in 0129 then you get CHAR(129), if you hold Alt and type in 0127 then you get CHAR(127), but if you hold down Alt and type in 0128, then the job will abort!
Writing NULL to a file
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
Writing NULL to a file
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant
Phil,
take a step back - the CHAR(128) is the internal representation.
What exactly do you want to do?
take a step back - the CHAR(128) is the internal representation.
What exactly do you want to do?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
I want to represent NULL externally as something different to an empty string. CHAR(128) seems an eminently sensible choice, but it seems that that is just about the only character that is not usable as the external representation.ArndW wrote:Phil,
take a step back - the CHAR(128) is the internal representation.
What exactly do you want to do?
In addition, I would like to be able to set this globally (or at a project level), rather than relying on the developer to set it on every sequential file component.
On reading the documentation, I assumed that this would happen by default but sadly this is not the case.
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant