Changing a certain demand report into a source physical file

Asked By Lisette Patterson 0 points N/A Posted on - 02/23/2012

I need someone to guide me on how to change a certain demand report into a source physical file since I have been informed that only database tables or source physical files are the only type that can be sent to I series. It is important that I transfer this report to excel. Apart from using Client Access Data Transfer is there any other program that I might use and what command should I use to change the saved report into a source file? Please help.             

• Status: Open
• Question Views: 859
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Misc Databases

Best Answer by lee hung

Go To Solution

Answered By Iamexpert 0 points N/A #104617

Changing a certain demand report into a source physical file

Hi

The question you are asking and then have given the suggestion and you have answer in your own question because there is no other way to do this the only option is the way you have telling and this is the way to easily transfer from one place to another in any way you want so you have to do this otherwise you will not be able to do this and this will not be done in any other solution so try to do this in the way you have tell and it will solve your  problem I know this is little tough task but this is the only option you have no other options so do this in this way you have define above.

About Iamexpert

Questions
0

Answers
195

Best Answers
34

• Vote Up 0 Vote Down

• Posted on - 02/23/2012
• Question Category: Misc Databases

Best Answer

Best Answer

Answered By lee hung 75 points N/A #104618

Changing a certain demand report into a source physical file

Hi there,

You should follow the below steps to perform data transfer from physically file into an Excel sheet.

1. Open Microsoft Excel
2. Click on Tools option from the Toolbar
3. Click on iSeries Access Data Transfer option. If this doesn’t display, click on double arrow.
4. Transfer data window will be opened
5. Select the Create New and choose whether to include column headings..
6. Click on OK
7. Now select the iSeries server the data is to be downloaded from and click the Next
8. Now if you know the library/file (member), type it in and click the Next button otherwise click the Browse button. If you click the Browse button, a new window to connect to the iSeries may be displayed. If so, type in the user ID and password. A list of libraries in the library list is displayed. Click on the plus sign (+) next to the library where the file exists. The list expands to show all the files in that library. If the file contains members, the list expands to display the list of members. Double-click on the member that is to have the data transferred to the Excel spreadsheet, and click on the OK button. Click the Next button.
9. On the next screen, click the Next button.
10. If this transfer request will be used again, type in a file name and location to where it is to be saved; otherwise, leave the File name box empty.
11. Click the Finish button

About lee hung

Questions
3

Answers
1451

Best Answers
463

• Vote Up 0 Vote Down

• Posted on - 02/24/2012
• Question Category: Misc Databases

Answered By Lisette Patterson 0 points N/A #104620

Changing a certain demand report into a source physical file

Thank you Heiley Paint for your solution. I followed the steps you gave in using the iSeries Data Access Transfer. I'm really glad with the help that you gave. I thought I'll never be able to do it. Thanks again.

Thanks TechyV!

About Lisette Patterson

Questions
15

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/05/2012
• Question Category: Misc Databases