RE: Urgent!!! NULLS & ZEROS

["Stone, Brad V (TC)" <bvstone@xxxxxxxxxxxxxx>]

Try the ALWNULL keyword at the field level of the DDS.


Bradley V. Stone
BVS/Tools - www.bvstools.com
Netshare400 - www.netshare400.com



> -----Original Message-----
> From: Gade_R_Reddy@consecofinance.com
> [mailto:Gade_R_Reddy@consecofinance.com]
> Sent: Friday, December 17, 1999 11:03 AM
> To: RPG400-L@midrange.com
> Subject: Urgent!!! NULLS & ZEROS
> 
> 
> 
> Hello everybody.
> 
> Got a question about the field data types..
> I have Nulls in integer fields and in date fields on the Sql server
> table. Now i need to export this data to AS400 physical file, 
> but AS400
> unfortunately doesn't accept the NULLS in integer fields and Zeros in
> the date fields.
> 
> Any suggestions how do i go for it.
> 
> Thanks Guys.
> 
> Gade.
> 
> 
> 
> 
> +---
> | 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
+---