Work Around req in TC

[E1con]

I am writing aTC which has five columns -Input file -F9860
1.SYS TYPE ,
2.TYPE ,
3.SYS MAP,
4.KEYID ,
5.LANG ,DESC.

For the column 2.TYPE there r 5 hard coded values- PRM ,ACT,FLD,VAL,ORG. Under the PRM value lists all the bojects type - APPL(P)& UBE(R)alongwith their versions and forms. these are hard coded values not stored in JDE anywhere.

ACT lists all the Objects type APPL & UBE only, Under FLD value there r two hard coded values - Action & ROw to be hard coded in the respective key id & Desc column.
Under VAL - R=Run,I=Install,O,A,M,D,S,C which r to be shown at KEY ID & DESC Columns.

Similarly ORGwill have rows listing the Business units and the Desc.

Hope understand my explanation above, pl help me of what condition or how do I identify the 5Values forthe TYPE column and how do I make level break......As there is no levelbreak in TC toolset.?

Thanks,
RS

 

[peterbruce]

Rahul,

Maybe an example of the (text?) file would help in understanding your request.

Your system configuration details would be good too.

 

[Zoltan_Gyimesi]

Hi Rahul,

Excuse me, but your issue is not clear for me at all.
Further I wasn't able to idenzify the mentioend fields in F9860 Object Librarian Master table.

[ QUOTE ]
how do I make level break......As there is no levelbreak in TC toolset.?

[/ QUOTE ]

Everywhere, where you can set the Sequencing, define variables and you can add programing logic (as in TC), you can write your code, to determine the level breaks.

Regards,

Zoltán

 

[eydeak]

Hi,



I don't really understand the question you are trying to ask, but you
mention not having level breaks and I can respond to that.



If you define Sequencing in the table conversion properties, it will add
"Field" Data Changed events for each field defined in the sequence.



Ellen Deak

Senior Systems Developer

Cooper Standard Automotive

JDE EnterpriseOne (OneWorld XE Update 7 SP23_M1), AS400 DB2 V5R3M0,
Citrix Clients

 

[E1con]

Thanks for your input and its solved ..bye n thanks

Rahul