2008 May 15 3:53 PM
hi all,
could any one help me to solve the problem:
we are uploading a file from application server which is having some status information. last field in each record will be status number, sometimes it can be blank. if it is initial then only we need to consider it for processing. when it is initial the end of character which is # is occupying that field, which it is not identifying as empty field.
how can we avoid it......
thx in advance.
2008 May 15 3:58 PM
Are you doing cross platform transfers? I mean is the file comming from a UNIX sytem to a Windows system or vice versa. read dataset normally doesnt read the end of line character unless the file was transfered incorrectly. IF you are doing cross platfor transfers you have to select the appropriate transfer mode so that the unix end of line character is replaced by windows end of line character or vice versa.
hi all,
could any one help me to solve the problem:
we are uploading a file from application server which is having some status information. last field in each record will be status number, sometimes it can be blank. if it is initial then only we need to consider it for processing. when it is initial the end of character which is # is occupying that field, which it is not identifying as empty field.
how can we avoid it......
thx in advance.
2008 May 15 3:58 PM
Are you doing cross platform transfers? I mean is the file comming from a UNIX sytem to a Windows system or vice versa. read dataset normally doesnt read the end of line character unless the file was transfered incorrectly. IF you are doing cross platfor transfers you have to select the appropriate transfer mode so that the unix end of line character is replaced by windows end of line character or vice versa.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |