DSXchange

I Have one Job sequence with status as Aborted/Restartable.The Job sequence S1 is aborted due to one of the parallel Job J1 and its status is aborted. I have two questions on Job J1. 1)Suppose If do any changes to the Job J1.I will compile the Job J1 then If I restart the Job sequence S1 then it wil...

chulett wrote:I could guess but would rather not... clarify for us exactly what target stage you are using.

I am using DB2 connector

I am using DB2 as Target.volume of data is large.Target is Append mode. I need to commit when all records are successfully read from the source. The problem I am facing is let us assume 10 Lakh records are there in source and 9 Lakh records are successfully are written into target.If there is a prob...

I have condition1,condition2,condition3.I need to trigger job1 depends upon condition1.similarly condition2 for Job2,condition3 for Job3.When all the conditions1 to conditions3 are not satisfied I need to trigger Job4. How to develop this job in job sequence? I used Nested activity but not sure what...

I do not want to so any create,truncate,replace etc.Just i want to delete the data based on above sql.I have gone through
manual.significance of table action is not clear.can anobody provide input on this

table actions:-
options:-create=only create
append=
truncate=only truncate
replace=drop+create

currently i am using below sql statement in oracle connector with writemode:-delete table action is having following options:-create,append,truncate,replace. what is the purpose of this table action option? It is not clear to me and anybody give input on this a)DELETE from table1 where CLAIMNUMBER =...

Currently all the values in source are in the range of length 19 and scale 6. Let us say I have value like 99999.....9 [Fill length 255] in source. Question 1 : In that case will DataStage will throw warning? Question 2 : Currently I do not have that scenario (99999.....9 [Fill length 255]). Due to ...

The source column for transformer is CLAIMAMOUNT(NVARCHAR(255)). I am converting to StringToDecimal(CLAIMAMOUNT) of length 19 and scale 6.It is not throwing any error.I excepted warning in log since 255 will not fit into length 19 and scale 6.Could anybody provide input on this why it is not throwin...

In job sequences How to get yesterday date in job sequence.For todays date we can use DSJobStartDate and in parallel jobs we can use dateoffsetbycomponents not sure about job sequences.

Use your database and write the output to a file.

select trunc(sysdate,'MONTH')-1 as lastdayofpreviousmonth,trunc(trunc(sysdate,'MONTH')-1,'MONTH') as firstdayofpreviousmonth from dual

Thanks for reply i know we can use row generator stage but I do not know sample data as per cobol book

I have sample cobalbook as below but i do not have any sample data but i need to proceed with development.Could anybody provide two sample records since i am new to cobol and CFF stage. ******************************** * COBOL DECLARATION FOR ORDERS * ******************************** 01 HEADER. 05 O...

I am using below schema file and source file.one to one mapping between source and target. Job was aborted with below error: The connector could not create table SAMP_EMP because the data type information for the column No could not be obtained. samp_emp.txt 1,a 2,b 3,c temp.osh record ( No:string[]...

I am able to form the logic for parameters successfully when we have parameters. Let us say i do not have any parameters for Job what i need to do to make it run for below command.I mean $paramlist is empty ${DS_HOME}/dsjob -domain ${DS_DOMAIN} -user ${DSRUN_USR} -password ${DS_RUN_USER_PW} -server ...

I am developing generic UNIX script to call DataStage Job and stuck with how to form the logic for $paramlist because one job is having one parameter, another job has 3 job parameters and 3 parameter sets and it is not fixed. Currently I am passing one parameter for script (i.e job name) ${DS_HOME}/...