× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.





Here is what I got by copying a 3 record file with three fields: a one digit numeric field followed by a 16 character alpha field followed by another one digit numeric field:

1  ,"8888877776654321",2
3  ,"9992509516956789",4
5  ,"9992509516443322",6

The commands I used were:

CPYTOSTMF FROMMBR('/qsys.lib/charly.lib/qddssrc.file/atest.mbr')
    TOSTMF( '/home/charly/querya') STMFCODPAG(*PCASCII)

to create the stream file with a code page of 1252

then:

CPYTOIMPF FROMFILE(CHARLY/ATEST) TOSTMF('/home/charly/querya')
  MBROPT(*REPLACE) TOCCSID(*FILE) RCDDLM(*CRLF) DTAFMT(*DLM)
  STRDLM('"') FLDDLM(',') NULLIND(*NO) DECPNT(*PERIOD)
  DATFMT(*ISO) TIMFMT(*ISO)

So my question is: why aren't you getting double quotes around your alpha field?

-- Charly

Merlin Inc
Box 640
Gig Harbor WA 98335 USA
253 265-6244





From: "Fisher, Don" <Dfisher@xxxxxxxxxxxxxxxxx>
Reply-To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Subject: RE: CPYTOIMPF and numerics > 15 Digits
Date: Wed, 25 Jun 2003 17:01:51 -0400

That is interesting. Are you using a string delimiter (STRDLM)?

Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx

<clip>
However, if I open it with notepad, here is one of the lines:

30,1610,2,5251255,V,9992509516956650,83656,14,14,0,20030606,0,0

the 9992509516956650 should be 9992509516956651 and is listed as a 16 alpha
in the database file.
<clip>
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.