× 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.



This question can't really be answered fully, without knowing the encoding
the CSV is expected in.

However at a guess I would think it will be US-ASCII, so if you are taking
the badly worded spec at face value (it least the first line) all you need
is x'0A' as this is the linefeed char.

However as the spec goes on to mention that it is 2 characters overtop of
each other (which im my opinion is utter rubbish!!) I'd bet that they really
meant to say.

Carriage return linefeed i.e. your final file should have x'0D0A' at the end
of the line.

Hope this goes someway to helping.

Neill

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Franz
Sent: 28 March 2010 18:23
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: write csv from iSeries for Oracle SQL Loader

Have been asked to provide .csv files to send to an Oracle Server.
Specs call for a "line feed" at end of each record,

<quote>Every record must end with a Line Feed character. This is a special
character. I represents 2 characters overtop of each other. Your IT staff
should know what this is. </quote>
These are specs from a vendor (IFS North America), not Oracle.

I could add a hex 25 for line feed, or hex 0d25 for carriage return & line
feed.
It's the "2 characters overtop each other" that is throwing me.
Also, in Oracle's SQL Loader specs via google, it says line feed is a unix
\n,
and carriage return is a unix \r.

I'm using RPGLE to write the file directly to the IFS (specs have
requirements for double quotes I can't get with a cpyto.. command.

So can anyone xlate the above quote from the vendor to confirm if line feed
hex 25 is all that is required? I have no access to talk directly to the
vendor techs.

thanks
Jim Franz

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.