Hi,
Can anyone explain what is the use of NullString Properties in FTP Plug-in Stage .
By,
Rajendran.
FTP Plug-in
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It defines a string with which NULL is represented in the data stream to be transferred via FTP. For example, the remote file might represent NULL as the string "<NULL>".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can extract one from a database table, where the column contains a NULL.
The concept of null is irrelevant to text files. It is mainly text files that you pass using FTP. Therefore, you can decide any convention you like for passing null values.
In general there are two strategies.
There is also a system variable @NULL.STR, which is a string representation of the internal storage of NULL in DataStage (and can participate in expressions, functions, and so on, without returning NULL).
The concept of null is irrelevant to text files. It is mainly text files that you pass using FTP. Therefore, you can decide any convention you like for passing null values.
In general there are two strategies.
- Choose some string that will never appear in data, such as "<NULL>", and use that to represent null.
If your data are fixed width, allow one space preceding each column, and use some character (for example "%") placed there to indicate that the data in the column following it should be ignored, and null used instead.
There is also a system variable @NULL.STR, which is a string representation of the internal storage of NULL in DataStage (and can participate in expressions, functions, and so on, without returning NULL).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.