DSXchange

Hi, i have exported a job using istool command line and while importing to datastage via Datastage Designer -> Import, im getting below error. File << file path >> does not apprear to be a valid Datastage export file or is from an incompatible release. A valid Datastage export file is expected to be...

If I remove Abort flow(Email notification), exceptional handler is triggering when JA3 aborts.

But my requirement is to execute both Email notification and routine in exceptional handler if JA3 aborts.

Please suggest. Thanks.

If I remove Abort flow(Email notification), exceptional handler is triggering when JA3 aborts.

But my requirement is to execute both Email notification and routine in exceptional handler if JA3 aborts.

Please suggest. Thanks.

i used below command and getting error, please suggest. ./istool export -domain Poject_test -u user -p pwd -ar test.dsx -pre -ds '-base="server/Poject_test" jobs/*/*.tbd' ERROR: unable to connect to ISF server: Poject_test Reason: Domain Poject_test:9080 cannot be reached. This project doe...

Hi, I have design requirement to code a sequncer where in I need to execute a Routine if any Job in that sequencer aborts. below is the job design I have build: JA1 -> JA2 -> JA3(if abort) -> EmailNotification Exceptional Handler -> RoutineActivity -> TerminatorStage My intension is to run the Routi...

Hi, As part of version controlling we need to save table definitions of all our existing jobs. In our project there are around 500+ jobs, involving Oracle/ODBC stages as input/output stages. Need to save all these table definitions in metadata/Table Definition folder. Please let us know if there is ...

Any one of the date column(complete column for all records) is being populated as NULL, for each run in production.

I have executed the same job in Develpement with the same source table and all the date columns populated properly.

Hi, I have a parallel job that is reading data from SQL server table and loading into a oracle table. There are 7 to 8 date columns in both source and target tables. Transformer is just a plain one to one mapping. The problem is whenever I run this job in production environment, one or the other dat...

I checked in Director log the value is

Thanks

The NLS setting in SQL server stage and Oracle stage is same - Project default(ISO-8859-1) And i dont see any NLS option "ibm-1051" in any of the stages. If both the NLS settings are same why I am getting this warning? Any possible solution to avoid these warnings? (Sorry for the late post...

Hi All,

Is there is any way not to get this warning? I mean can we do some conversion on the columns having special characters? if yes, how can we do that?


Thanks
Sri

Hi ArndW,

How can we overcome this issue?
Removing the non-mappable characters of IBM-1051 character set from the source data, is the only solution? or can we deal this in datastage job?

Thanks,
Sri

Hi Gssr,

I Set $APT_DISABLE_COMBINATION to 'True' and re-run the job but still getting the same error


sri

Hi, We are getting below warning in the datastage parallel job Job is having one ODBC stage(gets data from SQL server) and a tranformer(does stringtodate of a job parameter) and a Oracle enterprise stage to truncate and load records into a oracle table. APT_CombinedOperatorController,0: Invalid char...

Hi, I have a datastage job(job has one source UDB stage and one target UDB stage)which is used to delete records from a table when a condtion matches.(delete from table1 where <condition>) When i run the job, i am getting FATAL error for the records in target table which doesnot match the delete con...