DSXchange

I have a job which reads the data from sequential file and based on some conditions it passes it to two links(link 1 and link2). The data from link1 and link2 has to be upserted into a table. There will be no records for the key in the table initially, so whichever link gets executed first, it will ...

Hi I have a job which upserts the data into the table through odbc stage. Due to some issue with the link, there are some fatal error thrown in the log and all the records didnt get inserted properly. Ideally the job should have been aborted, but it shows the status as Finished. Is there any method ...

I am running a job in 4 node configuration which is inserting few records in a table through ODBC stage. The database connected through ODBC is progress. Here , even after the job completes(after inserting the records), the process is still running in the database. And when the next job runs, it aga...

Thanks

Hi, I am having a parallel job where i have hardcoded the value for $APT_CONFIG_FILE to use a single node config file. I am calling this job through a job sequence. The default config file for this project is set to 4 node config file. When i run the job sequence, will the individual job run with 1-...

Check this link

viewtopic.php?t=106875

The settings are not editable(disabled). I want to add one more thing here. When i create a new job and pulled the stage, the default setting is shown as sequential. But, i am not sure how it is showing as parallel for few of the jobs which had been created earlier. Even when it set as sequential, t...

Hi, We have a complex flat file stage to read a cobol file. The default setting to read the file is showing as Parallel mode. But i want datastage to read the file sequentially, as reading in parallel changes the order or the records from the actual file. We are doing some validations with header an...

Thanks for the information.

Hi,

i want to copy a dataset from my development server to system test server. Can anyone tell me what command to use.

Thanks.

This turned out to be an issue with the table that was created. We found out that We had not changed the field value in the table, and no issues with datastage.

We want to create a fixed length file as an output. We are extracting the data from a database and in the transformer stage, we are using the function Space(x) to generate the necessary spaces needed wherever the length of the input field is lesser than the necessary length. The job works fine, but ...

I have got the following in my director log. Couldnt infer what it means . Can anyone explain what it means and what would be the impact. APT_CombinedOperatorController(2),0: Numeric string expected for returned value from function call 'substring_1'. Use default value. Numeric string expected for r...

I tried to re-import the definition, but it still shows up the same old column length. If i manually change it , still i am not able to insert the data in that particular column as it still refers to the old one.

I tried to re-import the definition, but it still shows up the same old column length. If i manually change it , still i am not able to insert the data in that particular column as it still refers to the old one.