Section Database Output in RDA

Zoltan_Gyimesi

Zoltan_Gyimesi

Legendary Poster
Hi JDEList,

Does anybody know about any documentation, whitepaper, etc. about the Section Database Output feature?
What I had found in the Enterprise Report Writer manual was very poor and just the substance missed for me, further I haven't found anything more on the Knowledge Garden.

Further, can somebody point to some original UBE which use this feature.

I am mainly interested in output to OneWorld table and this time in XE.

I would like to use this feature in the near future.

Any input will be appreciated.

Regards,

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Here are the steps on how to output a table (or business view) fields to a TEXT file by using Section Database Output:

1. Create a group section;
2. Attach a business view to the section;
3. Select "Database Output..." from Section menu;
4. A pop-up screen shows up;
5. Double click "Operations" column and select "Insert Only" from the drop down list;
6. Double click "Type" column and select "Comma Delimited File" or "Fixed length record file";
7. Single click "Name" column and enter the output file path, e.g. "C:\MyFile.txt";
8. Click "Next";
9. Another pop-up screen;
10. On grid, double click "Source Section" and "Source Object" to map every field you would like to output;
11. Click "Finish";
12. Save and run the UBE. The output file "MyFile.txt" is located at the directory you specified.

***Important****
The output file locates at the machine the UBE is run. If you run it locally, the file locates at your computer. If it's run on a server, go to server's directory to find it.

You can also do other operations such as Delete and Update.

Hopefully it helps.

MG

G
[email protected]
 
Hi Jun,

Thanks for your reply.
You have wrote everything what I have already found about this issue, and a bit more about the file location.
Specially I am interested in output to OneWorld table instead to text file.

Further, I would like a bit more about this feature, like:
* Typical usage
* A sample
* How to detect and handle errors on Output?
* What about transaction processing?
* Does "Source Section" mean that I can select BCs from other sections BSVWs? Can this section be a Conditional one?
* Can the section be a Conditional one?
* Can I set the selection/sequencing for this section?
* Can I call this section more times from other section?
* What does it mean "Dictionary override"? How does it effect/change the output?
* etc, etc, etc...

Regards,

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
I use the database output option for my check writing. I throw the text
file into a third party software that prints the checks for me. Also,
if you have a network drive mapped, you can direct the text file to that
network drive, regardless of whether you run it locally or on the
server.

As for your other specific questions, I don't have much to offer.

Stacy Barry
Xe SP16.1 Upd 2 W2K SQL2K
 
Hi,

I would like to add one more question to what Zoltan has asked in a list
smile.gif

What about the values obtained using ER variables?
(Ex: values obtained by using Table IO from other tables other than BSVW attached in UBE)
 
Very old thread, however I found a standard UBE that uses Database output : R30890. Hope this is helpful to anyone.
 
Back
Top