× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Why do I see all fields in the file in the journal receiver when I do the
following? Shouldn't I only see the changed field?

CRTJRNRCV JRNRCV(DELETEME/QSQJRN0001)

CRTJRN JRN(DELETEME/QSQJRN)
JRNRCV(DELETEME/QSQJRN0001)
RCVSIZOPT(*MINFIXLEN *RMVINTENT)
MINENTDTA(*FILE)

CREATE TABLE DELETEME/DROPFILE (ORDERNO INT NOT NULL WITH DEFAULT
as identity,
ITEMNBR CHAR ( 5) NOT NULL WITH DEFAULT, ITEMDESC CHAR ( 10) NOT
NULL WITH DEFAULT, QUANTITY DEC ( 9, 2) NOT NULL WITH DEFAULT,
PRIMARY KEY (ORDERNO))

insert into DELETEME/dropfile (itemnbr,itemdesc,quantity)
values('A','BROGHER',5.2)

update deleteme/dropfile set itemdesc='BROTHER' where orderno=1

I thought I should only see the contents of itemdesc, and maybe even just
the contents of the G changing to a T.


Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.