[Download-List] Problems using FORMAT WP51 in a download

[David L. Rotman]

I've not seen this problem on Unidata 5.1 but I'll list a couple of
items
regarding later versions that might help...

Beginning with Unidata 6.0, the "zero" character is changeable
via udtconfig.  IBM/Unidata also changed the default value from 128 to
131.

To see if this is your problem, edit the file DOWNLOAD in
DOWNLOAD.SOURCE.
In the routine DBMS.UNIDATA.SET.UP, change the assigment
  OP.SYS.ZERO.CHAR = CHAR(128)
to
  OP.SYS.ZERO.CHAR = CHAR(131)
or (better)
  OP.SYS.ZERO.CHAR = GETENV('ZERO_CHAR')


Remember to re-compile and re-catalog the program:
   BASIC DOWNLOAD.SOURCE DOWNLOAD
   CATALOG DOWNLOAD.SOURCE DOWNLOAD DIRECT FORCE
Quit out of Unidata and come back in to make sure your COMMON
is cleared.

If the zero-character proves not to be a problem, you might also want
to check how the file is being transferred to the PC.  If this is done
via FTP, you will want to make sure that binary mode (rather than
ASCII mode) is selected.



Dave Rotman
Director of Computer Services
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819

>>> cmack at niagara.edu 10/6/2003 3:13:14 PM >>>
Hi Frank,
 
Our Unidata version stayed the same when we went to R17, Envision 4.7.1
-
we are on Unidata 5.1  What routines should we be recompiling to fix
the
zero byte problem?  Thanks for any additional insights you can
provide.
 
Cindy

-----Original Message-----
From: Bright, Frank [mailto:FBright at uarts.edu] 
Sent: Friday, October 03, 2003 8:14 PM
To: 'download-list at cedarville.edu' 
Subject: RE: [Download-List] Problems using FORMAT WP51 in a download


Cindy,
 
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.
 


Frank!
 

 

----------------------------------------------------------------------------
------------
Frank M. Bright, Jr. 
Administrative Computing                fbright at uarts.edu 
University of the Arts (A15)             <http://www.uarts.edu/>
www.uarts.edu 
320 S. Broad St.                                   215-717-6081(w) 
Philadelphia, PA 19102                             215-717-6087(f) 
Colleague 17.0.14            AIX 5.2.0.1           Unidata 6.03

-----Original Message-----
From: Cindy Mack [mailto:cmack at niagara.edu] 
Sent: Friday, October 03, 2003 9:33 AM
To: 'download-list at cedarville.edu' 
Subject: [Download-List] Problems using FORMAT WP51 in a download



Hi, 

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.


062: GET.LIST XHR.CAFE.SEL1

063: DOWNLOAD HRPER N12.HOME.LABEL N12.HRP.PERSON.SSN HRP.BIRTH.DATE
N12.CDF.BD. 
DESC NUM.VALUES ALL FORMAT WP51 FILE &HOLD& CAFEPAGE1S.DAT OVERWRITING

064: COPY FROM _HOLD_ TO OUTGOING CAFEPAGE1S.DAT OVERWRITING

065: CLR 

:AE OUTGOING CAFEPAGE1S.DAT

Changed 8805 CHAR(0) to ^Z-E-R-O^

Top of "CAFEPAGE1S.DAT" in "OUTGOING", 3,866 lines, 184,076
characters.

0001: WPCG|^Z-E-R-O^^Z-E-R-O^|

*---: Q

Quit "CAFEPAGE1S.DAT" in file "OUTGOING" unchanged. 

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.

Thank you, 
Cindy Mack 
Sr. Application Analyst 
Niagara University 
Niagara University, NY  14109 
Voice:  716.286.8038 
Fax:     716.286.8045 
E-Mail: cmack at niagara.edu