OPENSEQ Status Statement
Posted: Thu Aug 25, 2005 11:53 am
I have the following code in a before/after subroutine:
OPENSEQ reportFile TO H.REPORT THEN
status FileInfo from H.REPORT ELSE STOP
fileRowCount = FileInfo<6>; * get the row count
CALL DSLogInfo("Row Count: " : fileRowCount, "EmailReportRoutine")
:
:
I need to find the row count. However, FileInfo<6> is not row count, it's character count. I only want to do something with the file if there is more than 1 row (the column headers, which are needed in the file). Does anyone know where I can find information about the various fields returned using the Status statement? And which field is row count?
And as long as I'm asking....anyone know how to email an attachment in 7.1. (Is it possible? Any wrapper I can add?) The above subroutine, opens the file, if it has more than 1 row, it reads the file and emails the data as inline text as part of the body of the email. This works okay for most cases, but some with lots of columns look horrible.
OPENSEQ reportFile TO H.REPORT THEN
status FileInfo from H.REPORT ELSE STOP
fileRowCount = FileInfo<6>; * get the row count
CALL DSLogInfo("Row Count: " : fileRowCount, "EmailReportRoutine")
:
:
I need to find the row count. However, FileInfo<6> is not row count, it's character count. I only want to do something with the file if there is more than 1 row (the column headers, which are needed in the file). Does anyone know where I can find information about the various fields returned using the Status statement? And which field is row count?
And as long as I'm asking....anyone know how to email an attachment in 7.1. (Is it possible? Any wrapper I can add?) The above subroutine, opens the file, if it has more than 1 row, it reads the file and emails the data as inline text as part of the body of the email. This works okay for most cases, but some with lots of columns look horrible.