Hi All,
I am getting the following error:
DataStage Job 222 Phantom 26691
Record 4242 contains characters which are not defined in the file's NLS map.
Attempting to Cleanup after ABORT raised in stage GNSEventPromoteAndValidate.0.PromoteAndValidate
DataStage Phantom Aborting with @ABORT.CODE = 3
Can someone please tell the cause of this error and how can it be resolved.
Thanks,
DataStage Job 222 Phantom 26691 (Characters not in NLS map)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 19
- Joined: Fri Sep 10, 2004 12:17 am
- Location: India
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
HI Battliou ,
If you are getting special character in source column , then you can create routine and use in transformation , it will remove those character .
Ex:- Routine - RemoveUnWantedChar
It removes following character.
Chr(10) , Chr(13) = "Enter Key"
Chr(124) = "|" ---> Pipe
Chr(44) = "," ---> comma
Chr(34) = """ ---> double cots
Chr(37) = "%" ---> percentage
Code :-
* Store in a local variable.
InputString = Arg1
* after trimming the Input value stored in local variable.
Var1 = trimb(trimf(InputString))
* Now remove Enter key and pipe character.
Var2 = Trim(Trim(Trim(Var1,Char(124),"A"),Char(10),"A"),Char(13),"A")
* Now remove comma, double cots and percentage character.
Ans = Trim(Trim(Trim(Var2,Char(37),"A"),Char(34),"A"),Char(44),"A")
If you are getting special character in source column , then you can create routine and use in transformation , it will remove those character .
Ex:- Routine - RemoveUnWantedChar
It removes following character.
Chr(10) , Chr(13) = "Enter Key"
Chr(124) = "|" ---> Pipe
Chr(44) = "," ---> comma
Chr(34) = """ ---> double cots
Chr(37) = "%" ---> percentage
Code :-
* Store in a local variable.
InputString = Arg1
* after trimming the Input value stored in local variable.
Var1 = trimb(trimf(InputString))
* Now remove Enter key and pipe character.
Var2 = Trim(Trim(Trim(Var1,Char(124),"A"),Char(10),"A"),Char(13),"A")
* Now remove comma, double cots and percentage character.
Ans = Trim(Trim(Trim(Var2,Char(37),"A"),Char(34),"A"),Char(44),"A")
Arun Verma
-
- Participant
- Posts: 19
- Joined: Fri Sep 10, 2004 12:17 am
- Location: India
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The correct NLS map for hashed files is always NONE. This is because hashed files are internal to DataStage; the data have already been mapped from the external representation by the time they get into a hashed file.
Had you mentioned in your original post that a hashed file was involved we probably would have reached the solution more quickly.
Had you mentioned in your original post that a hashed file was involved we probably would have reached the solution more quickly.
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.