×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Exporting Cobol FDA files from MS Access

thread709-1552170

Exporting Cobol FDA files from MS Access

Exporting Cobol FDA files from MS Access

(OP)
My latest project to to generate files that can be imported to a Mainframe and viewed on the terminal screen.  Aside from the samples, I've been told "all they need" is a standard Cobol FBA (or FDA?) file with 133 chr record length.

Is there an easy way for MS Access to generate this kind of file?

 

RE: Exporting Cobol FDA files from MS Access

Assuming that the Access table's field definitions match the expected output format, all you'll have to do is <F>ile, <E>xport, select "Text Files (*.txt...)" as the output format and let 'er go.

If the field definitions don't match, you can create another table that does match, copy the relevant data into this table, then export it.

RE: Exporting Cobol FDA files from MS Access

(OP)
Appreciate it!
And if it was simply data that would work.

The samples they sent Me are a fully formatted report with page headers/column headers/lines (like ___________)/Totals and Grand totals.

Is there an easy way to export a REPORT into that format?

RE: Exporting Cobol FDA files from MS Access

Good question!

I just tried using <F>ile <Export> with one of my reports to an MS-DOS .txt file: formatting and data remained intact, but the lines, (used to separate report sections), were omitted.
 

RE: Exporting Cobol FDA files from MS Access

(OP)
The COBOL FDAs (from what I'm told) also require a fixed record length.
When I exported the report, any trailing Spaces were trimmed, as were any CR/NL characters.  I tried using an RS character (Ascii chr(30)) to hold the record length, but apparently thier system only recognizes the CR/NL characters...

RE: Exporting Cobol FDA files from MS Access

Is it possible to add a new field at the end of the field list, which would just have the CR/NL characters inserted, so as to provide what Cobal needs?  I've no idea if Access will even allow such, but I just figured it may be worth a shot.

Well, this post may be a bit too late...

--

"If to err is human, then I must be some kind of human!" -Me

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!
Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close