Re: INSERT INTO values(NULL) with RUNSQLSTM

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Buck,

Works fine for me at v5r4
CREATE TABLE QTEMP/BUCK (EMP INT NOT NULL WITH DEFAULT, TERM_DATE
DATE )
Table BUCK created in QTEMP.
insert into qtemp/buck (emp, term_date) values(12345,NULL)
1 rows inserted in BUCK in QTEMP.

What's the error?

If you not on at least v5r4, it may be that the system isn't auto
casting NULL try
INSERT INTO PAYROLL (EMP, TERM_DATE) VALUES (12345, cast(NULL as date)).

Otherwise if NULL is the default just leave out the column
INSERT INTO PAYROLL (EMP) VALUES (12345).


HTH,
Charles

On Mon, Apr 12, 2010 at 2:57 PM, Buck <kc2hiz@xxxxxxxxx> wrote:
> I'm writing a script to make some test data and I'm using RUNSQLSTM to
> process it.  I'm at the point where I want to insert some columns that
> are NULL.  As in INSERT INTO PAYROLL (EMP, TERM_DATE) VALUES (12345, NULL).
>
> I think the only way to do this is indirectly, with NULLIF or
> CASE...END.  Like VALUES(12345,NULLIF(0,0))  There's no way to specify
> the pseudo-literal NULL is there?
>
> NULLIF works but it just seems...inelegant.
>  --buck
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.