Hi all,
I have a requirement to build a server job to pull columns from a flat file on the Mainframe and then use them to populate an Oracle table. What type of stage should I use for my Mainframe flat file?
Thank you,
Seyed
Reading Mainframe flat file to populate Oracle table
Moderators: chulett, rschirm, roy
Hi Craig,
Thank you for your input. I tried using Complex Flat File, but I don't see that as an option. Therefore, I tried using a FTP stage. Now, I am getting the following error message:
I know the name of the dataset on the Mainframe, but don't know which FTP address to open. I have access to the needed dataset on the Mainframe. I can logon to the Mainframe and browse the data.
Thank you,
Seyed
Thank you for your input. I tried using Complex Flat File, but I don't see that as an option. Therefore, I tried using a FTP stage. Now, I am getting the following error message:
Code: Select all
Load_Wrkr_Loc_test..FTP_Plug_in_0: Connection to the remote host's FTP server failed, socket call 'connect' failed
Thank you,
Seyed
I was wondering if I'd need to clarify that. The CFF stage is for reading the file but you first need to get the file from the mainframe to your ETL server, how you do that is completely up to you.
Can't help with the specifics of your FTP question, can you take it to your mainframe admin and see what the protocol there is? We process some files from a mainframe source here but they push them all to us.
Can't help with the specifics of your FTP question, can you take it to your mainframe admin and see what the protocol there is? We process some files from a mainframe source here but they push them all to us.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: