Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to use 2 Files in 1 CL Program?

147 views
Skip to first unread message

Rafal Winnicki

unread,
Aug 31, 1998, 3:00:00 AM8/31/98
to
Paul Nicolay wrote:

> Hi Stefan,
>
> CL is limited to a single file.
>
> Regards,
> Paul
> ______________
> Stefan Leung <lor...@hknet.com> wrote in article
> <35ea9...@ruby.hknet.com>...
> > I'm kinda new to CL Programming and the AS400 system...
> > Can I use 2 files in 1 CLP, while one is a database file and the other is
> a
> > display file? If it is possible, how?
> >
> >
> >
> >
> >
>
> The contents of this message express only the sender's opinion.
> This message does not necessarily reflect the policy or views of
> my employer, Merck & Co., Inc. All responsibility for the statements
> made in this Usenet posting resides solely and completely with the
> sender.
>

It is possible to use 2 files in CL program, whether one is a display file and
the second is data base file.
You must associate data queue with display file and not to declare it. The
second file you may declare as usual.
Sources of such a program are available.

Regards,
Rafal.


Richard Knechtel

unread,
Aug 31, 1998, 3:00:00 AM8/31/98
to
Paul Nicolay wrote:
>
> Hi Stefan,
>
> CL is limited to a single file.
>

And to add on to Paul's repsonse the file can only be used to for read
purposes only. You cannot write to the file you use.


--
Richard Knechtel
email(richard dot knechtel at centrobe dot com)
Centrobe
(Systems Engineer/System Administrator)
(Aspiring AS/400 GURU)
(Aspiring Linux GURU)
(Aspiring Visual Basic Programmer)

gpo...@pobox.com

unread,
Sep 2, 1998, 3:00:00 AM9/2/98
to
On Mon, 31 Aug 1998 07:49:52 -0700, Richard Knechtel <ab...@aol.com>
wrote:

>Paul Nicolay wrote:
>>
>> Hi Stefan,
>>
>> CL is limited to a single file.
>>
>
>And to add on to Paul's repsonse the file can only be used to for read
>purposes only. You cannot write to the file you use.

Did you remember old WRTSRC TAATOOL command? Have you heard about any
other stuff like this to write physical files within CL programs?

I've been using query management to accomplish but it sucks.

Porto
----------------------------------------
Porto
"Bis dat qui cito dat"

Paul Nicolay

unread,
Sep 2, 1998, 3:00:00 AM9/2/98
to
Hi,

However their might be workarounds, I guess it's not worth the trouble.
Once I need some files, I move to ILE-RPG. I even tend to do so for CLs
that just need a display file, however it's a personal opinion.

Kind regards,
Paul
__________________
gpo...@pobox.com wrote in article <35ed9edb...@enews.newsguy.com>...

tho...@inorbit.com

unread,
Sep 3, 1998, 3:00:00 AM9/3/98
to
Paul:

In a pinch, I have a couple commands using QLGSORT & QLGSRTIO as CPPs. Each
is used in conjunction with an additional command that loads the control
blocks. These allow me to receive "records" directly into CL variables or
write them to an output file. Seldom useful, but they work. They don't use up
a valuable DCLF and they can be used multiple times at different points in
the code.

So, there are workarounds. But I wouldn't recommend it unless it's somehow
absolutely required, such as when you can't guarantee a particular compiler
will be available. Come to think of it, you might even be able to use REXX,
but...

Tom Liotta

In article <01bdd643$ee8cce00$4e44...@merck.com>,

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

Orangtang

unread,
Sep 5, 1998, 3:00:00 AM9/5/98
to
No...you can only declare ONE file in a CL program.....

0 new messages