DSXchange

No, I've never encountered particular problems due the the column type - but timestamps & dates can be bothersome to work with.

In DataStage server jobs the transform stage additional can do lookups. In PX each stage performs a specific task and you end up using more stages, but each one is specialized and tuned to it's specific task. The Transform stage cannot be configured to do more (or less), that is just the way the app...

No, your explanation is spot on.

The less conversions you perform, the more efficient your job will be. I wouldn't convert data types unless I had to.

It can have only 1 main input, and n-output links. If it had more than 1 main input, then it would have to be merge or join stage.

It can have only 1 main input, and n-output links. If it had more than 1 main input, then it would have to be merge or join stage.

Ray - I'll take that advice under advisement :D Now, you need to go back and tell Roopanwita what his delta blues column contains. Roopanwita - We might be joking around a bit here, but remember that we cannot know your data descriptions and the column is not a reserved word or name in any system we...

Why not try it in a test job and get a definitive answer?

You are nowhere near the design limit. If you set APT_DUMP_SCORE to true at runtime you can see how many actual processes you get at runtime - this may be less than you think if the join stages can be combined.

There has never been a "ds" executable as a part of DataStage.

So one possible answer is to get an internal date by adding day 1 of each month.

ag_ram - you asked a question and Ray answered it. The rest of your mail regards your interpretation and amazement and is just a statement, not a question. If you don't agree with the answer or the contents of the documentation and wish to argue views or interpreteations, then perhaps you can contac...

Is "0823" supposed to be "August, 2023" or "August, 1923" or another date? In order to put this into an Oracle DATE you will need to add a day-of-month as well. What should that be, day 1?

I have no idea what that column could be used for. Does it always have "A" or does it contain other value? "A" could mean "Add", "D"elete, "C"hange or "M"odify.

I have a COBOL file at this site with a column called "ADDRKENN", can you tell me if I need it and what it is used for?

The Row Merger stage reads data one row at a time from an single string of a specified format. It then writes the string on stage can have a single input link and a single output link. CRC32 values are used to quickly and efficiently compare values. There are hundreds of pages in Google that descri...