I am looking for a covert utility to convert .csv files
to .dbf in Openvms. Is there such a thing?

Thanks,
Chuck

Can you tell us what you mean by .dbf files? Dbase III or IV perhaps?

Bart Zorn

Chuck Aaron wrote:
> I am looking for a covert utility to convert .csv files
> to .dbf in Openvms. Is there such a thing?
> 
> Thanks,
> Chuck

Most database products for example Oracle have nothing called sqlload,
so if you know the location of the fields you can import the data like
this.

example
$ sqlload username/password log=xyz.log control=xyz.ctl

!xyz.ctl
load data infile xzy.dat
truncate
 into into table employees

(
username positio(01:12) char,
employee_number position(13:17) char
..etc
..etc
)

Regard
Mark



Chuck Aaron wrote:
> I am looking for a covert utility to convert .csv files
> to .dbf in Openvms. Is there such a thing?
> 
> Thanks,
> Chuck

Chuck Aaron wrote:
> I am looking for a covert utility to convert .csv files
> to .dbf in Openvms. Is there such a thing?

   Others have asked for details of the target format (eg: the particular target 
database application).  The other is what format(s) the target might accept as 
input -- a specific and native format for the data to be imported, or can it 
import, for instance, XML files?

   Getting from CSV into XML is pretty easy, for instance, and can very likely 
be performed with little more than some custom DCL procedure code.

Chuck Aaron wrote:
> I am looking for a covert utility to convert .csv files
> to .dbf in Openvms. Is there such a thing?
>

Neither .cvs nor .dbf mean anything to OpenVMS. And, AFAIK and FWIW
they mean nothing to *nix. So you must be talking about DOS or Windows,
which uses file type associations. In that case they could be:

CVS Sound File
CVS Canvas Drawing File
CVS Outlook Express File
CVS Comma-separated Value File

DBF ArcView Shapefile Attribute Table File (ESRI)
DBF Database File
DBF JetForm FormFlow Data File
DBF MS Query database File
DBF Oracle 8.x Tablespace File

and whatever else you might associate with them. In OpenVMS they could
be anything at all.

If the "DBF" and "CVS" applications run on VMS, and if is logical to
exchange files between them, then there's probably a function or
utility to to so. Look there.

If neither the "DBF" application nor the "CVS" application runs on
OpenVMS, then it isn't logical to expect that a VMS conversion routine
would exist. Try Google.

In article <eeorhg$7eg$1@mailhub227.itcs.purdue.edu>, Chuck Aaron <caaron@ceris.purdue.edu> writes:
> I am looking for a covert utility to convert .csv files
> to .dbf in Openvms. Is there such a thing?

   Yes, but if we give it to you,we have to shoot you.

   8-)

   What's a .dbf?

Chuck Aaron wrote:
> I am looking for a covert utility to convert .csv files
> to .dbf in Openvms. Is there such a thing?
>
> Thanks,
> Chuck
If your reference to dbf means dbase/foxpro database files,
then there is a java tool to do this at
http://sourceforge.net/projects/dbmt
disclaimer: I havn't used it 
Phil

dooleys@snowy.net.au wrote:

> Chuck Aaron wrote:
> 
>>I am looking for a covert utility to convert .csv files
>>to .dbf in Openvms. Is there such a thing?
>>
>>Thanks,
>>Chuck
> 
> If your reference to dbf means dbase/foxpro database files,
> then there is a java tool to do this at
> http://sourceforge.net/projects/dbmt
> disclaimer: I havn't used it 
> Phil
> 

I think the CIA or, perhaps, NSA would be the appropriate places to look 
for a covert utility! ;-)

"Richard B. Gilbert" wrote:
> I think the CIA or, perhaps, NSA would be the appropriate places to look
> for a covert utility! ;-)


Or somewhere under the SYS$LOGIN of John Covert ?   :-) :-) :-) :-) :-) :-)

"Richard B. Gilbert" <rgilbert88@comcast.net> writes:

> I think the CIA or, perhaps, NSA would be the appropriate places to
> look for a covert utility! ;-)

Nonsense, hp have plenty. I'm sure they caould sell you some, and some
Integrity to go with it.

-- 
Paul Repacholi                               1 Crescent Rd.,
+61 (08) 9257-1001                           Kalamunda.
                                             West Australia 6076
comp.os.vms,- The Older, Grumpier Slashdot
Raw, Cooked or Well-done, it's all half baked.
EPIC, The Architecture of the future, always has been, always will be.