DSXchange

Please mark this post as RESOLVED.

Clearing the partition in the copy/dataset stage should solve this problem.

Hi,
As you are using the partition type as entire this problem is encountered, changing the partitioning type can help. I would suggest to go for hash partitioning on the key column combination.

The error basically is saying that the DB2 stage has an extra column session_key, but the source dataset doesn't have it, so if you remove the extra columns in the DB2 stage and keep only the columns present in Dataset.

Changing the datatype from CHAR to VARCHAR is a good option as the output is a Sequential file.

Hi,

You can open the sequential file stage, select the nullable column select the option edit row and then assign a default value which needs to be written if it encounters any NULLS in the actual data.

Hi Gopi,

If script is causing a problem, then try with the Aggregator stage for getting the row count and funnel all the results into a single Otuput file/dataset.

You can use a similar formula like, sequnum=(empno*2) - 1

If there are any columns read as Char try changing them to Varchar and check the result.

@Anbu: I've tried this dsjob set -vx -run -jobstatus -param ${ParameterFile} -param ${TableName} -param ${ColumnNames} -param "${Filter}" ${ProjName} ${JobName} But i'm getting the same error. @Vinoth: Yes, I've run a similar job having 1 parameter less. @Craig: Actually I've run a similar...

Hi All, I have a generic Sequence job to extract data which has 5 parameters: 1)Parameter File 2)Table Name 3)ColumnNames 4)Filter 5)Type I'm trying to run this through dsjob -run command in Unix, dsjob -run -jobstatus -param ${ParameterFile} -param ${TableName} -param ${ColumnNames} -param ${Filter...

Can you please give more details like, how many columns are used as keys etc. An example with the type of input records will also help one to understand the problem.

By chance is there any possibilty of getting a non numeric character in the input field like an alphabet or a box character ?

This warning may come, if in one of the inputs of the funnel stage has the specified column and the other input doesn't have the same..!! Please check the layout of the inputs to the funnel.

Hi All,

I wanted to know if there is a way to compile a job through the command line.