<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>Problems using FORMAT WP51 in a download</TITLE>
</HEAD>
<BODY>
<P><FONT FACE="Arial">Hi,</FONT>
</P>
<P><FONT FACE="Arial">We have been on R17, which is also on a new Unix box, for about 8 weeks now and just recently discovered a problem. When we run queries which include the FORMAT WP51 command in the download statement, garbage is returned. Below is a sample of the download code and file contents.</FONT></P>
<BR>
<P><FONT FACE="Arial">062: GET.LIST XHR.CAFE.SEL1 </FONT>
<BR><FONT FACE="Arial">063: DOWNLOAD HRPER N12.HOME.LABEL N12.HRP.PERSON.SSN HRP.BIRTH.DATE N12.CDF.BD.</FONT>
<BR><FONT FACE="Arial">DESC NUM.VALUES ALL FORMAT WP51 FILE &HOLD& CAFEPAGE1S.DAT OVERWRITING </FONT>
<BR><FONT FACE="Arial">064: COPY FROM _HOLD_ TO OUTGOING CAFEPAGE1S.DAT OVERWRITING </FONT>
<BR><FONT FACE="Arial">065: CLR </FONT>
</P>
<P><FONT FACE="Arial">:AE OUTGOING CAFEPAGE1S.DAT </FONT>
<BR><FONT FACE="Arial">Changed 8805 CHAR(0) to ^Z-E-R-O^ </FONT>
<BR><FONT FACE="Arial">Top of "CAFEPAGE1S.DAT" in "OUTGOING", 3,866 lines, 184,076 characters. </FONT>
<BR><FONT FACE="Arial">0001: WPCG|^Z-E-R-O^^Z-E-R-O^| </FONT>
<BR><FONT FACE="Arial">*---: Q </FONT>
<BR><FONT FACE="Arial">Quit "CAFEPAGE1S.DAT" in file "OUTGOING" unchanged.</FONT>
</P>
<P><FONT FACE="Arial">Can anyone offer any suggestions as to what is causing this to happen? Is it possible that a parameter wasn't set up properly under Unix or someplace in Colleague? This worked fine in R16 with the 6.0 version of Download. Any assistance in solving this mystery would be greatly appreciated. Our HR department uses this process to prepare employee benefit packages and we need to get this up and running as soon as possible.</FONT></P>
<P><FONT FACE="Arial">Thank you,</FONT>
<BR><FONT FACE="Arial">Cindy Mack</FONT>
<BR><FONT FACE="Arial">Sr. Application Analyst</FONT>
<BR><FONT FACE="Arial">Niagara University</FONT>
<BR><FONT FACE="Arial">Niagara University, NY 14109</FONT>
<BR><FONT FACE="Arial">Voice: 716.286.8038</FONT>
<BR><FONT FACE="Arial">Fax: 716.286.8045</FONT>
<BR><FONT FACE="Arial">E-Mail: cmack@niagara.edu</FONT>
</P>
</BODY>
</HTML>