null values / AS400

[george.j.wen@us.abb.com]

--0__=IuXEKfYEHhTJvYJpb6nuYRZ6e8i77rjTIsFecbT4x9hrszxLgRy8WKxC
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline



This was part of a specifications for an interface for another system.
We've found another way
to deal with the issue.  Curiously though the Matchpattern function can
test for Null but we can't
create a null field value.  Like you say Richard - it must have been a
bit left out/forgot and missing
bits are hard to find, eh?
  Thanks again to all for responding.  Life is easier for having this
List to go to.

George


|------------->
|(Embedded    |
|image moved  |
|to file:     |
|pic19758.pcx)|
|             |
|------------->
  >--------------------------------------------------------------------|
  |"Latimer, Richard" <richard.latimer@airways.co.nz>                  |
  |08/07/2002 06:29 PM                                                 |
  >--------------------------------------------------------------------|



To:   George J. Wen/NB/USFAC/ABB@ABB_US01, powerh-l@lists.swau.edu
cc:
Subject:  RE: null values / AS400

Security Level:?         Internal



George,

I think David is correct - DB2/400 allows null values but they have to
be
specifically included in the file specification when it is created. My
reading of the 6.07 PDL manual is the PH doesn't appear to allow
creation of
null fields (maybe Cognos left that bit out !)

Maybe you need a "psuedo - null"  eg we have a lot of time fields in our
system and represent an unknown time with 99:99:99 since 0 (00:00:00)
can be
a genuine value.

regards
Richard



-----Original Message-----
From: george.j.wen@us.abb.com [mailto:george.j.wen@us.abb.com]
Sent: Thursday, 8 August 2002 6:27 a.m.
To: powerh-l@lists.swau.edu
Subject: null values / AS400




No politics today just work (darn!).

I'm trying to load null values into a field.  I thought I remembered
doing it once on an HP
to the tune of [ DEF fieldname CHAR*nn = "" ].  The double quotes with
nothing in between
would do the trick.  I tried it on the 400 but when I test with
Matchpattern I looks as if I'm not
there.  Don't see it in the Quiz manual - can anyone help.

Thanks,
George



= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.


**********************************************************************
This electronic message together with any attachments is confidential.
If
you receive it in error: (i) you must not use, disclose, copy or retain
it; (ii) please contact the sender immediately by reply email and then
delete the emails. Views expressed in this email may not be those of the
Airways Corporation of New Zealand Limited
**********************************************************************


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.




--0__=IuXEKfYEHhTJvYJpb6nuYRZ6e8i77rjTIsFecbT4x9hrszxLgRy8WKxC
Content-type: application/octet-stream; 
	name="pic19758.pcx"
Content-Disposition: attachment; filename="pic19758.pcx"
Content-transfer-encoding: base64

CgUBCAAAAABBADEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAABQgABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAA=

--0__=IuXEKfYEHhTJvYJpb6nuYRZ6e8i77rjTIsFecbT4x9hrszxLgRy8WKxC--