<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Problems using FORMAT WP51 in a download</TITLE>
<META content="MSHTML 6.00.2800.1226" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=164153100-04102003><FONT face=Arial color=#0000ff
size=2>Cindy,</FONT></SPAN></DIV>
<DIV><SPAN class=164153100-04102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=164153100-04102003><FONT face=Arial color=#0000ff size=2>The
problem is that the zero byte for the program has changed. We went to a
new version of Unidata and it did the same thing. Try recompiling the
routines. This should find the correct zero byte and fix the
problem.</FONT></SPAN></DIV>
<DIV><SPAN class=164153100-04102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV><SPAN class=164153100-04102003><FONT face=Arial
color=#0000ff size=2>
<DIV><BR>Frank!</DIV>
<DIV> </DIV>
<DIV></FONT></SPAN>
<DIV class=Section1>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> <?xml:namespace prefix = o ns
= "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">----------------------------------------------------------------------------------------<BR></SPAN><SPAN
style="FONT-SIZE: 14pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">Frank
M. Bright, Jr.</SPAN><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt">
</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><BR></SPAN><SPAN
style="FONT-SIZE: 11pt; COLOR: green; FONT-FAMILY: 'Letter Gothic'; mso-bidi-font-size: 10.0pt">Administrative
Computing</SPAN><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: 'Letter Gothic'; mso-bidi-font-size: 10.0pt">
</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Letter Gothic'"><SPAN
style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN><I><SPAN
style="mso-spacerun: yes"> </SPAN><SPAN
style="COLOR: purple">fbright@uarts.edu</SPAN></I> <BR></SPAN><SPAN
style="FONT-SIZE: 11pt; COLOR: red; FONT-FAMILY: 'Letter Gothic'; mso-bidi-font-size: 10.0pt">University
of the Arts (A15)</SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Letter Gothic'"><SPAN
style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN></SPAN><A
href="http://www.uarts.edu/"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Letter Gothic'"><FONT
color=#800080>www.uarts.edu</FONT></SPAN></A><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Letter Gothic'"> <BR></SPAN><SPAN
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Letter Gothic'; mso-bidi-font-size: 10.0pt">320
S. Broad St.<SPAN
style="mso-spacerun: yes">
</SPAN><SPAN
style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN>215-717-6081(w)
<BR>Philadelphia, PA 19102<SPAN style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN>215-717-6087(f)
<BR>Colleague 17.0.14<SPAN style="mso-spacerun: yes">
</SPAN><SPAN style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN>AIX 5.2.0.1 <SPAN
style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN>Unidata 6.03</SPAN></P></DIV></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Cindy Mack
[mailto:cmack@niagara.edu]<BR><B>Sent:</B> Friday, October 03, 2003 9:33
AM<BR><B>To:</B> 'download-list@cedarville.edu'<BR><B>Subject:</B>
[Download-List] Problems using FORMAT WP51 in a download<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></BODY></HTML>