Development and testing on Localhost

[Kingston]

If I import an iseries file into my repository and develop an application that reads data from that file, when I test it in localhost, should I expect it to bring back data from the Iseries? or does the imported file become a local copy with no data in it?

I notice that when I right click on the file in the Repository it has an option to "Copy data from IBMi (no rule)"

Does that mean that running a test in Localhost will bring back no data unless I copy the data over from the Iseries?

I'm sure this used to work but maybe I'm remembering incorrectly. Currently the test page runs fine and shows the list column headers but does not bring back any data. When I run it on the Iseries, it does bring back data.

[MarkDale]

The local file does not contain any data, so you would need to copy in, or generate data for the local file somehow.

The Copy data from IBMi sounds like a good option, though I haven't tried it.

When you are running on localhost you are looking at the (empty) local files.

[Kingston]

Thanks. I must be remembering wrongly then as I thought it used to fetch the data from the iseries.

I will try the Copy Data option and see how I go

[jyoung]

The File (table) initially will not contain any data and the "Copy" option does not show up until the File is checked in.

I used to use the "Copy data ..." a lot until I blew out the SQL Server Express data limits. Unfortunately there is no way to specify a filter in the copy so you end up getting EVERYTHING in the File. You may want to check out this viewtopic.php?f=3&t=1357 discussion.

All of my "import" scripts are like this now. Of course, if you are able to have something other than SQL Express, say SQL Developer you may not have those problems.