Hi Peter,<br><br>Your suggestion about a getsystemval of a OS expression doesn't work (or I don't know how to do it work) but Bob should take note of it for future versions of PH.<br><br>I've solved my problem (subfile suitable for excel and not empty) with this:
<br><br>;------------------------------------------------------------<br>PROCEDURE INTERNAL VALIDAR_SUBFICHERO<br>BEGIN<br> LET TCOMANDO = "$SCRIPTS/comprobar_tamanio.ksh " + TFILE + " 0"<br> RUN COMMAND TCOMANDO NOWARN ON ERROR CONTINUE
<br> IF NOT COMMANDOK ; Greater than 0 --> OK<br> THEN<br> BEGIN<br> LET TCOMANDO = "$SCRIPTS/comprobar_tamanio.ksh " + TFILE + " 65536"<br> RUN COMMAND TCOMANDO NOWARN ON ERROR CONTINUE<br> IF NOT COMMANDOK ; Greater than 65536 --> NOT OK
<br> THEN<br> ERROR "FILE GREATER THAN 65536"<br> END<br> ELSE<br> ERROR "EMPTY FILE"<br>END<br><br>Where TFILE is the name of the subfile and $SCRIPTS/comprobar_tamanio.ksh is a Unix shell script that returns an error if the number of records of the file received as a parameter is greater than the number passed as second parameter:
<br><br><span style="font-style: italic;">wc -l $1 | read TVAR_NUM_REC unwanted</span><br style="font-style: italic;"><span style="font-style: italic;">if [ $TVAR_NUM_REC -gt $2 ] ; then</span><br style="font-style: italic;">
<span style="font-style: italic;"> exit 1</span><br style="font-style: italic;"><span style="font-style: italic;">fi</span><br style="font-style: italic;"><br><br>Thank you all,<br><br>Daniel Rodriguez<br><br><br>