Hi,
I am facing a strange issue.
After restarting the Datastage services in the server, I found that the order in which I have arranged the column in DS Transformer seems to have changed. Note sure how many days the updates are getting backdated.
One day before the services restart, I had changed the column order for 3 columns by moving them as the last 3 columns in transformer. These columns were in the middle earlier. Now after restart, those columns were again gone back to the middle.
Similarly, I had created a stage variable as the last one. Then I changed its order to first one. After restart this stage variable has taken its old position.
I am sure, I had saved these jobs, compiled and executed before the services restart.
These are services which got restarted
DataStage Multi-Client Manager Service (ASCLCSSrv)
DataStage Telnet Service (dstelnet)
IBM WebSphere Application Server V7.0 - <Machine name>
Not sure If I am missing something here. Please guide
- Sree
Column order changes after restarting DS Services
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In one of the scenarios, I am writing the transformer output to a Sequential file which I am using to load in the another Database, in that case order does matter.
In the case of stage variables, this one is a calculated one which derives its values from some of the following stage variables. So it has to be placed after those (At the end)
In the case of stage variables, this one is a calculated one which derives its values from some of the following stage variables. So it has to be placed after those (At the end)
Re: Coloumn order changes after restarting DS Services
Me... not sure at all. There's no way for them to revert back to a state before your change unless you didn't actually save them.sreesuku2 wrote:I am sure, I had saved these jobs, compiled and executed before the services restart.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Coloumn order changes after restarting DS Services
...unless you are on version 8.5...chulett wrote:There's no way for them to revert back to a state before your change unless you didn't actually save them.
JR39833: COLUMN ORDER IN TRANSFORMER NOT MAINTAINED AFTER SAVING THE JOB
See Also: Superceded by patch JR39983.
Choose a job you love, and you will never have to work a day in your life. - Confucius
