Designer: Display environment one is connected to

Is there an easy way to display and preferably permanently display the environment one is in? To me this is a security feature. I am thinking along colouring like many DB tools allow.

Nope, there is none. I double checked with SAP support. The data store pane displays the repository one is connected to. If you need to know the server you can look in the environment section of Designer in the options. Or start the switch object library dialogue.

Designer: Overview on checked out objects

Like the status command of subversion but graphically? There is none. I double checked with SAP support.

Designer: User defined transformation optiones pane empty

Looks like

Reason is unknown but the workaround (proposed in KBA 2520817) is to run Designer as administrator. I had been talking to SAP support hinting me to the workaround and KBA. They also sayd I should expect problems now and then when running Designer under an unprivileged user.

[Update]
After having run Designer as administrator the option pane is now filled even though I do not run Designer as admin...
Is the need to run Designer as administrator in order to initialise some things? World of wonder...

Push down: Why is there no full push down done?

Following has to be met by the data flow to be able to push down completely.

• Join sources of the same data store (or with database link between them)
• Load operation must not contain triggers
• Only query transforms used, no other transforms
• No use of un-pushable functions and operators in expressions, see SAP Note 2212730:
• ...
• But at least to_date is UN-pushable when thrown against timestamp database column, see Data services: to_date inhibits push down
• No use of un-pushable transforms , see SAP Note 2212730:
• ...

Stored procedure: Why can't I import overloaded stored procedures?

Overloading just not supported.

Stored procedure: How can I call a stored procedure with boolean parameter?

You cannot!!!
@#!"*#!!, you need to create one or more wrapping stored procedures handling the boolean parameter.

Custom functions: Why can't I create recursive function calls?

This is only possible when directly calling the calling function, i. e. the function calls itself. Indirect calls, i. e. over intermediary functions, are inhibited.

On NULLs and empty strings

• NULL on any side of = and <> makes the result FALSE. In comparisons this has to be taken into account, e. g. with IS NULL checks or NVL function calls.
• Emtpy strings and NULLs are not the same. In comparisons this has to be taken into account, e. g. with IS NULL checks or NVL function calls.

Trailing blanks in varchars

In comparisons, transforms and functions trailing blanks are ignored!

Target: How can I prevent duplicate rows?

You can try the "Auto correct load" option.

Table: Why do I not see template tables on the database?

The will be created only when the data flow has run successfully once.

Table: How can I use template tables in expressions, functions or transform options?

You have to convert them to normal tables be importing them.

Target: Can I commit several targets within a single transaction.

Select the target's "Include in transaction" option. This only works for targets of the same datastore. You control the load order with the "Transaction order" option. Tables with the same order are loaded simultanously.

Work flow: Call depth

It is infinite.

Work flow: Is recursive call possible?

Yes

I want to use multiple e-mail addresses

Make a comma separated list like

thiemo.kellner@gmx.ch,thiemo@gmx.ch

Scipt: I want to use a variable substitution within single quoted string

You have to put the variable within curliy brackets:

$StartDate = sql(’demo_target’, ’SELECT ExtractHigh FROM Job_Execution_Status WHERE JobName = {$JobName}’);

Script: Expression substitution

Like bashs and other shells command substitution, the scripting language supports expression substitution where the value of the expression in square brackets replaces the square bracketed expression:

Print(’The value of the start date is:[sysdate()+5]’);

Format of error file of file format

source file path and name;row number in source file;Data Services error;column number where the error occurred;all columns from the invalid row

How can I rename a file format?

You cannot!!!
#@!*#@!!!, you need to recreate it. Replication accessed by the context menu should help.

How can I rename objects in the central repository?

You cannot!!!
@#!"*#!!, you need to delete the object and recreate it with another name. I'd try to

1. make a copy with the new name
2. delete the old usages
3. insert the new object usages where the olds where

No data is displayed in the data preview of fixed width file format

Probably the format is defined in a multibyte code page.