Level Number in the output columns

abc123 · Post by **abc123** » Fri Apr 18, 2008 9:44 am

I am trying understand a job where, in the transformer stage, on one of the output column tabs, I see the column called Level Number. How do I display this column on the 2nd tab?

I tried to put in a value in the Level number box in the Edit Column Metadata window. That doesn't do it.

sud · Post by **sud** » Fri Apr 18, 2008 11:21 am

If you are already able to see the column defined, it should be out there, probably you have to scroll or something.

kumar_s · Post by **kumar_s** » Fri Apr 18, 2008 2:56 pm

Right click on the Column grid, properties to Enable it on other Tab.

abc123 · Post by **abc123** » Wed Apr 23, 2008 11:39 am

kumar_s, just right clicking will not show the column. I had already tried that. What's interesting is, on one tab, it shows Level Number and on the other it doesn't. On the tab on which it shows Level Number, I went to Edit Column Meta Data window and I cleared the Level Number box on bottom/left for all columns. This makes the Level Number column disappear. However, if I insert the value again in the Level Number box, the column does not reappear. This is really baffling!

kumar_s · Post by **kumar_s** » Wed Apr 23, 2008 2:26 pm

You mean to say, the option is not available in Edit Column Meta Data window at all?
What is the output stages for both the link? Are you handling mainframe data?

abc123 · Post by **abc123** » Thu Apr 24, 2008 8:30 am

I am working with mainframe data but this is from within a transformer stage. There is no Level Number input column. There is a box in Edit Column Meta Data (on the output column tabs) called Level Number
but putting in a value in there does not save it nor is a column added.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 24, 2008 3:02 pm

You have to click Apply to get anything saved.

I would recommend editing the table definition in the Repository to add the Occurs value, and then to load the table definition into your job from there.

You might also try editing the column definition on the other end (the passive stage end) of its link.

abc123 · Post by **abc123** » Fri Apr 25, 2008 7:46 am

How do you add the Occurs value in the repository?

kumar_s · Post by **kumar_s** » Fri Apr 25, 2008 11:55 am

Simply save the other tab metadata which has Occurs in it and reload that into the tab where you like to have.

abc123 · Post by **abc123** » Fri Apr 25, 2008 12:05 pm

Ok. I got the answer (I think!). The table definition was imported from mainframe COBOL File Definition. That's why I could not add it.

kumar_s · Post by **kumar_s** » Fri Apr 25, 2008 12:08 pm

Really? But metadata from Cobol file Definition would have Level Number in it.

abc123 · Post by **abc123** » Sat Apr 26, 2008 7:28 am

Yes, the metadata did. That's why I could not add it on the second tab.

DSXchange

Level Number in the output columns

Level Number in the output columns

Re: Level Number in the output columns