DSXchange

Perhaps using 7.5.2 client with 7.5.3 server?

The obvious recommendation is to upgrade to version 8, where range lookups are supported. Next best thing would be to move one of the tables so that they're both in the same database, even if one is a temporary table whose lifetime is only that of your job run. Then the BETWEEN join becomes straight...

No. And I did not ask for the job log, I asked for the generated OSH, and only for a portion thereof. You will find this in the job properties, on the Generated OSH tab.

Resist the requirement. I don't think it will help, if that's the only reason for implementing it. Or at least get "them" to justify it. Post that justification and we might take another look. You would have been able to view the complete post if you had a premium memberhip. At less than 30c per day...

Can you please post that part of the generated osh that pertains to the Aggregator stage, between the lines of asterisks, so we can check your work?

hello Mr.ray thanks for ur response so dsjob is the commans used is execute the ds job in unix. can u please elaborate what is the syntax for dajob command.thank u again. Ur was a city in ancient Babylon, and U is the name of one of our participants (it's a fairly common Burmese name). The second p...

To be able to use MapStage you will, naturally, have to have a WebSphere TX map that it can invoke and that, in turn, means that you will have licensed (purchased) WebSphere TX.

I can not envisage that this really strange format would make anything go any faster. Indeed, I would suggest that the processing required to decompose that structure would slow things down. My recommendation, therefore, would be to leave the data structures as they are and to seek some other way to...

File copy will get the objects across but is a Bad Idea. This is because, while the objects are present for the projects, the entries in system tables and so on that describe them will not and the projects will therefore be inaccessible. Create the projects using administrator, and transfer using ex...

Simply apply the QUARTER.TAG transform. This gives yyyyQn (a standard format specified in ISO 8601). If you require nQyyyy then something like the following will do it. Oconv(Iconv(InLink.TheDate,"DMY[A3,2]"),"DQY['Q']") Or, if you require a two-digit year, the fo...

Why not disable operator combination and find out precisely where the error is occurring?

What do you not understand about what I posted?

Welcome aboard. The DataStage command line interface is the dsjob command. You can find this documented in the Server Job Developers Guide and in the Parallel Job Advanced Developers Guide - in either case search for "command line interface". Search on DSXchange for examples of use and prerequisites...

Two lookups. The first looks up 50. The result of that goes through a Transformer stage that generates the string "Not50". The second lookup is conditional on the first having failed.

(a) Sounds like FIELD.DEF is a compiled, read-only field, but which has not been compiled. Or it may not be a well-formed definition. Try executing this command CD DICT.DICT to see whether it improves matters. (b) Correct. But the arguments to SETPTR are purely numeric. (c) Yes, you have to have a m...