Number of records of a subfile in Qdesgin/UNIX?

[Daniel Rodríguez]

Hi Frank,

We use these portable subfiles to export it to SAP, Streamserve, excel and
other aplicactions and we write the carriage return in each line of the
subfile, so the command 'wc -l' works properly.

I will try with the DO EXTERNAL option calling a Unix shell script.

Merci beaucoup pour l'aide, Frank! Je suis spagnol et écrire en anglais est
aussi trés compliqué pour moi.

Daniel Rodriguez,




2007/9/20, Franck LERAY <franck.leray at cheops.fr>:
>
>  On unix box, you can't use the same method.
>
>
>
> 2 problems
>
> First
>
> You can't use do command statement, a variable set by a soon process is
> not visible from the parent process.
>
> You have to do an external subroutine (callable by the do external
> command).
>
>
>
> Second
>
> The "wc –l" command will not work like on 3k platform because on unix
> there's no carriage return in the subfile. So the wc –l command will not
> return the number of records.
>
> You have to do a unix script. This script will use the qshow command. This
> command will return the number of records.
>
>
>
> Hope this help (excuse my poor English….)
>
> Franck.
>
>
>
>
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: &quot;subscribe&quot; in message body to
> powerh-l-request at lists.sowder.com
> Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to
> powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com powerh-l' to your search terms to search the
> list archive at Google.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070920/7a88d674/attachment.html