Re: Urgent!!! NULLS & ZEROS

I am starting to do this way.

1.) Get the data from Sql Server to AS400 table ( since AS400 table accepts
NULLS)
2.) Write a small RPGLE program where i would have SQL statements to
convert NULLS to Zeros & NULLS to 0001-01-01
3.) Then copy the table data to a physical file.

Please advice what do you guys think about the above process.

Thanks.
Gade.





"oludare" <oludare@ix.netcom.com>@midrange.com on 12/17/99 01:37:04 PM

Please respond to RPG400-L@midrange.com

Sent by:  owner-rpg400-l@midrange.com


To:   <RPG400-L@midrange.com>
cc:
Subject:  Re: Urgent!!! NULLS & ZEROS


Yes, you can store 99999999 as a date CCYYMMDD not - or /.

Dare.

----- Original Message -----
From: "Jim Langston" <jlangston@conexfreight.com>
To: <RPG400-L@midrange.com>
Sent: Friday, December 17, 1999 2:02 PM
Subject: Re: Urgent!!! NULLS & ZEROS


> Can you store 99999999 as a date on the AS/400?
> That is not a valid date 9999-99-99 so I think you
> would get decimal data errors or something like
> that, wouldn't you?
>
> I could see using *HIVAL (whatever that is,
> 9999-12-31 maybe) but not 99999999.
>
> Regards,
>
> Jim Langston
>
> oludare wrote:
>
> > We use 99999999.
> >
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---



+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---