sending data from cobol to DB2

Tags:
Development
hello, i have a huge cobol flat files containing large amount of data.how should i move(copy) this to DB2 tables and vice versa(i.e) from tables to files, without using File aid or QMF. any suggestion would be gracecefully accepted. thanx in advance
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you’re using the AS/400, you can directly use the flat file from within DB2. The same may be true on other DB2 versions.

Assuming your flat file xxx is in library yyy, and your library separator character is set to slash, try this in SQL:

SELECT * FROM yyy/xxx;

That will tell you pretty quickly whether any conversion or loading is needed on your system.

Sheldon Linker (sol@linker.com)
Linker Systems, Inc. (www.linkersystems.com)
800-315-1174 (+1-949-552-1904)

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Programming44
    helo, the conversion should be on mainframes because i am working on it,i.e from cobol-74/85 to DB2 and viceversa. thanx in advance
    0 pointsBadges:
    report
  • PscJohnD
    It depends on what you are trying to accomplish. If you want to load data into a DB2 database for use by other applications, talk the DBAs about setting up your data and the DB2 tables. They will have your installation's preferred DB2 load and unload tool. If you want to generate reports and/or statistics about the data in the flat file, some tools that may be available at your installation are Syncsort, Easytrieve and SAS.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: