I have created this little fex to search for and report on values from an excel spreadsheet...
-*

  
APP HOLDMETA HELDFILES
FILEDEF CHGCDXMAS DISK \\misspiggy\x$\ibi\apps\HeldFiles\CHGCDX.mas
-RUN
-*
-WRITE CHGCDXMAS FILENAME=CHGCDX,SUFFIX=COM,$
-WRITE CHGCDXMAS SEGNAME=CHGCDX, SEGTYPE=S0,$
-WRITE CHGCDXMAS FIELD=OCHGCD, ALIAS=E01, ACTUAL=A6, USAGE=A6,$
-WRITE CHGCDXMAS FIELD=FILLER, ALIAS=E02, ACTUAL=A1, USAGE=A1,$
-WRITE CHGCDXMAS FIELD=NCHGCD, ALIAS=E03, ACTUAL=A6, USAGE=A6,$
-*
FILEDEF CHGCDX DISK \\misspiggy\x$\ibi\apps\HeldFiles\NEW_CHGCD_4202009.csv
-RUN
-*
TABLE FILE CHGCDX
PRINT
OCHGCD
NCHGCD
IF RECORDLIMIT EQ 15
END
-RUN
-EXIT 

-*

When I run it I get this error...

Reporting Server messages exceeded IBIF_max_messages, report retrieval aborted.

Please, contact your WebFOCUS administrator.
-*
Can anyone advise as to what I am doing wrong?

Thanks!

This message has been edited. Last edited by: Kerry,

Change RECORDLIMIT to READLIMT, make it smaller, and do a view source on the output so you can see the errors.

In summary, I added this:

quote:

-SET &ECHO=ALL;
-*
TABLE FILE CHGCDX
PRINT
OCHGCD
NCHGCD
IF READLIMIT EQ 15
END
-RUN
-EXIT

I get the same error message.

Make it 1. You are generating too many errors to be able to see what the error is.

Have you considered using the import facility to upload the file to your WF environment. It automatically creates the master. It is available under the Master virtual directory.

You can change the default setting fot IBIF_max_messages in the Client Console. Go to the Configurations-->General tab and change the value to whatever you want. A setting of 0 is unlimited.

I tested your code and it ran okay.
All that was missing was "SET PCOMMA = ON".
When working with COM formatted files you have to use "SET PCOMMA = ON".
Also, make sure that your FILEDEFS are correct.

  
-* File pull_csv.fex
APP HOLDMETA TESTING
SET PCOMMA = ON
FILEDEF CHGCDXMAS DISK \\servername\\ibi\apps\testing\CHGCDX.mas
-RUN
-*
-WRITE CHGCDXMAS FILENAME=CHGCDX,SUFFIX=COM,$
-WRITE CHGCDXMAS SEGNAME=CHGCDX, SEGTYPE=S0,$
-WRITE CHGCDXMAS FIELD=OCHGCD, ALIAS=E01, ACTUAL=A6, USAGE=A6,$
-WRITE CHGCDXMAS FIELD=FILLER, ALIAS=E02, ACTUAL=A1, USAGE=A1,$
-WRITE CHGCDXMAS FIELD=NCHGCD, ALIAS=E03, ACTUAL=A6, USAGE=A6,$
-*
FILEDEF CHGCDX DISK \\servername\ibi\apps\testing\test.csv
-RUN
-*
TABLE FILE CHGCDX
PRINT
OCHGCD
NCHGCD
END
-RUN
-EXIT