SQL Query returns values like "---" and "NA"

[shaji_chandran]

Hi

When I execute a sql query in MII it returns values like "---" and "NA" for empty Char and numeric fields respectively.

I have checked the database and made sure that these fields does not have any value. This happens only when I run the query through MII. Can any one know how can we get rid of these values?

Thanks in advance

Shaji

[Former Member · Accepted solution]

Hi,

"---" and "NA" values are correspond Null values in database.

It gets "---" for integer typed field in database while Null valued.

Other types gets "NA" when Null valued.

Regards.

[Former Member]

Shaji,

MII sets those values as a default if it discovers null values in a query result. You can change this default behaviour in several ways.

First, have a look at the document [Setting custom null values in XML|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70628af0-8ec4-2c10-7da2-f451e412dd8f?quicklink=index&overridelayout=true]. Then you may also use SQL functions like [NVL|http://www.techonthenet.com/oracle/functions/nvl.php] to change the value directly in the SQL query. You can also change the value inside the MII BLT to whatever you need.

Michael

[shaji_chandran]

Hi Michel,

Thanks for your reply. I am able to manage those unexpected values in the transaction. What I was looking for how the query can stop returning this values. I think the xslt approach is fine. I will try out that.

Many Thanks

Shaji

[Former Member]

Hi Shaji,

this is standard MII behaviour that cannot be changed but only adapted like described. Give it a try.

Michael