Re: I know I should know this pt 2

What application is the file from on the pc? MS Access? FoxPro? There
will be a problem with the doubles, as Andy Nolen-Parkhouse said.

Options:
1. FTP to 400, include a QUOTE RCMD CPYFRMIMPF that uses a field
defintion on the 400.

2. Client Access or Rumba. They can both have file transfers that run
from pc command line.

3. Otherwise, something like VB or MS Access, using ODBC or ADO to
transfer the file.

steven.donnellan@simonjersey.com wrote:
>
> This is a multipart message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> (This could be a long one - avoid Reply with history!!)
> Thanks to everybody who has helped so far.  Now this is where I'm at;
> PC FILE SPECS
> Column  emid            Number (Double) 8
> Column  branch          Text    3
> Column  active          Text    1
> Column  mail            Text    1
>         *SNIP!*
> Column  newcty          Text    25
> Column  newctry         Text    20
> Column  newpost         Text    10
> Column  adid            Number (Double) 8
> Column  jba seq         Text    3
>
> AS/400 File Description
> Field       Size   Typ
> EMID           8  0 S
> BRANCH         3    A
> ACTIVE         1    A
>         *SNIP!*
> NEWPOST       10    A
> ADID           8  0 S
> JBASEQ         3    A
>
>--
Vern Hamberg

Would you like to see a challenging little arithmetic puzzle
that might get you or your kids or grandkids more interested
in math? Go to <http://cgi.wff-n-proof.com/MSQ-Ind/I-1E.htm>

Sillygism--

Something is better than nothing.
Nothing is better than a ham sandwich.
Ergo
Something is better than a ham sandwich.