NLS Mapping Warning/error
Moderators: chulett, rschirm, roy
NLS Mapping Warning/error
CFF -> Tx -> Seq. File
When extracting cff file it warns with following msg. I tried different NLS mapping but same error. Input file is in CR/LF format. I viewed the data and some rows were having : character in it, i replaced : with blanks but still warning out.
Extract702..seqTRANKEY.outTRAN: nls_map_buffer_out() - NLS mapping error, row 154 (approx), row = "& , ?,000I00000,000,, ,000-- ::"
When extracting cff file it warns with following msg. I tried different NLS mapping but same error. Input file is in CR/LF format. I viewed the data and some rows were having : character in it, i replaced : with blanks but still warning out.
Extract702..seqTRANKEY.outTRAN: nls_map_buffer_out() - NLS mapping error, row 154 (approx), row = "& , ?,000I00000,000,, ,000-- ::"
Actual Row:
995100003 213576 001950449803503 2008050700000000 003 SHORT TERM PREM 100 ANNUAL PREM 100
Hex format:
39 39 35 31 30 30 30 30 33 20 20 20 32 31 33 35 37 36 20 20 30 30 31 39 35 30 34 34 39 38 30 33 35 30 33 20 20 20 20 20 20 20 20 32 30 30 38 30 35 30 37 30 30 30 30 30 30 30 30 20 20 20 20 20 20 30 30 33 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 53 48 4F 52 54 20 54 45 52 4D 20 50 52 45 4D 20 20 20 31 30 30 20 20 20 20 20 41 4E 4E 55 41 4C 20 50 52 45 4D 20 20 20 20 20 31 30 30
995100003 213576 001950449803503 2008050700000000 003 SHORT TERM PREM 100 ANNUAL PREM 100
Hex format:
39 39 35 31 30 30 30 30 33 20 20 20 32 31 33 35 37 36 20 20 30 30 31 39 35 30 34 34 39 38 30 33 35 30 33 20 20 20 20 20 20 20 20 32 30 30 38 30 35 30 37 30 30 30 30 30 30 30 30 20 20 20 20 20 20 30 30 33 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 53 48 4F 52 54 20 54 45 52 4D 20 50 52 45 4D 20 20 20 31 30 30 20 20 20 20 20 41 4E 4E 55 41 4C 20 50 52 45 4D 20 20 20 20 20 31 30 30
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please enclose the Actual Row in Code tags so we can see the extra spaces.
However, the hex dump does not show any byte over 7F, which means that code page 1252 should have no problem at all with these particular data.
However, the hex dump does not show any byte over 7F, which means that code page 1252 should have no problem at all with these particular data.
Code: Select all
9 39
9 39
5 35
1 31
0 30
0 30
0 30
0 30
3 33
20
2 32
:
S 53
H 48
O 4F
R 52
T 54
20
T 54
E 45
R 52
M 4D
32
:
1 31
0 30
0 30
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.
995100003 213576 001950449803503 2008050700000000 003 SHORT TERM PREM 100 ANNUAL PREM 100
Coding:
--- ----
39 9
39 9
35 5
31 1
30 0
30 0
30 0
30 0
33 3
20
20
20
32 2
31 1
33 3
35 5
37 7
36 6
20
20
30 0
30 0
31 1
39 9
35 5
30 0
34 4
34 4
39 9
38 8
30 0
33 3
35 5
30 0
33 3
20
20
20
20
20
20
20
20
32 2
30 0
30 0
38 8
30 0
35 5
30 0
37 7
30 0
30 0
30 0
30 0
30 0
30 0
30 0
30 0
20
20
20
20
20
20
30 0
30 0
33 3
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
53 S
48 H
4F O
52 R
54 T
20
54 T
45 E
52 R
4D M
20
50 P
52 R
45 E
4D M
20
20
20
31 1
30 0
30 0
20
20
20
20
20
41 A
4E N
4E N
55 U
41 A
4C L
20
50 P
52 R
45 E
4D M
20
20
20
20
20
31 1
30 0
30 0
Coding:
--- ----
39 9
39 9
35 5
31 1
30 0
30 0
30 0
30 0
33 3
20
20
20
32 2
31 1
33 3
35 5
37 7
36 6
20
20
30 0
30 0
31 1
39 9
35 5
30 0
34 4
34 4
39 9
38 8
30 0
33 3
35 5
30 0
33 3
20
20
20
20
20
20
20
20
32 2
30 0
30 0
38 8
30 0
35 5
30 0
37 7
30 0
30 0
30 0
30 0
30 0
30 0
30 0
30 0
20
20
20
20
20
20
30 0
30 0
33 3
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
53 S
48 H
4F O
52 R
54 T
20
54 T
45 E
52 R
4D M
20
50 P
52 R
45 E
4D M
20
20
20
31 1
30 0
30 0
20
20
20
20
20
41 A
4E N
4E N
55 U
41 A
4C L
20
50 P
52 R
45 E
4D M
20
20
20
20
20
31 1
30 0
30 0
How is any of this helping? As Ray notes, there's nothing in the record being shown here with a byte value over 7F so this is all perfectly normal boring text. And the semi-colons you were worried about in the first post are not an issue either.
What happened to dumping the record being complained about?
NLS mapping error, row 154 (approx), row = "& , ? , 000I00000,000,, ,000-- ::"
![Confused :?](./images/smilies/icon_confused.gif)
What happened to dumping the record being complained about?
NLS mapping error, row 154 (approx), row = "& , ? , 000I00000,000,, ,000-- ::"
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers