Scheduled processing of local ASCII file

petgro · Feb 21, 2001

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>

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


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

Larry_Jones · Feb 21, 2001

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
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE

Jack_Crouch · Feb 23, 2001

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

Scheduled processing of local ASCII file

petgro

Member

Larry_Jones

Legendary Poster

Jack_Crouch

Well Known Member

Similar threads

We value your privacy