DSXchange

Of course I don't see any. I can't see your data. Try UTF-8; chances are that that's the best fit for the Oracle map. Is this what's specified in the oracle_cs.txt file?

If you can figure out how to do that from a command line, you can fire up that command as an after-stage or after-job subroutine.

Any table definition in the Repository can be loaded into any stage type. Table definitions are global in scope, and stored in the same structure irrespective of whence they were imported. This is one of the hidden strengths of DataStage. For example, having imported a table definition of a database...

deanwalker wrote:Information Server does not have the 'Omit' option on the Attach dialog.

See point 4 in my initial response on this thread.

Amazingly asking that If UV.FLAVOUR is not used by DataStage, Would DataStage not have any UniVerse Account flovour inside? If not, Which flavour of UniVerse Account DataStage takes for its Engine functionality?( among IDEAL, IN2, INFORMATION, PIOPEN, PICK and REALITY or none) IDEAL. No choice is o...

Yes, it's a regular query that you can do with a UniVerse stage, or from the Administrator client or TCL. Create a single integer column with a derivation of COUNT(*). If the hashed file has been created in a directory (not in an account) you will also need to create a pointer to it using the SETFIL...

Welcome aboard.

Please post your question in the Server Edition forum if you are asking about server jobs, or in the Enterprise Edition forum if you are asking about parallel jobs. (This is general advice - I know that you need the Enterprise Edition forum for this particular question.)

CASS is purely USA.

You can apply the COUNTRY rule set to get QualityStage to take a best guess at the country that an address is in.

You would normally do that before applying any country-specific rule sets, and filter by country.

How do you determine "15 days"? This is at the crux of the issue.

Stop thinking like a server developer. Oconv is treating 065535 as the number of seconds since midnight. Try the TimeFromSecondsSince() function (I'm guessing the name, so be flexible).

Do you have write permission in the project directory?

Have you re-started either DataStage services or the Windows operating system since adding this user ID?

What user ID are you using to attempt to login? Unqualified, qualified with machine name or qualified with domain name?

Is there a "last updated date" column in the record as well? That would make the task very easy. Otherwise the solution is going to involve figuring out how to identify which "R" records have been there for your 14 day requirement. I can't really think of an elegant solution where the storage is in ...

Wanna race? Any N (identically structured) rows up to 10 million.