Number of records of a subfile in Qdesgin/UNIX?

[Daniel Rodríguez]

Hi,

I think we don't have a C compiler installed in the news HP9000... I will
see...

If not, maybe I can write the result of the 'wc -l' into a file, convert it
to a fixed length and read it as a subfile... it's just an idea...

Thank you,

Daniel

2007/9/20, Franck LERAY <franck.leray at cheops.fr>:
>
>  Hi Daniel,
>
>
>
> You need to make a script which displays the number of records and a c
> stub. The c program return the number of records to the quick program. We
> use this feature in differents cases and use popen to call the script shell
> in the c program.
>
>
>
> Franck.
>
>
>
>
>   ------------------------------
>
> *De :* Daniel Rodríguez [mailto:reasegurator at gmail.com]
> *Envoyé :* jeudi 20 septembre 2007 13:45
> *À :* Franck LERAY
> *Cc :* powerh-l at lists.sowder.com
> *Objet :* Re: Number of records of a subfile in Qdesgin/UNIX?
>
>
>
> 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/d429ffd8/attachment.html