Dear All,
This is my Design.
Job1--> ExecuteCommand--> StartLoop
1. In Job1 I am taking count from a Database table and the same value I am populating into a text file with numeric data type.
2. In Execute Command I am performing TYPE path of the text file
3. I am assigning command output as Loop Final value with the help of
Trim(Convert(@FM,"",#Execute_Command_61.$CommandOutput#)) this code.
This sequence design is aborting and it is throwing below message.
"POC_Sequencer..JobControl (@StartLoop_Activity_23): Controller problem: Loop final value not numeric (Trim(Convert(@FM,"",10) - cannot execute"
I already searched for the same in the form. I got 5 answers but I couldn't resolve this issue with the help of those answers. Can anyone help me on this. Thank you.
Loop final value not numeric.
Moderators: chulett, rschirm, roy
-
- 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:
Then please mark the thread as Resolved using the green button at the top of the page.
(An approach using user status was going to be my next suggestion, but I had to check your syntax because the function you posted had mismatched parentheses.)
(An approach using user status was going to be my next suggestion, but I had to check your syntax because the function you posted had mismatched parentheses.)
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.