DSXchange

As far as I am aware parallel read is only possible from partitioned table.

Year = 0 is not valid. The day after 31 Dec 1BC is 01 Jan 1AD in the CE calendar. Do you need to worry about that.

If you want to validate that Year is a four digit number, then Matches "4N" is probably the best test.

A hashed file (note - it is not "hashed" file) solution would be very efficient.

Ad nauseam as well. Enough times, indeed, almost to warrant an FAQ.

Welcome aboard.

Any scheduler that can execute a command will do. DataStage has a command line interface (dsjob) that you use from the scheduler.

Do a Windows Explorer search filtered on date/time modified in the last one or two days.

If they can they will. Being pushy like this only generates negative attitudes. Some people are busy earning a living, some people like to think about problems before posting. So learn patience or harrass your support provider, who may require additional payment to provide the kind of rapid respons...

The largest signed integer is 2,147,483,647 (2 ^ 31 - 1). Your values are larger that that. You need BigInt or a larger Decimal or Float data type to accommodate these values.

Please post questions in the correct forum. Server job answers may not be helpful for parallel job questions, and it helps future searchers if the questions are in the correct forum. A server job answer is to use Oconv() with "MCA" as the conversion specification. But this is not applicable in the ...

Once the data get into DataStage server job there are no data types. Therefore any function can be applied to any "data type". Of course you have to present data in the correct format to any target that requires a specific format. In that case of Oracle that format is typically specified things like...

No, because I don't know what kind of UNIX you're on.

Ask your UNIX system administrator what the correct command is AND what special privileges/permissions might be required at your site to be able to use that command.

Yes, but why can't YOU read the manual rather than requiring someone here to regurgitate the manual?

Are you using a state file in conjunction with the Surrogate Key Generator stage and, if so, have you established and initialized the state file?

Welcome aboard. /etc/groups is located at /etc/groups The file called groups is in the directory whose pathname is /etc. What are you trying to achieve by this? In most variants of UNIX you need to do more (and more securely) than add an entry to the groups file in order for the group to exist. For ...

The properties of the stage types, while overlapping, are different. Without comprehensive knowledge of all possibilities that might occur in an export file, you are not going to be able to do it that way. Use the GUI - that's what it's for. By the time you finish stuffing around trying to be clever...