Re: Loading Employee data into PS_JOB on AS400

[S+A Sills <ssills@CYBERUS.CA>]

using the application designer save as job_import to myjob_import.  answer
yes to the peoplecode copy prompt ( I am not sure if there is any pc behind
job_import ).

change myjob_import from a view to a table and then do a build.

import into myjob_import.

then use sql to copy to ps_job.

ps

never done it, can't even spell AS400, but this might work.


>     We are trying to load employee data into PS_JOB and other tables using
>     Import Manager. Import Manager errors out when trying to insert into
>     PS_JOB, and we were told to use the JOB_IMPORT view for loading. We
>     are running PS on an AS400, and we apparently cannot update or insert
>     on views on the 400. Just wondering if someone else has run into a
>     similar problem and how they resolved it.
>
>     Also, any suggestions of alternative methods of loading employee data
>     will be appreciated.
>
>     Thanks.
>
>