DSXchange

Hi, I am trying to update a field in DB2 table using ODBC stage. Below is the query. UPDATE schema.tablename SET Col1='09000000S00000010A' WHERE col2='41190711939172101102' AND Col3='090' Col1 is Varchar. Col2 and Col3 are Char. Field is not updated in the table and getting a warning as below (was a...

Oracle Stage.

I have used Upsert (User-defined Update & Insert) method for load.

Update query is like

Update <table> SET A=B+ORCHESTRATE.ABC

ABC is not a column in the Target table, so it is not used in Insert query.

I am getting below error and dsxchange suggests to set the insertArraySize to 1. Orchestrate update field 'ABC' is not an Orchestrate insert field. In order to use the default host array processing for insert, the Orchestrate fields for update must also be Orchestrate insert fields. This is not a re...

Hi,

Can we use the option APT_ORACLE_LOAD_DELIMITED in DataSatge version 71r2??

Regards,
Kannan

There are 2 tabs. First one is Command tab where i have mentioned shellscript name (abc.sh) and second one is Parameters tab where i have mentioned the parameters which needs to be passed to the script.

Regards,
Kannan

I have passed the environment variable as #$parameter# and user defined variable as #parameter#. But its not working.

Hi, DataStage version 7.1 In my sequencer job design i am using Execute Command Activity Stage to invoke a Shellcript. I need to pass the parameters in that stage. When i am trying to pass the Environment variables or user defined variables as parameter it is not getting passed to the Shellscript. I...

Hi, i am trying to create a copy of a parallel job but i am getting error message as Error writing record J\10728\V0S14P2 to file DS_JOBOBJECTS - error number is 40019 Error writing record J\10728\V0S34 to file DS_JOBOBJECTS - error number is 40019 Error writing record J\10728\V0S34P2 to file DS_JOB...

There are totally around 0.4million records and the size would be around 900MB.

Hi,

Is there any volume limitation for XML output stage to process the records?

Regards,
Kannan

Hi,

Is there any size limit to write into a Sequential File?

Regards,
Kannan

Hi,

Can we do a ftp of DataSet from one server to another server?

Regards,
Kannan

In DS v71r2, there is an option SetDsParamsFromFile under Job Properties->General->Before-job subroutine. This option is not available in latest versions.

If we migrate a job (Which uses SetDsParamsFromFile option) from 7.1 to 8x, Will it work?

Regards,
kannan

Hi, While going through IBM Information Server guide i have read the following information about Migrating Hashed Files. "If your DataStage project contains server jobs that use hashed files, then you need to move the hashed files to a new location as part of the migration procedure." Coul...

Hi,

If we upgarde Unix server (AIX) from 5.1 to 6.1, do we need to upgrade Message Broker also?

Regards,
Kannan