DSXchange

If i import the table definitions of a table, will the synonyms, indexes, constraints be imported too. If not, while running a SQL query from DS do i need to specify any particular command to involve indexes and all other related stuff with the table !! It depends upon how you import them (that is,...

This thread began with the topic "auto clear log", morphed through clearing &PH&, and is now talking about clearing the status file. These are all different things , people!!! And there are different techniques for clearing them. Which do you want to clear, and why? Would it be enough to ha...

How about maintaining the sorted dynamic array and count in COMMON variables and returning "median of rows thus far" for every row processed? You would need to specify whether the sort order was left- or right-justified (simplistically, alphabetic or numeric).

In the Hashed File stage you have create file checked, so click on the Options tab and also check "delete file before create". This error arises from you (or somebody) not deleting the hashed file correctly. To fix the error you need to execute three commands from the Administrator client command wi...

Right mouse click on each column in turn in the Columns grid, and choose Edit Row from the menu. Within the extended properties editor thus exposed you will be able to find and edit the Null Field Value and/or Default Value properties (the first is under Nullable category, the second is under the "d...

DS.CONNECT is run from the TCL prompt in the project, the same place from which you run DS.TOOLS. A Data Set is almost completely unlike a hashed file - for starters you can have duplicates. The closest thing a parallel job has to a hashed file is a Lookup File Set - that can be used to supply speed...

Set APT_STRING_PADCHAR to space in /etc/profile. Then it will be set for everyone, and can only revert to 0x00 through deliberate intervention.

Not really enough information.

Check and double check that your DSN, user ID and password are correct.

Check and double check that your DSN is correctly configured (there is a test utility called DS.CONNECT in DataStage).

How do you propose to write to a hashed file in a parallel job?

CLOPES wrote:conversions type gone crazy in transformer

That was a delightful piece of "Franglais"; thinking in French (or maybe Spanish, but that would make it "Spanglish") but communicating in English.

Aucune critique.

Tell "them" to supply a file format that conforms to one of the industry standards!

Tilde-delimited and pipe-terminated is NOT an industry standard. It is a figment of someone's deranged imagination.

... unless some scheme for multiple billing is involved.

But here, an all-volunteer site, that is not the case.

You should get out more.

By the way, does it mean the version of Dataset has been changed in Ver 8? Someone with version 8.0 might use the Data Set Management tool (under Tools menu in DataStage/QualityStage Designer, since there is no longer a Manager client) and let us know what the Data Set version number is. In any cas...

You can't, using a Sequential File stage. It is in the very nature of sequential files that you must read every byte to get to the next one. So, if you use this stage type, you must remove the duplicates subsequently. There are lots of ways to do that; all require sorted data, so use sort as the Fil...

Or just look in the log at the "active stage finishing" messages.