@INROWNUM ?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Here are the columns --
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
First Column - Max value of a counter column in the DB
Second Column - If @INROWNUM = 1 Then (StageVariable1+1) Else (Second Column+ 1) (Gets Populated by a stage Variable which gets a value depending on if it is the first row or not - if it is first row it should get the Max value of a counter column in the DB - Right now this is not working as the @INROWNUM never gets a value as 1)
Third Column - @INROWNUM (starts from 2)
Hope this helps.
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
First Column - Max value of a counter column in the DB
Second Column - If @INROWNUM = 1 Then (StageVariable1+1) Else (Second Column+ 1) (Gets Populated by a stage Variable which gets a value depending on if it is the first row or not - if it is first row it should get the Max value of a counter column in the DB - Right now this is not working as the @INROWNUM never gets a value as 1)
Third Column - @INROWNUM (starts from 2)
Hope this helps.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Can you post precisely what the input file looks like, and the exact derivations of the stage variables and output columns used?
I have been unable to reproduce this on version 7.5.1 on Red Hat Linux.
I have been unable to reproduce this on version 7.5.1 on Red Hat Linux.
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.
Was a cause ever found?
We had the same thing happen in a job that has been running for a couple of years without any issue. We are running on AIX with DataStage server version 7.5.1 In the last run, it had an issue in which Inrownum was the same for 2 consecutive records.
Seq --> Transformer --> Oracle
We exported all of the jobs and the file to our test server. First, we took a piece of the sequential file (where the error occured) and ran this on the test environment and there was no error.
When run with the entire file (large file), we encountered the same error in the same place on the test server.
Stephen House
We had the same thing happen in a job that has been running for a couple of years without any issue. We are running on AIX with DataStage server version 7.5.1 In the last run, it had an issue in which Inrownum was the same for 2 consecutive records.
Seq --> Transformer --> Oracle
We exported all of the jobs and the file to our test server. First, we took a piece of the sequential file (where the error occured) and ran this on the test environment and there was no error.
When run with the entire file (large file), we encountered the same error in the same place on the test server.
Stephen House
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Participant
- Posts: 20
- Joined: Mon Dec 05, 2005 8:07 pm
- Contact:
-
- Participant
- Posts: 20
- Joined: Mon Dec 05, 2005 8:07 pm
- Contact:
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
If this question is to me then really sorry I can not and plus I have exported the job and imported in a different server and it works fine in there. But on this server in this project it does not. I think some setting has gone wrong and I am not able to make it correct. Also I have tried exporting the job in DSX and then deleting the job and then reimporting it in the Project but still square one.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am