DSXchange

So what is the file dictionary for THAT ?

The table whose file dictionary you listed was "ResidentialMaturityCode" yet the name you give in the SQL query is "pilresidmatlovmap". I daresay that the query parser is complaining about a non-existent table name. This is borne out by the fact that it gave up parsing immediately after the SELECT t...

Are the columns in precisely the same order in all jobs and all stages? Navigation in hashed files is by position, not by column name. This includes the order within the key column. Note: correct terminology is "hashed" file, not "hash" file. What columns have you defined in the job that is executin...

CHAR fields are padded with the character specified in the environment variable APT_STRING_PADCHAR. That would be a good place to start looking. Compare the DSParams files in each project.

You might also compare the uvconfig files if the dev and QA environments are on separate machines.

What is different between dev and QA environments? Clearly "nothing" is not the correct answer. Search thoroughly.

This is the fourth thread you have opened with this question. Do you think that will help? The only things it will help to do are boost your post count and boost the annoyance factor for those of us who have to read them. If you need it solved urgently, involve your support provider - pay them the ...

PWD has nothing to do with passwords. It serves the function "print working directory"; it contains the pathname of the working directory.

Is the job using a Sequential File stage to read the source file? How are you attempting to "select two fields" from the file?

What do you mean, specifically, by "parse"?

Only with that knowledge could we proffer cogent advice.

Field(Name.$CommandOutput, @FM, 2, 1) returns the second line of the command output from the Execute Command activity called Name.

I've had a chance to fiddle a little with this, and have not yet found a good solution without adding to the dictionary (or VOC). ASSOC.WITH isn't really amenable in an SQL query on more than one table, but even using the other query language (RetrieVe) I am not having a lot of luck.

Stop the production team from making changes. Production environments are not where changes are made, in a professionally organized software development life cycle. Make the changes in development, test them thoroughly, and only then promote the changes into production. Threaten the "production team...

dsdoubt wrote:Great patience to write whole lot information!!!

Thanks, but I can't really claim credit. Almost all of the words are IBM's announcement about acquiring Ascential, with true numbers plucked from Informatica's web site (Company page).

I am surprised by this result. What is supposed to happen if you do not have QualityStage licensed is that the stage types for QualityStage functionality are entirely disabled.

Become a premium member. It is not expensive, at less than 30c (Rs12) per day, and you will - among other things - be able to read the entirety of the five premium posters' posts. All revenue from premium memberships is devoted to defraying the hosting and bandwidth costs incurred by DSXchange so, ...

Not really. FTP stage streams the rows directly into the DataStage job. You are better advised to create a script to transfer the file and unzip it locally. (Or you could use your unzip command as a filter command in a Sequential File stage.)