Knowledge Base for Datastage - 图文

Knowledge Base of DataStage Usage 1. Generallly, for the new parallel job, the attribute as “Enable Runtime Column Propagation

for new links” should be un-checked. Otherwise, there will be data-type compatibility issue in the director log after the running.

2. We can use below wizard to connect to the related database and import the table

definitions firstly. Then in the source/target, we can just import the columns base on the available table definitions.

1

3. Generally, in the table definition, for the “extended” attribute of the columns, they should

be set to empty and should not be chosen to “Unicode”. Especially for DB2 DB, if they are chose to “Unicode”, there will be WCHAR to CHAR warning message.

4. In the creation of sequence job, you can use the setting of triggers to control the

dependencies conditions of different parallel jobs.

2

5. You can directly input some command in the “Execute Command Activity” as below:

echo -e `find #$SCRIPT_PATH##GSATOOL_OUTPUT_FILE_DIR# -type f -name \l`

3

6. In the trigger condition of above command activity, you need to remove the enter space to

compare the return value as below:

TRIM(EREPLACE(EREPLACE(EREPLACE(EXEC_CHECK_CREATED_FILE.$CommandOutput,@FM,\CHAR(010),\

7. For the special character such as “’”, if the SQL is generated through some shell command

and finally take it as the input of parameter in Netezza connector, there should be 转义符号as \\\\ before it.

? In the DB record, the where condition is as below:

? With above the record in the ASCA DB Table, the generated SQL by the shell

command is as below:

4

5

本文来源：https://www.bwwdw.com/article/5cpf.html