DSXchange

The solution given is identical to your second sample that you said works. But if it works, why a problem, just keep using it.

Your first sample is wrong because Field1 will never equal all three values at the same time therefore two of the three checks will always be true

Read it as 8,0 and then divide by 100 in a transformer to your output of 8,2

You will also need to make sure every caller uses a different Instance ID when calling the job

An issue I foresee with the external target is that it executes against every line so your redirect should really use ">>" and you need to ensure the file doesn't exist/is empty prior to running. Alternatively, run the command supplied via a sequence command stage if source is already in t...

Are you bulk loading or inserting?

Push your data to a sequential file instead of your oracle stage so you can see if any modification has happened prior to oracle

Admittedly their request was as vague as can be managed but think they are trying to do a lookup, not merge columns

nani1974 wrote:I think you can do this by using Column_Export stage.

I'm intrigued... how?

As for requirement, create a date range out of your lookup.

Or depending on data sizes and db abilities, do a sparse lookup getting rows with date <= current date (as per row) order by date desc and limit to 1

Are you trying to do an import or export?

Not sure dscmdimport/dscmdexport can do a folder at a time, think it is whole projects. Look at "istool" as an alternative although think you have to accept you won't get a "dsx" from it.

You can do it the way you specified but would need to add a "key" which could be the DIV by two.

Alternatively, you keep keep every odd row in a Stage Variable and output on every even row

There is an admin level setting for the century cutoff, alternatively you can specify year cutoff in your format, I think it is %[2000]yy or of such ilk, help files should... help

I actually meant count rather than dcount (had dcount on my mind due to other thoughts). As for efficiency, I see minimal difference unless the odds on having 2 or more @ symbols in the string is high, since you are always searching for 2 in your index query, it is likely to scan the full string whe...

Might be possible through RCP

Can only see that happening if RCP is enabled otherwise it wouldn't compile. And if RCP is enabled and this is a runtime error, it's more because of a reference to SRC_SYS_CD when that field isn't in the source stream.

Agree with the above although wouldn't %dd expect a two digit day? Can't say I've ever tried against a 1 digit day as I've autmatically used %(d,s)

Or that DCount(field, '@') = 1...