How can I load a binary file?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
skg6ds
Participant
Posts: 10
Joined: Wed Sep 23, 2009 12:48 am

How can I load a binary file?

Post by skg6ds »

subject lines describe the actual issue for a better chance of assistance*
Last edited by skg6ds on Wed Sep 23, 2009 11:18 pm, edited 1 time in total.
Barath
Participant
Posts: 17
Joined: Mon Sep 29, 2008 4:00 am
Location: Mumbai

Re: help me

Post by Barath »

Hi,
First u need to create PL/I definition for that file .

sequential file -----> format----->record level---->format as ----->select mainframe(COBOL)
try with this and let me know
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

The term "binary" doesn't specify what type of binary file you have. Is it a COBOL type binary with COMP-3 and perhaps EBCDIC? Without that information nobody will be able to assist.
Sreenivasulu
Premium Member
Premium Member
Posts: 892
Joined: Thu Oct 16, 2003 5:18 am

Post by Sreenivasulu »

You can try to extract the entire file contents in a single column and load to the database

Regards
Sreeni
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Give thought to better subject selection please.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
skg6ds
Participant
Posts: 10
Joined: Wed Sep 23, 2009 12:48 am

how to load a binary mainframefile

Post by skg6ds »

Actually my requirement is to load a binary file which is from mainframes
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Actually, your new requirement is to explain to us exactly what you mean by "binary file" in this context. As noted, without a proper explanation of what you need to do, we're all guessing as to the solution.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply