Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
change your load to
myTable:
load * inline[
C1,C2
1, Ali
2, Jean
3,
];
I tried this out but gave syntax error
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