DSXchange

Database connections only need to be defined in .odbc.ini if the access method you are using is ODBC (through ODBC Enterprise or Dynamic RDBMS stage with "ODBC" set as the DBMS type). In this case the DSN also needs to exist as an entry in the uvodbc.config file for the project. However, keep in min...

It is an artifact of the decimal number being displayed. Would they object if, instead of the space, there was a "+" sign? The only way to eliminate the displayed decimal sign space is to change the data type to string (VarChar or Char) and then to use Trim() or Convert() to get rid of it. When you ...

This is the purpose of Usage Analysis. Select the table definition in question (using Manager client), then select Usage Analysis from the toolbar on the menu. Usage Analyis produces a list of the jobs that use that table definition, including the columns that are used in each job. You do need, howe...

Read what Arnd already told you. If the data type is decimal there IS NO SPACE in the data - only when it is displayed is there a space for the (positive) sign character. If the data type is string then you can do with it whatever you wish.

This refers to the case where the output column is designated as Not Null, or where the output column derivation expression includes a function that does not tolerate null arguments (which is the case for most of the functions).

Try View > Refresh in Director.

Your script needs to check the individual exit status of each job instance and store that somewhere, so that it can select which jobs are checkpointed as having finished successfully. The script needs to read and remove that checkpoint file each time it starts. Or you could do the same in a job sequ...

Has a flag been set in DB2 or in DataStage to demote warning message severities to informational?

You could, as a workaround, post-process the log using an after-job subroutine to search out particular SQLSTATE or DBMSCODE values. Setting ErrorCode to a non-zero value will abort the job.

Type 12 in DataStage is VarChar. Looks like you need an IsValid() test somewhere in your mix.

The easiest way is to use Oracle Enterprise stage with write mode set to Write (or Load, depending on your version). If you want to keep the sqlldr invocation separate from DataStage ETL processing, simply specify the full pathname of the sqlldr command (and make sure your Oracle environment variabl...

I believe that U is currently working in Singapore on a server-only project (not using mainframe jobs). Therefore is unlikely to be able to help.

Nor can I, not having used this combination (yet, anyway).

It's not fixed width, so you can't use that. Fixed width implies that every record has the same structure and, therefore, length.

Please advise what "some values" are being inserted by FTP, and which FTP mode (ASCII or binary) you are using.

You are on the right track, but may have selected the wrong field number in your Field function. I prefer to convert all the line terminators (@FM) to empty strings and trim extraneous space from the result.

Excel worksheet names are presented as "system table" names, preceded by "$". Therefore, when you ask your ODBC stage to create the table, you need to give a table name preceded by "$".