Hi All,

I am VERY new as a programmer, and there are a lot of methods and techniques which I am not familiar. Please help! Here's my question. My company has a mainframe with all kind of data. I have an SQL server. I have access to both the mainframe and the SQL. My question is, is there a way to transfer ONLY data that I want from the mainframe to the SQL? What method is ther that I can use; must I FTP the data, or can I use tools provided my SQL to get the data?

Thanks for all your help!

Leon

The mainframe can automate the FTP process and place the file in an accesible area, then you can use a job to run a dts package to load the data into your database. The file you will import will most likely be a comma delimited file.



Sal

What database is the mainframe running? You might be able to connect to the mainframe directly with a SQL dts package and import the data that way.

Peter
------------------------------------------------------
Work smarter, not harder.

Hi Sal,

Often, I use the mainframe to FTPs delimited files to my PC hard drive. The string I use in the mainframe to do so look something like this:
PUT 'PHR.LP77U.DBSEQ.LEONTEST.D040114.T082400' D:\MYFOLDER\LEONTEST.DNL

NOTE: the above string is one line.
The problem with this is everytime I have an updated file, I have to manually go into the mainframe to change the date and time of the string. Then I'll have to type in "SUBMIT" to transfer the file.

Is there a way to automate this process, instead of manually submit it? If I need to FTPs data into my SQL Server, instead of to my "D:" drive, how do I do so? Is it even possible to FTPs the data directly from the mainframe to SQL, or must I FTP to an accessible area first? What iformation do I need from the SQL server if I can FTP to it directly? Thank you!!

LEon

The mainframe is running on a DB2 database. Please take a look at the reply I made to Sal above. Thank you.

Leon