DSXchange

Jackson, When I used to teach Datastage for IBM, I used to teach that modify stage is much less expensive than the transformer stage, hence when performance is critical, it is better to use modify stage. Then, during one of the debugging sessions with IBM tech support for a client, the support guy s...

I am not sure that you can change the default value. One option is that you could make the column coming from the reference link as nullable. In a subsequent transformer stage you can build some logic to replace the nulls with the default value of your choice. Alternatively, you can send the lookup ...

Thanks. Its working now.

I have set $APT_NO_JOBMON to False

The job is getting finished and it processing the rows also.

In the director when I right click on the job and select the "Monitor" , it is not showing the number of rows processed in the link and the status of the link is showing "ready". Though the job is perfectly fetching from the source and loading it successfully. In the designer als...

uvodbc.config was not set for the project. I created the entries for each DSN and now its working.

I am not able to import any ODBC table definition. However my jobs are running fine connecting to ODBC datasources.

Whenever I am trying to import ODBC table definitions I am getting the error

"Empty DSN: list returned from host 60.192.1.64"

In the job which was creating the file. The rowcount was in quotes. Modified the job to remove the quotes and it is working fine now. thanks.

I have a sequence which runs a job to create a file showing number of rows of a table. Then I am using an Execute command stage to read the file. Then I am using user activity variable stage to read Execute_Command.$CommandOutput in a USER VARIABLE (ROWCNT) In the User Variable stage I have used the...

I am using a DRS stage to update a table(Before SQL in the source DRS stage) in Netezza connection through ODBC. In the before SQL tab(Source DRS stage) I have an update statement which updates all the rows of a table (number of rows around 10000). Sometimes I get the error "could not serialize...

I have a job which reads from Teradata and update a Netezza table using ODBC enterprise stage. Mapping is one to one. For the decimal fields the update is not happening correctly. For example if the value in the source is 80.45 it is getting updated to Netezza as 80.00. Losing the data to the right ...

Yes it was because of @FM

It working fine now. Thank You.

I have a sequence which runs 3 jobs(A,b,c) in sequential order A --> B ---> C. A,B run everyday. C need to be run on every thursday. I have a routine which returns the day of a week. I have used UserVariables Activity Stage and called the routine to store the dayof the week in a variable(VAR1). I ha...

Create this ENV variable and set its value to 1 APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL Hi All, Iam having problems bringing in a DateTime field coming from Oracle which as some NULL values and trying to load into Teradata DATE field (which allows NULL's). what is the best way to load a NULL value i...