Number of records of a subfile in Qdesgin/UNIX?

[Franck LERAY]

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 <http://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/2e918716/attachment.htm