I am running a job that is passing a setnull() conditional statement to a row and sequential file. It is properly passing a 'NULL', but the Job logs are throwing a warning of:
Warning - Transformer 80. Null String Arguement.
Since it is a big file, the job ultimately stops with an ORCHESTRATE error step execution terminating due to SIGINT.
The sequential file row is a Nullable field (as is the input stage in Transformer).
I have set the 'edit row' of the null value to ''.
Can someone shed some light?
SetNull() function - triggering ORCHESTRATE error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 46
- Joined: Wed Jun 06, 2007 10:32 am
which one is giving the warning/abort..both or first one?dstager wrote:yes, i am using the setnull() in a conditional statement...
ie.
If num(incolumn) = 0 then setnull() else incolumn
or
if isnull(incolumn) then setnull() else incolumn
Accept that some days you're the pigeon and some days you're the statue.
Are you doing your in the Column derivation or in the stage variable?
What is your input stage for the transformer..i.e the design looks like(file-->transformer-->file)??
Try the following and see if that works...
Make the nullable as "NO" on the output of transformer which will remove the Sequential file null value to ''.
In the transformer handle the nulls
NullToValue(%inputcol%,Space(%length%)) where %length% will be your o/p column length..or if you dont want to write anything into file then use NulltoEmpty()
Code: Select all
If num(incolumn) = 0 then setnull() else incolumn
What is your input stage for the transformer..i.e the design looks like(file-->transformer-->file)??
Try the following and see if that works...
Make the nullable as "NO" on the output of transformer which will remove the Sequential file null value to ''.
In the transformer handle the nulls
NullToValue(%inputcol%,Space(%length%)) where %length% will be your o/p column length..or if you dont want to write anything into file then use NulltoEmpty()
Accept that some days you're the pigeon and some days you're the statue.