Conference iamok::dtrdig

3007.0. "lines greater than 255 char?" by GIDDAY::REINHOLD () Wed Apr 30 1997 01:15

    Gidday,
    
           I have a customer whom is trying to copy data from an RMS file
    to a PC, in doing so he was planning on using DATATRIEVE. He has 
    run into a snag, the output requires lines of longer than 280
    characters (as it is COMMA delimited).
    	   I believe that DTR has a line limit of 255 characters (like most
    things), though I am having problems convincing the customer that this
    is an architectual limit.
    	   I have suggested that he uses the WRAP facility, but this will 
    break the import into EXCEL.
    
    	   Is there any other way around this ? Is there any other VMS
    tools that may do this? If not, would probably a tool like DBI GW for
    RMS (NSDS) handle the data better than DTR?
    
    	   Any suggestions/comments/help greatly appreciated.
    
    				
    					Dave Reinhold
    					Digital CSC, Sydney, 
    					Australia.
    
    

    Dave,
    
    I presume you mean the restriction of a width of 255 for a report.
    
    You can create a comma separated file by defining a domain with a
    single field with (e.g.) PIC(2000), format each record as a string in
    DTR, then write each record out to the domain.  You would then need to
    copy the file to the PC somehow (FTP, file share, etc.).
    
    This seems to work OK for EXCEL, it just seems to ignore the trailing
    blanks in the record.
    
    HTH,
    
    Wayne Harridge
    MEO - NSIS
    
     

    Thanks Wayne,
                 Sorry I'm not a DTR person at all.
    
    		 Thanks for the suggestion, I have passed it onto the
    customer. The response was something like "I didn't think of that...."
    
    
    
    					Cheers,
    						Dave