Re: Urgent!!

if it's a date filed then pass the value as
'1111-11-11' which is eqv. to null and if num filed
then pass 0 (zero) and for text pass ' '... it'\s not
requir to pass a null but when u retrive the value
u'll get a null for those fileds... 

hope it'll help u...


--- jagbir singh <j_singh@hotmail.com> wrote:
> Hi All,
> Hope someone can help on SQL. I am trying to insert
> a record with NULL in 
> the field and online SQL is not alloing me to do it.
> May be i am writing the 
> wrong statement. Pl help me out in this thing. Hope
> to hear from someone 
> soon..My SQL statement is as follows..
> 
> Insert into jtbtst/ps_tw_dtl_gl_tmp select
> process_instance, seq_nbr,
> business_unit,currency_cd, cur_exchng_rt, 
> tw_account_apar, tw_account_cr,
> tw_account_dr,account_d, tw_detail_dt, 
> tw_defacct_ptr, tw_def_timing, statistics_code,
> tw_act_amt, act_units, ' ', 
> ' ', ' ', ' ', tw_atlas_id, batch_num,' ',
> null,'2000-08-04', '',  from 
> jtbbprd/ps_tw_detail  where process_instance =
> '95045'
> 
> Pl reply soon.
> Thanks
>
________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com
> 
> +---
> | This is the JAVA/400 Mailing List!
> | To submit a new message, send your mail to
> JAVA400-L@midrange.com.
> | To subscribe to this list send email to
> JAVA400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> JAVA400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner:
> joe@zappie.net
> +---


=====
@mitava
-----------------------------------------------------------
Amitava Sutradhar
Other e-Mail: amitava_s@usa.net
------------------------------------------------------------

__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---