DSXchange

Hi Arun, In sequential file stage there is a property "Missing File Mode".You have to set this property value to "ERROR". After setting this property,if a specified file does not exist,the job will abort. To rename a file,you may try following: a) In Execute command activity of a...

The Nullability of source and reference keys should be same. Also,the key columns on which the lookup is performed must be NOT NULL. Do this : In the source query,use NVL(Department_ID,-1) Set the nullability to Not Null in source itself. =>The source and refernece link columns should be NOT NULL. A...

You are getting the warning because you are trying to pass NULL to a NOT NULL column.Check these scenarios : 1st scenario : check the mapping in "LookupEmpDep".Compare the nullability of "DEPARTMENT_ID" with the column to which it is mapped.It seems that the target column in &quo...

I am just passing 3 record only , I can view the records in the input dataset as ORD_IND is all 6 In the error message, i am getting only this constraint as Violated!! :roll: put a peek stage after transformer and see what is actually going to target.The column value will be visible in the job log....

Hi Sreeni,
This is a bug in datastage version 8.1.

See the link below :
http://www-01.ibm.com/support/docview.w ... wg1JR32301

You will have to apply patch JR32301v2.
This change is included in 8.1 Fix Pack 1.

Also,chulett is correct.You will have to handle the Oracle errors as well otherwise you might get NULL values in the output. Use the count function and always check if your output contains word like "ORA" and "Error" cnt=count(Output,"ORA") cnt1=count(Output,"ERROR...

Try this : write your query in a sql file and execute as below.it will be easier: *Write query to a temporary sql file. cmd= "echo select * from dual > query.sql" Call DSExecute("UNIX",cmd,Output,Retval) *execute the sql file cmd="sqlplus -s DSGPS_BATCH/gpsd1@GPSD<query.sql&...

If you are using server job then the server routine i mentioned above can be directly called in the server job itself.There is no need of user variable activity/job activity and any sequence.

In the server routine,do following : cmd= "sqlplus -s userid/passwd@server Your query" Call DSExecute("UNIX",cmd,Output,Returnval) *the variable "Output" contains the output of the query. Call DSLogInfo("The output from query is ":Output,"Output") *T...

what is the length of the data type for the column in sequential file stage?set the length to 4000.

Also,keep on adding columns 1 by 1.In this way you will be able to determine,which column is causing problem.

A simple solution is to add constraint in transformer stage on the incoming data to verify if it is satisfying the check constraint which is defined in the table.If it is satisfying the constraint,then only pass data to target OCI stage. For example : Suppose there is a table "Emp".It cont...

1 )You need to migrate your all <b>user defined Environment variables as well</b>.These variables are present in <b>dsparam</b> file of datastage home directory(can be seen in datastage administrator).Your jobs will not compile in the new environment if these variables are not setup there. 2) Creati...

Hi, Put a sort stage after the source stage.In the sort stage,there is a property "Create cluster key change column".There,add your group of columns. Here,the "change_key" value for you data will be : 1,0,1,1 (1 is for new and 0 if the data is repeated.) aaa|bbb|ccc|1 aaa|bbb|ccc...

Hi The delete fails because the key column value from source is not found in the target.So,we have to make sure that only those values of source are passed to the target which exist in the target also. Try following 2 solutions : <b>Solution 1 : </b> if the source and target tables are in same datab...

If these special characters do not contain any useful data,you can trim/convert them. Try using convert("é","",inputlinkname.columnname) Second option : use left and ALNUM function. Step 1: Use function Alnum(inputlinkname.columnname).This function returns 1 if the value conta...