Talk About Network



Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Cobol > Thoughts on MF ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 20 Topic 4100 of 4115
Post > Topic >>

Thoughts on MF COBOL, Unix, and RDBMS

by "Pete Dashwood" <dashwood@[EMAIL PROTECTED] > May 3, 2008 at 12:51 PM

I have some programs written in Fujitsu COBOL (generated by a tool) that
run 
in a Windows environment, read ISAM and write a RDB using embedded SQL and

ODBC.

I would like to have these programs run in a Unix environment. There is a 
COBOL compiler (MicroFocus) available but it doesn't support SQL, and the 
ISAM is C-ISAM. :-)

The fundamental problem is one we see here quite often; The ISAM files
were 
created by COBOL, are "COBOL oriented" (may contain packed and binary 
fields) and this means that accessing them with a language other than
COBOL, 
while not impossible, is fraught with danger and problems. So, it makes 
sense to read them with COBOL. (Especially as there is a COBOL compiler
for 
the platform available.) COBOL definitions of the files are available.

Having got the data, the COBOL program would normally move the fields to 
equivalent host variables and write them to the database, but it can't do 
that because the MF COBOL on the platform doesn't support embedded SQL in 
COBOL.

So maybe the generated code should simply write the data out as strings
that 
can be INSERTED with a script, as another step in the process.

Maybe it should generate a .CSV or maybe an XML file (either of which can
be 
easily imported into most RDBs)

Or maybe this is not a good approach at all...

Given my unfamilairity with Unix environments I may have missed something 
that is normal in that environment.

I'd be interested to hear suggestions, ruminations, musings, thoughts, 
preferably helpful and constructive (but, this being Usenet, I'm not
holding 
my breath...) on how some of you might approach this.

Pete
-- 
"I used to write COBOL...now I can do anything."




 20 Posts in Topic:
Thoughts on MF COBOL, Unix, and RDBMS
"Pete Dashwood"  2008-05-03 12:51:38 
Re: Thoughts on MF COBOL, Unix, and RDBMS
Richard <riplin@[EMAIL  2008-05-02 18:53:39 
Re: Thoughts on MF COBOL, Unix, and RDBMS
"Pete Dashwood"  2008-05-03 15:41:54 
Re: Thoughts on MF COBOL, Unix, and RDBMS
Richard <riplin@[EMAIL  2008-05-03 01:16:10 
Re: Thoughts on MF COBOL, Unix, and RDBMS
Robert <no@[EMAIL PROT  2008-05-03 01:05:28 
Re: Thoughts on MF COBOL, Unix, and RDBMS
"Pete Dashwood"  2008-05-03 19:31:47 
Re: Thoughts on MF COBOL, Unix, and RDBMS
Robert <no@[EMAIL PROT  2008-05-03 19:59:52 
Re: Thoughts on MF COBOL, Unix, and RDBMS
"Pete Dashwood"  2008-05-05 10:40:34 
Re: Thoughts on MF COBOL, Unix, and RDBMS
"William M. Klein&qu  2008-05-05 03:22:35 
Re: Thoughts on MF COBOL, Unix, and RDBMS
"Pete Dashwood"  2008-05-05 17:40:19 
Re: Thoughts on MF COBOL, Unix, and RDBMS
"James J. Gavan"  2008-05-05 16:20:22 
Re: Thoughts on MF COBOL, Unix, and RDBMS
Frederico Fonseca <rea  2008-05-04 11:01:51 
Re: Thoughts on MF COBOL, Unix, and RDBMS
Robert <no@[EMAIL PROT  2008-05-04 14:01:25 
Re: Thoughts on MF COBOL, Unix, and RDBMS
Frederico Fonseca <rea  2008-05-04 22:33:18 
Re: Thoughts on MF COBOL, Unix, and RDBMS
Rene_Surop <infodynami  2008-05-04 03:51:48 
Re: Thoughts on MF COBOL, Unix, and RDBMS
"Pete Dashwood"  2008-05-05 10:48:42 
Re: Thoughts on MF COBOL, Unix, and RDBMS
"James J. Gavan"  2008-05-04 23:03:51 
Re: Thoughts on MF COBOL, Unix, and RDBMS
Richard <riplin@[EMAIL  2008-05-04 18:18:51 
Re: Thoughts on MF COBOL, Unix, and RDBMS
"Pete Dashwood"  2008-05-05 14:42:18 
Re: Thoughts on MF COBOL, Unix, and RDBMS
"Pete Dashwood"  2008-05-05 14:28:51 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed May 14 2:25:10 CDT 2008.