null values / AS400

[Latimer, Richard]

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
**********************************************************************