Hi Frank,<br><br>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.<br>
<br>I will try with the DO EXTERNAL option calling a Unix shell script. <br><br>Merci beaucoup pour l'aide, Frank! Je suis spagnol et écrire en anglais est aussi trés compliqué pour moi.<br><br>Daniel Rodriguez,<br><br>
<br><br><br><div><span class="gmail_quote">2007/9/20, Franck LERAY <<a href="mailto:franck.leray@cheops.fr">franck.leray@cheops.fr</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="FR">
<div>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">On unix box, you can't use the same method.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">2 problems</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">First</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">You can't use do command statement, a variable
set by a soon process is not visible from the parent process.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">You have to do an external subroutine (callable by
the do external command).</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">Second </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">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.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">You have to do a unix script. This script will use
the qshow command. This command will return the number of records.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">Hope this help (excuse my poor English….)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">Franck.</span></font></p>
<p><span lang="EN-GB"> </span></p>
<p><span lang="EN-GB"> </span></p>
</div>
</div>
<br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: &quot;subscribe&quot; in message body to
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">
http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>This list is closed, thus to post to the list you must be a subscriber.<br>Add 'site:<a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.sowder.com" target="_blank">
lists.sowder.com</a> powerh-l' to your search terms to search the list archive at Google.<br></blockquote></div><br>