• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Scheduled processing of local ASCII file

petgro

Member
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C09BE8.950C89DE
Content-Type: text/plain;
charset="iso-8859-1"

Hello,

We have to process data from another system into JDE.
We create ASCII files on our other system and store them on our network. In
JDE we created UBE's which are processing these local ASCII files into JDE
tables. When the UBE's are processed manually everything is ok.

But now we want to use the JDE scheduler to do it automatically. It seems
that the JDE scheduler cannot process the files locally. This means the UBE
cannot find the ASCII files stored on our network.

Does anyone have experience with processing local data using the JDE
Scheduler on AS/400?

Peter Groenendijk

------_=_NextPart_001_01C09BE8.950C89DE
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Scheduled processing of local ASCII file</TITLE>
</HEAD>
<BODY>



<FONT SIZE=3D2 FACE=3D"Arial">Hello,</FONT>
</P>



<FONT SIZE=3D2 FACE=3D"Arial">We have to process data from another =
system into JDE.</FONT>

<FONT SIZE=3D2 FACE=3D"Arial">We create ASCII files on our other =
system and store them on our network. In JDE we created UBE's which are =
processing these local ASCII files into JDE tables. When the UBE's are =
processed manually everything is ok.</FONT></P>



<FONT SIZE=3D2 FACE=3D"Arial">But now we want to use the JDE =
scheduler to do it automatically. It seems that the JDE scheduler =
cannot process the files locally. This means the UBE cannot find the =
ASCII files stored on our network.</FONT></P>



<FONT SIZE=3D2 FACE=3D"Arial">Does anyone have experience with =
processing local data using the JDE Scheduler on AS/400? </FONT>
</P>



<FONT SIZE=3D2 FACE=3D"Arial">Peter Groenendijk</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C09BE8.950C89DE--
 

Larry_Jones

Legendary Poster
Peter,

It would help if you could provide some information regarding your platform, database, softeware versions, etc.

Offhand I'd guess that the Logic Server where you are scheduling the job to run does not have access to the location (you said "local"?) of the ascii files (i.e. AS400 or UNIX server)
-or-
you have specified the location of the files using a network drive instead of UNC conventions.

Regards,

Larry Jones
ljones@wagstaff.com
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE
 

Jack_Crouch

Well Known Member
Well.. My heaps of OW consultants were unable to figure out how to get OW
to read or understand the IFS when pointing to a "local" type of PC file and
running on the server itself. Might be interesting to try again now that
we know more about OW now... You can also see files on NT servers from
the AS/400 using /QNTC which is amusing. However I do not know how to get
OW to use such a file.

Another approach is to use FTP to dump the file up on the AS/400 into a
"real" file (in unattended mode)... Then process from there as standard
UBE.




AS400 V4R4, B733.2, SP11.3, NT-SQL7 for CO
 
Top