How to handle SAP nulls in a specific job server - Interpret_R3_Null_as_Null

[mageshwaran_subramanian]

I have multiple job servers in our DS environment (on the same server) and would like to set Interpret_R3_Null_as_Null = TRUE for one of those job servers. Is that possible?. If yes, how this can be implemented.

I referred to note 1182229 - NULL values converted to spaces in a SAP R/3 Data Flow - SAP ONE Support Launchpad and it seems like it is possible but I'm not sure how.

Let me know your thoughts.

[rajiv_deshpande]

Hello Mangesh

In the Designer go to Tools -> Options, under SAP -> Environment you will have the option.

Thank you

Rajiv

[mageshwaran_subramanian]

Hi Rajiv, When you set that from the Designer, it is applicable for all the job servers. As I mentioned in my question, I want to apply the NULL setting only to a specific Job server.

[rajiv_deshpande]

As mentioned in point # 2 & 3. Go to the server where the Job Server is defined search for the file DSConfig.txt and edit it with the given value.

1. In Designer, select Tools > Options > SAP > Environment > Convert SAP null to null.
2. Alternatively, modify the following line in the file DSConfig.txt:
   • Interpret_R3_Null_as_Null=TRUE
3. If there's 2 Job Server environment and would like to implement the changes on one Job Server level and not Designer, then modify the DSConfig.txt in %DS_COMMON_DIR%/conf for that Job Server. Then use that Job Server to be able to handle the conversation.

[mageshwaran_subramanian]

Is there job server specific setting available for Interpret_R3_Null_as_Null on DSConfig.txt?

[rajiv_deshpande]

Not job specific, but server specific.