Hi all,
I'll like to know if its possible to order the values of one parameter set.
For example, if you look at this image, we have several values for the parameter set called HEADER_ETL_PARAMS
But the values are unsorted, even if we have entered it in order. As soon as I save que parameter set, I open it again and it comes up like in the image.
When we try to run a job and have to set a value for the parameter set, it comes unsorted too, so its a bit unpractical to look to the entire list to get the one that you want.
Any idea of how to have it sorted?
Thanks in advance!
How to order Parameter Sets Values inside one Parameter Set?
Moderators: chulett, rschirm, roy
Hi kduke,
I've tried with both mouse button, and in combination with SHIFT, ALT and CONTROL keys, and no luck.
Datastage seems to apply some kind of 'Hash' because if I insert a new value called 'TEST' it goes directly to the position 31.
Then I change 'TEST' to something else, changes it position... and put back 'TEST' and goes to pos 31 again. Kinda strange...
I've tried with both mouse button, and in combination with SHIFT, ALT and CONTROL keys, and no luck.
Datastage seems to apply some kind of 'Hash' because if I insert a new value called 'TEST' it goes directly to the position 31.
Then I change 'TEST' to something else, changes it position... and put back 'TEST' and goes to pos 31 again. Kinda strange...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I have seen the same thing with stage variables. You re-order them and save the job. When you re-open the job, they're back in their original order.
(Version 8.5.0.1)
(Version 8.5.0.1)
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.
OK, I've found why Datastage orders the parameters sets values in this way.
As you may know, each value of the parameter set is stored in a different physical file.
For example, in my case, for each value I have a different file inside the directory /ETL/Projects/R1B1/ParameterSets/HEADER_ETL_PARAMS.
If I go there, list all the files and order them using their inode (i'm working on unix) I get exactly the same order that I have inside the parameter set in datastage.
So instead of getting the list of files by name, it get its by inode... wonderful.
As you may know, each value of the parameter set is stored in a different physical file.
For example, in my case, for each value I have a different file inside the directory /ETL/Projects/R1B1/ParameterSets/HEADER_ETL_PARAMS.
If I go there, list all the files and order them using their inode (i'm working on unix) I get exactly the same order that I have inside the parameter set in datastage.
So instead of getting the list of files by name, it get its by inode... wonderful.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: