MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

RE: make cust file look like a journal record - format



fixed

The JOESD field is as long as you like (within some limit, I'm sure). Look
at the ENTDTALEN parameter of DSPJRN.

I absolutely don't understand, " I need the format, but don't want to DSPJRN
to get the format." But I don't suppose I need to. :)

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"Some people can stay longer in an hour than others can in a week."
-- William Dean Howells



Yes that is true - but I would like to use the IBM format. The
QSYS/QADSPJRN field JOESD is only 100 bytes long.

I need the format, but don't want to DSPJRN to get the format.

I need this to work in production and I cant ensure that DSPJRN will
build a single *outfile record.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of AJordan@xxxxxxxxxxxxxx
Sent: Wednesday, October 03, 2012 5:36 PM
To: Midrange Systems Technical Discussion
Cc: midrange-l-bounces@xxxxxxxxxxxx
Subject: RE: make cust file look like a journal record - format

Joel

The ENTDTALEN parameter on DSPJRN specifies how big you want JOESD to
be.

It's all there in the online help behind the command :)


Kind Regards
Alan Jordan

RODIN by Coglin Mill | 507.282.4151 x 103 | 507.261.4495 Mobile |
Rochester, Minnesota USA | www.thinkrodin.com




From: "Stone, Joel" <Joel.Stone@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>,
Date: 10/03/2012 05:31 PM
Subject: RE: make cust file look like a journal record - format
Sent by: midrange-l-bounces@xxxxxxxxxxxx



I am trying to do this. Where can I get a file format of the DSPJRN
*OUTFILE format?

I tried QSYS/QADSPJRN but that has a field JOESD of only 100 bytes long.

Is there a file to join to with a longer JOESD field?

Or do I have to create my own.

Thanks





-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Ken Sims
Sent: Tuesday, October 02, 2012 9:52 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: make cust file look like a journal record - format

Hi Joel -

On Tue, 2 Oct 2012 20:40:03 +0000, "Stone, Joel"
<Joel.Stone@xxxxxxxxxx> wrote:

Do you know how to have SQL move the entire record format (all columns:
packed, zoned, alpha) into a single field JOESD? (which is where the
journal system stores my CUST record)

How about creating a file with just one field that is as long as the
longest record format that you want to process, then use CPYF with
FMTOPT(*NOCHK) to load it. Then I think you could use SQL against
that file to load your DSPJRN look-alike. No actual journal
processing required.

Ken







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact