DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 704 matches
Author Message
 Topic: Cobol file without copy book
FranklinE

Replies: 51
Views: 906

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 15, 2018 8:27 am   Subject: Cobol file without copy book
There's a level of detail in your situation, which you would not provide here, which prevents me from offering any specific feedback. If you have successful reads and processing, then you have the rig ...
 Topic: Cobol file without copy book
FranklinE

Replies: 51
Views: 906

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 13, 2018 12:56 pm   Subject: Cobol file without copy book
Rumu,

Your need to split the REDEFINES to a subordinate item (higher level number) is very odd. I have many successfully imported copybooks that have the PIC clause on the REDEFINES item.

The ex ...
 Topic: Cobol file without copy book
FranklinE

Replies: 51
Views: 906

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 13, 2018 12:27 pm   Subject: Cobol file without copy book
I explained the format requirement in the third post on this page: every line must start in position 8. You can indent higher level number lines for ease of reading, but it's not required.

If your ...
 Topic: Cobol file without copy book
FranklinE

Replies: 51
Views: 906

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 13, 2018 8:46 am   Subject: Cobol file without copy book
Rumu,

Yes, what Craig said.

A bit more seriously: you are now dependent on another development environment. You need them to notify you of any changes to the code (copybooks) on which your DS jo ...
 Topic: Cobol file without copy book
FranklinE

Replies: 51
Views: 906

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Nov 09, 2018 1:17 pm   Subject: Cobol file without copy book
I had to look up the P in a PIC clause. It is an obscure usage meant to enhance or reduce the scale of the numeric format. The import wizard is not perfect -- see my FAQ for using mainframe data.

" ...
 Topic: Cobol file without copy book
FranklinE

Replies: 51
Views: 906

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Nov 09, 2018 12:24 pm   Subject: Cobol file without copy book
The text of your post doesn't indicate if what I'm about to say is accurate. I'm assuming it is.

The copybook format expected by the import wizard is simple. The first 7 bytes -- character position ...
 Topic: Cobol file without copy book
FranklinE

Replies: 51
Views: 906

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Nov 09, 2018 11:10 am   Subject: Cobol file without copy book
First, you have my sympathy for a mainframe development process that doesn't comply with basic standard practice. For a multiple record file, there is no such thing as an "optional" header.

The imp ...
 Topic: Cobol file without copy book
FranklinE

Replies: 51
Views: 906

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 07, 2018 8:50 am   Subject: Cobol file without copy book
My implementation is z/OS mainframe, and we handle what you describe as you describe it.

FTP Enterprise stage for input:
Format tab:
Record type = implicit
Delimiter = none
Character se ...
 Topic: String To Decimal Conversion Error
FranklinE

Replies: 3
Views: 140

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 06, 2018 12:28 pm   Subject: String To Decimal Conversion Error
Your input columns are all VarChar(7), your output column is Decimal(5,2). You have two fewer bytes on output, and unless you either trim the string to 5 bytes or increase the decimal to 7,2 you will ...
 Topic: Cobol file without copy book
FranklinE

Replies: 51
Views: 906

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 30, 2018 12:49 pm   Subject: Cobol file without copy book
Based on a copybook I use that is similar to yours, it should work.

You only need one 01 line. You only need one 05 Header section. You're import will show the redefines for the 05 body sections. T ...
 Topic: Cobol file without copy book
FranklinE

Replies: 51
Views: 906

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 30, 2018 11:52 am   Subject: Cobol file without copy book
That's a good start.

You have 4 types of records, each with a unique value in RDT-REC-CODE. Every record type has a common area, 82 bytes "header" and the trailer.

Your copybook can be reviewed ...
 Topic: Cobol file without copy book
FranklinE

Replies: 51
Views: 906

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 30, 2018 11:00 am   Subject: Cobol file without copy book
I'm not sure what you're asking, so let me know if I missed what you need.

The copybook text file can have any extension. The import wizard for COBOL FD finds copybook files for import with the def ...
 Topic: Cobol file without copy book
FranklinE

Replies: 51
Views: 906

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 30, 2018 7:41 am   Subject: Cobol file without copy book
Rumu,

There's a link to the FAQ for using mainframe files at the bottom of my post.

To answer your last question first: the import wizard for COBOL FD looks for .cfd on file names. I've never tr ...
 Topic: Best way to call a Shell Script
FranklinE

Replies: 5
Views: 175

PostForum: General   Posted: Tue Oct 23, 2018 10:27 am   Subject: Best way to call a Shell Script
I avoid using the correct name "Execute Command" because it sounds like I'm ordering someone's demise.

But yes, that's the one, officer. I saw it do the deed.
Laughing
 Topic: Best way to call a Shell Script
FranklinE

Replies: 5
Views: 175

PostForum: General   Posted: Tue Oct 23, 2018 6:43 am   Subject: Best way to call a Shell Script
As Craig mentions, it depends on some specifics, but I use a specific standard for the first decision about "where": what level of error handling does it require?

The Exec stage is best for this. I ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours