Upload a table to Mainframe

20 pts.
Tags:
Mainframe
Mainframe Datasets
SQL
z/OS
z/OS configuration
How can I upload a SQL table to mainframe dataset? I want to know the proper syntax of how can i upload a table to Mainframe using FTP

Answer Wiki

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

I just noticed that this question needs an answer. I found your question while just browsing around.

You say “upload SQL table to mainframe dataset.” Does “SQL table” mean SQL Server?

I don’t think you want to upload the table directly to the mainframe. The format of the table is specific to your RDBMS and I don’t think anything on your mainframe could read it. Your “SQL table” is formatted for a specific product.

First you will need to UNLOAD your table. I say UNLOAD (and not EXPORT). You will want to have your data in a flat file for FTPing to the mainframe. And the file needs to be plain data. It cannot be formatted for any specific use. That is why you cannot use an EXPORT; EXPORT processes tend to leave the data in a format usable only by the same companies IMPORT. You want to end up with records, not rows.

As an alternative, you could use a script to SELECT from the table and write to a flat file.

You will need to know the file layout of your unloaded table. If your unloaded data contains things like NULL INDICATORS, or variable length information.

Then normal FTP process to copy the file to mainframe dataset.

Then use your file layout from above to determine file layout of your new dataset, adjusting for things like variable length records.

Now you have a flat file on z/OS and you have a record layout to match.

During the FTP process, translation can be made to occur, translating from ASCII to EBCDIC.

Now, from the mainframe, you can do whatever you like.

Steve

Discuss This Question:  

 
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following