T24:COB Report to file

[Ahmet Baysa]

Dear All,

I need your help on the following issue. How i can prepare a report which would be running during the COB and the output of the report will be a ".xls" or".csv"  file kept on a location on the server ( Unix).I am planing to design an enquiry report ( or a routine report) and schedule it to be generated during COB. But how I can set it to post the output as a file. Any idea or experience...

I will do this in R07 Jbase 5.0

Thanks in advance,

Ahmet Baysa

[Jim Idle]

Ahmet Baysa wrote:
> Dear All,
>
> I need your help on the following issue. How i can prepare a report
> which would be running during the COB and the output of the report
> will be a ".xls" or".csv" file kept on a location on the server (
> Unix).I am planing to design an enquiry report ( or a routine report)
> and schedule it to be generated during COB. But how I can set it to
> post the output as a file. Any idea or experience...

Write a batch program for running in COB and use the jBC commands that
run jQL (not EXECUTE, it is something like JQLPREPARE - see the manuals)
and give you back a result set, which you can then iterate and write out
in any format you like.

Jim

[gabalian]

Hi

Use SEQWRITE to write you data in ".csv" ".txt" format

WRITESEQ
Write to a file opened for sequential access.

COMMAND SYNTAX
WRITESEQ Expression {APPEND} ON|TO FileVar THEN | ELSE statements
or
WRITESEQF Expression {APPEND} TO FileVar THEN | ELSE statements

SYNTAX ELEMENTS
Variable specifies the variable to contain next record from sequential file.
FileVar specifies the file descriptor of the file opened for sequential access.
Statements conditional jBASE BASIC statements

NOTES
Each WRITESEQ writes the data on a line of the sequentially opened file. Each data is suffixed with a new line character. After each WRITESEQ, the file pointer moves forward to the end of line. The WRITESEQF statement forces each data line to be flushed to the file when it is written. The APPEND option forces each WRITESEQ to advance to the end of the file before writing the next data line.

--
Imran Khan
T24 Technical Consultant
+92 334 3545114