@INROWNUM ?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
@INROWNUM ?
What Exactly in @INROWNUM??
My Understanding was @INROWNUM is the input row Counter and is independent of the Table Count. But in One of my job the value that the @INROWNUM has is the Count in the table and I am not at all able to understand this. Is my understanding of the variable wrong???
My Understanding was @INROWNUM is the input row Counter and is independent of the Table Count. But in One of my job the value that the @INROWNUM has is the Count in the table and I am not at all able to understand this. Is my understanding of the variable wrong???
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
I am using it in My logic... X should get a value when @INROWNUM = 1 (For the First row) and some other row if @INROWNUM > 1 and I am using this logic from years but Today for one environment the variable is not working correct. Its not getting assigned 1 at all.
I really appreciate your help in this matter...
I really appreciate your help in this matter...
You will have to be more clear on what exactly you are tying to do? From what I understand you are using it in a derivation where in you are trying to collect some values based upon your @INROWNUM variable value. Is that correct? If so, are you also defining any constraint in the Transformer?If so, looks to me that the first row from the input doesn't qualify for the constraint and hence not picking the first row. If now, please answer the questions asked in the earlier post.
HTH
HTH
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
I am sorry if I did not give you the full details of the job and confused you.
I am trying to assign a column a value depending on the whther the row is the first one to flow in the job or not. If it is the first row to get processed in the job then the column should get calculated differently and when it is second,third.... then it should get a different value. The probelm that I am having is the Variable @INROWNUM is not getting set to "1" (I populated a sequential file with all the values thatI am getting for this variable and the first one is "2" instead of "1") and hence the logic is not working. No, I am not using it in any kind of constraint.
So I just wanted to know that if there are any reasons of this variable not getting a value 1 for the first row.
Let me know if you have any more doubts.
I am trying to assign a column a value depending on the whther the row is the first one to flow in the job or not. If it is the first row to get processed in the job then the column should get calculated differently and when it is second,third.... then it should get a different value. The probelm that I am having is the Variable @INROWNUM is not getting set to "1" (I populated a sequential file with all the values thatI am getting for this variable and the first one is "2" instead of "1") and hence the logic is not working. No, I am not using it in any kind of constraint.
So I just wanted to know that if there are any reasons of this variable not getting a value 1 for the first row.
Let me know if you have any more doubts.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I have severe doubts about your claim. @INROWNUM is always assigned 1 for the first row input.
Of course, due to output constraints this row may not be output, but what I say is, and remains, true.
Perhaps you want @OUTROWNUM ?
Of course, due to output constraints this row may not be output, but what I say is, and remains, true.
Perhaps you want @OUTROWNUM ?
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.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
I agree Ray. But here is what I m observing in my job - If I set the job to run for only 947 rows then the @INROWNUM value starts from 1 and goes upto 947 but if I run it for more than 947 rows then it starts from 2 and the value of 948 repeats twice and it goes upto the final rowcount.
I know its hard to blv but can not help its happening --
Let me try to paste the data (The Last column is the inrownum)
6006.00000,945.00000,946.00000
6006.00000,946.00000,947.00000
6006.00000,947.00000,948.00000
6006.00000,948.00000,948.00000
6006.00000,949.00000,949.00000
6006.00000,950.00000,950.00000
I know its hard to blv but can not help its happening --
Let me try to paste the data (The Last column is the inrownum)
6006.00000,945.00000,946.00000
6006.00000,946.00000,947.00000
6006.00000,947.00000,948.00000
6006.00000,948.00000,948.00000
6006.00000,949.00000,949.00000
6006.00000,950.00000,950.00000
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
How do you set the job to run only 947 rows? If it is via the normal job execution call then I've tried the same thing and can't reproduce your problem with AIX and 7.5
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Yes the usual way , while running it gave a option to run for specific number of rows.
And its not happening with any other job but only with this one. I am not modifying the param anywhere , not filtering out anything but still. Strange fact is it starts from 2 and repeats at 948 no matter what you do and how you run
And its not happening with any other job but only with this one. I am not modifying the param anywhere , not filtering out anything but still. Strange fact is it starts from 2 and repeats at 948 no matter what you do and how you run
By the way, what is second columna and what is third column?
Have you given any constrains, used in any stage varialbe?
Try to map this value in a integer.
What is the job design and what are you trying to acheive?
Hope you have tried running in a sequential mode too.
Have you given any constrains, used in any stage varialbe?
Try to map this value in a integer.
What is the job design and what are you trying to acheive?
Hope you have tried running in a sequential mode too.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
The Third Column and the second column are just counters which depends on the INROWNUM value. But as the INROWNUM is not getting the value 1 they are starting with wrong values.
I am just trying to assign the counters values depending on if it is the first row in the stage or not.
No Constraints on the variable in the job and also I am not using it anywhere other than this stage.
And one more thing that i tested is that the value is getting wrong value only in this "stage". Right now I changed my logic to go after the inrownum in the previous stage but I am really curious to know why this happens and whts the solution to this?
I am just trying to assign the counters values depending on if it is the first row in the stage or not.
No Constraints on the variable in the job and also I am not using it anywhere other than this stage.
And one more thing that i tested is that the value is getting wrong value only in this "stage". Right now I changed my logic to go after the inrownum in the previous stage but I am really curious to know why this happens and whts the solution to this?