Interesting Problem with Dates

Article View: comp.sys.ibm.as400.misc

Article #141

Back to comp.sys.ibm.as400.misc Previous Next

#141

From: ricko
Date: Mon, 12 Feb 2001 11:28

29 lines
2056 bytes

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: <3a87c97a$1@d2o313.teliauk.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!212.37.1.10!newsfeed01.se.dataphone.net!nntp.se.dataphone.net!news.powertech.no!nntp.newmedia.no!newsfeed1.enitel.no!masternews.telia.net!news-sto.telia.net!d2o313.teliauk.com!t1o317p16.teliauk.com

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10e4c1,ba345bdd3e2c6d4,start
X-Google-Attributes: gid10e4c1,public
X-Google-Thread: 1077ec,ba345bdd3e2c6d4,start
X-Google-Attributes: gid1077ec,public
X-Google-Thread: 104581,ba345bdd3e2c6d4,start
X-Google-Attributes: gid104581,public
X-Google-ArrivalTime: 2001-02-12 03:34:37 PST
From: "ricko" <ricko@softlad.co.uk>
Newsgroups: comp.sys.ibm.as400.misc,es.comp.os.as400,it.comp.as400
Subject: Interesting Problem with Dates
Date: Mon, 12 Feb 2001 11:28:38 -0000
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
NNTP-Posting-Host: t1o317p16.teliauk.com
X-Original-NNTP-Posting-Host: t1o317p16.teliauk.com
Message-ID: <3a87c97a$1@d2o313.teliauk.com>
X-Trace: 12 Feb 2001 11:31:06 BST, t1o317p16.teliauk.com
X-Complaints-To: abuse@teliauk.com
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!212.37.1.10!newsfeed01.se.dataphone.net!nntp.se.dataphone.net!news.powertech.no!nntp.newmedia.no!newsfeed1.enitel.no!masternews.telia.net!news-sto.telia.net!d2o313.teliauk.com!t1o317p16.teliauk.com