DSXchange

Thanks PaulVL for replying. What I have observed from the logs and designs of few jobs taking long startup time is like: Jobs which are having database connector stages at source or any other places (for lookups,funnel) with large USER-DEFINED complex sqls (large output schema with joins with other ...

Hi Job is taking long startup time in PRODUCTION. The job is running with 1 processing node. Design: The job has one oracle connector stage as source. With 2 other connector stages as used for lookups with one target connector stage. Also there are one sort stage and transformer stages has been used...

Hi I am using Oracle connector stage to insert records into target database table. I am using user defined insert statement only where I am trying to use "LOG ERRORS INTO" clause to insert rejected records in a different database table.But to do this I am getting errors as : ORA-38909: DML...

I have input data coming as : In_Field A ----------- 1a 2e 3f 7h 8t . . . n I need to map this input field value to 3 separate output fields. Ot_FieldA Ot_FieldB Ot_FieldC -------------------------------------- 1a 2e 3f 7h 8t .... ... .... .... I dont have any input field to group by the set (3 rows...

We have following users for different accounts in IIS. dasusr1,db2inst1,db2fenc1,xmeta,dsadm,iauser. Now we have all the users password expired as not being created with 'never expire' option. We are not able log in to the ds client. Even not able to restart the IIS. Please advice how to change the ...

We are running DB2 connector stage with Bulk load option. We are having following configuration : 4 cpu 4 Nodes in configuration file. All are non-db2 nodes as no node is specified for db2 only. When the job is running in log it is showing : running on non-db2 nodes. But only one process is being ge...

We are having problem with remove duplicate stage.We are getting different outpu set for different run of the same job.Our requirement is to sort the source data on 3 different fields(A,B,C).Then preserving the sort order we need to remove duplicate on field D. We tried it like: Design 1. Source -Co...

I have one db2 main query which needs to be run for day 0 to the day calculated by following db2 query(select (days(last_day(CURRENT_DATE)) - days(to_date('20120101','YYYYMMDD'))) from SYSIBM.SYSDUMMY1). day value is passed as a parameter to the main query. I have the one job to run the main query w...

database is DB2:

hex(field) is giving value 0000.
ascii(field) is giving value 0

Plz suggest.

I have one source field 'A' defined as nullable varchar(5).The target database field is defined as nullable char(2). Whenever null values are coming in source field some unknown character is getting inserted in target field.Target database is DB2. Running ascii(A) function against the field(A) in th...

Thanks Chulett for replying. I have schedule one job to run at particular time and another job to be run daily.In director I can see also that this jobs scheduled at mentioned time. But in linux server ,using 'crontab -l' or 'atq' command ,cant see any entries against that user.Also the jobs are not...

We are working on datastage v8.7 installed on linux server. We are trying to schedule jobs/sequences from datastage director.But the scheduled jobs or sequence are not getting triggered at all. We have check in the server we have access issuing crontab commands for that particular user.But in case o...

vamsi.4a6 wrote:Try with Quote-none

it will not work as without quote property.in that case all the records are getting rejected.
Also all the fields are defined as nullable here and '' is in the file to be treated as NULL.That we used mention as 'null field value' also.

May i know what is the data it is showing when i select view data in Datastage for sequential file stage for field value-"VENTILATION" PNEUMONITIS this record is getting rejected while being read from the sequential file stage itself.In view data we are not able to see this record.Let me ...

We are reading txt files using sequential stage with Quote property set as 'double'. But we are getting few rejections for data records like : 7724,"4957","""VENTILATION"" PNEUMONITIS",132,"Lung disease due to external agents",,"","Dia...