inline table with null valued column

[ali_hijazi]

Hello

I need to create a table using inline load

for example

myTable:

load * inline[

C1,C2

1, Ali

2, Jean

3, NULL

];

for the third row I want C2 to be null the above is considered as the string NULL

[lironbaram]

change your load to

myTable:

load * inline[

C1,C2

1, Ali

2, Jean

3,

];

[ali_hijazi]

I tried this out but gave syntax error

[its_anandrjs]

Hi,

Use isnull( ) function and do not put any thing in the row.

myTable:

load * inline[

C1,C2

1, Ali

2, Jean

3,

];

It will automatically treated as null value.

Rgds

Anand

[lironbaram]

ok

try this one

SET NULLINTERPRET =<sym>;
myTable:

LOAD * INLINE [
C1, C2
1, Ali
2, Jean
3,<sym>
];