Article View: comp.sys.ibm.as400.misc
Article #143Re: Interesting Problem with Dates
From: Jim Barnes
Date: Mon, 12 Feb 2001 21:02
Date: Mon, 12 Feb 2001 21:02
38 lines
2651 bytes
2651 bytes
1940/01/01 is the default for a *YMD format not an *ISO format. When I use an *ISO format a null value produces 0001-01-01. "ricko" <ricko@softlad.co.uk> wrote in message news:3a87c97a$1@d2o313.teliauk.com... > Hi > > I am trying to populate a Sequel Database with Data from an AS400 File > (ODBC). The AS400 file > contains several DATE Fields that have the field date property assigned. > (L). > > I do not always need the dates to contain a date i.e. I need them to be > Null. However, When I run > my RPG Program to populate the AS400 file, the Date fields default to > 1940/01/01 (*ISO Default). > > This is causing a problem because the Application that uses the Sequel > database displays these dates > to the users and I need them to be Blank. > > The ALWNULL and DFT Keywords do nothing to help. I have changed the DDS to > be a 6 char numeric > field but then Sequel detects that its not a date field and rejects my file > transfer. > > I am trying to automate the entire process without and 'manual' > intervention. > > Is there a solution?? > > Thanks in Advance! > > Paul Cullen > > > >
Technical Details
Message-ID:
<D22D5FC4E8D16BB2.1D2831B957245801.F0A42A9CA45A8C55@lp.airnews.net>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!news-feed.riddles.org.uk!newsfeed.direct.ca!look.ca!newsfeed.cwix.com!newsfeed.nyc.globix.net!news.stealth.net!24.30.200.2.MISMATCH!news-east.rr.com!cyclone-west.rr.com!news.rr.com!news-west.rr.com!cabal10.airnews.net!news.airnews.net!cabal14.airnews.net!news.airnews.net!cabal1.airnews.net!news-f.iadfw.net!usenetReferences:
<3a87c97a$1@d2o313.teliauk.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10e4c1,ba345bdd3e2c6d4 X-Google-Attributes: gid10e4c1,public X-Google-Thread: 104581,ba345bdd3e2c6d4 X-Google-Attributes: gid104581,public X-Google-Thread: 1077ec,ba345bdd3e2c6d4 X-Google-Attributes: gid1077ec,public X-Google-ArrivalTime: 2001-02-12 13:04:08 PST Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!news-feed.riddles.org.uk!newsfeed.direct.ca!look.ca!newsfeed.cwix.com!newsfeed.nyc.globix.net!news.stealth.net!24.30.200.2.MISMATCH!news-east.rr.com!cyclone-west.rr.com!news.rr.com!news-west.rr.com!cabal10.airnews.net!news.airnews.net!cabal14.airnews.net!news.airnews.net!cabal1.airnews.net!news-f.iadfw.net!usenet From: "Jim Barnes" <j.barnes@pentasafe.com> Newsgroups: comp.sys.ibm.as400.misc,es.comp.os.as400,it.comp.as400 Subject: Re: Interesting Problem with Dates Date: Mon, 12 Feb 2001 15:02:12 -0600 Organization: Airnews.net! at Internet America Lines: 40 Message-ID: <D22D5FC4E8D16BB2.1D2831B957245801.F0A42A9CA45A8C55@lp.airnews.net> X-Orig-Message-ID: <969iqg$prm@library1.airnews.net> References: <3a87c97a$1@d2o313.teliauk.com> Abuse-Reports-To: abuse at airmail.net to report improper postings NNTP-Proxy-Relay: library1-aux.airnews.net NNTP-Posting-Time: Mon Feb 12 14:58:56 2001 NNTP-Posting-Host: !bZ[%1k-VT^/@';-UB".2_&D> (Encoded at Airnews!) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700