DSXchange

You need to partition by your key column.

Imagine you have this

DataSet
ColA ColB
1 x
2 y

Transformer
ColA ColB
1 y
2 x

If you partition by ColA it is likely that your matching records x=x and y=y will be on separate partitions so will not match.

Same here HPUX B11.11

at the same point you write to ODBC write a sequential file too and check the data in there. This will allow you to narrow down where the problem is.

or you could use wildcards if your file names are amenable) Ray, I recently found that I couldn't use wildcards in the filter command. Craig also found the same issue. Do you know that it can be done? Is there some specific syntax to get it to work? Or is it just not working in our versions of DS. ...

Find it slightly hard to understand what you mean here. If you are using Plug-ins in your server job, you simply need to add your server job to the sequence job and it will work. You don't need to add anything to the sequence for the plug-ins. A sequence job simply invokes other jobs or activities. ...

StringToTimestamp(lnkAgentInLoad.LIC_EXPIRTON_DT: "00:00:00","%yyyy-%mm-%dd %hh:%nn:%ss")

have you missed a space before 00:00:00

If it was Oracle you could use Transaction grouping so that all the delete statements could be rolled back together. Unfortunately I don't know much about the Informix stage, the only thing I could recommend to make it work would be to make sure your link ordering is correct for the order you want t...

I would also go along the lines of stored procedure for this one. You're not doing anything with the data so there's no real advantage of using datastage, it's just a step that needs to be executed. The database is better suited to performing this operation and you should get more control over rolli...

Do you mean if there is anything other than a number in the substring then reject that substring?

If yes

Descriptions of the APT variables are in the back of the Advanced Parallel job developers guide. ...just came to me....when your dates are Not Valid, are they null? I have faint recollection that you can't pass a null into IsValid, so you have to check whether the input is null first, then check if ...

2 things to try 1) When you ftp the files from DOS to UNIX make sure you are doing it in Ascii mode (not binary), that should be sufficient for the FTP process to convert the CR/LF. 2) If you can't do the above or still have the CR/LF on the end of each line you can tell DS that the file is in DOS m...

Check whether APT_NO_JOBMON has been set.

Concentrate on fixing the first error and the second may just drop out.

If you have fixed the first and still get the second try setting APT_DISABLE_COMBINATION = 'True' so you can see exactly which operator is causing the problem.

APT_CombinedOperatorController(0),1

I don't think so, at least can't think of a reason for there being a limit, but someone else will need to confirm that. As long as you organize your jobs well you should be able to have a large number of them before it becomes unwieldy. We currently have just under 1000 jobs and have no issues. It w...