Hi All,
I am getting an empty value in a field from Binary EBCDIC flat file. When I tried to load it into an Oracle table it says that its a null value and rejects the value. I tried writing a simple transform function to identify whether the incoming value is empty or null and tried replacing it with standard value. Here is my function
If (IsNull(Arg1) Or (Arg1="") Or (Arg1=@NULL) Or (Arg1=@NULL.STR) or (Trim(Arg1)=" ") Or (LEN(TRIM(Arg1)) = 0) ) then
Ans="NA "
End Else
Ans=Arg1
End
and its not working. Can anybody tell me where I am doing the mistake?
Thanks,
Anand.
Empty String rejection in Oracle
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 55
- Joined: Tue Feb 24, 2004 8:17 am
-
- Participant
- Posts: 36
- Joined: Wed Feb 16, 2005 5:20 pm
- Location: IL
Re: Empty String rejection in Oracle
Hi Anand
If IsNull(Arg1) then
Ans="NA "
End Else
Ans=Arg1
End
this will work check this one.
If IsNull(Arg1) then
Ans="NA "
End Else
Ans=Arg1
End
this will work check this one.
-
- Premium Member
- Posts: 55
- Joined: Tue Feb 24, 2004 8:17 am
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India