Yes. Bring up the layout you need. Right click and choose Export.
Then you can choose Excel. The program will ask you to highlight what
you want to export. After you have selected what you need then click
Continue. Have fun.
Use the utility SABridge.exe found in \b7\system\bin32
2. OneWorld SignON
3. Find your table
4. File > Export
It will prompt you to enter two file names to export to.
5. enter destination and excel file name for header definition
6. enter destination and excel file name for Table definition
Tel: 514.205.5000 x3619
<email@example.com> To: firstname.lastname@example.org
Sent by: cc:
owner-jdeowdevml@j Subject: Table Layout to Excel
Please respond to
Is there a way to get table layouts(alias,description,length,etc..) into
Just a note regarding the field sizes returned by SABridge as they can be misleading (certainly under B733x, and I imagine XE).
SABridge works by reading the tables .h, the C header file. This means that:
Strings - Will have a size equal the the DD value +1 (the +1 is from a null character \0 used to indicate the end of the string.
Numerics - are all declared as MATH_NUMERIC with a size of 49
Dates - have a correct size of 6
Characters - have a correct size of 1
Venkat, what is your system configuration?
If it is XE then you can use P80010 as Christian has suggested already but you have to make some OCM mappings to get it work properly. Please, checkout the ott-00-0058 documentation from the Knowledge Garden for the required prerequisites.
Further you can investigate this application with FDA how does it retrieve the informations, so you will be able with these knowledge to create your own application(s) which best suits to your needs.
P.S.: Place your system configuration informations in your signature.
Thanks to your suggestions, I tried SABridge and it worked great! However, I would also like to get the long glossary description to download, either with the same file or separately and I can match it from there. Is this possible?
I must be doing something wrong. When I use P80010, the glossary is a row exit. I can go to and from the glossary, but when I do the export, the glossary data does not come with it. Am I missing a step?
PS - I have the ott-00-0058, but it doesn't help with the export.