DSXchange

Hard to say without seeing your SQL. Perhaps you are using CHAR fields and need to do som TRIMming?

I just checked the statistics for the first time in a while and realized how many here are contributing to the effort, so: Many, Many Thanks for your help! The team has had a total of 33 members over time and with all that computing capacity we have reached a team ranking of #586 (out of a total of ...

This is a common issue on Windows installations. The network mappings and settings are different for your Director session and the scheduled background job. What kind of network and mappings are you using? Can you explicitly mount these drives for all users?

The column names used in lookup filesets are fixed, and the key column names used from the main input link to the lookup must also have the same names. I suspect that this is not the case in this job.

Server sequential and hashed files are, by default, created in the project directory. This means that, unless the developers have chosen another path, the data will end up in the project directory.

Even if the file might not show, can you manually type in the full path to the file in UNC format?

ag_ram - As suggested in my initial post, have you tried this before posting your inferences? If not - don't bother replying to this thread as you will have nothing to add to it. Once you have confirmed that a VOC file entry is kept upon DELETE.FILE when the DICT portion is empty or doesn't match th...

ag_ram - Even though you have described the involved procedure, you seem to be getting further and further away from the original precepts to this whole discussion. The original question was how to do this from the server and the inital responses were "you cannot do this without resorting to program...

This is not a difficult exercise to do in DataStage. Declare the input sequential file stage, set the correct fixed length, declare "first line is column names" to true - this will skip your header, and finally declare the file as EBCDIC in the General -> character set tab.

I you take the exact same UPDATE statement and execute it with the command line "db2 ..." command does it work? Would it be possible to post your DB2 query?

ag_ram - I asked you a question and instead of answering it, you wrote a couple of sentences that neither apply to the question nor answer anything else. For clariity, I shall repeat my question: Using your proposed method listed above, how can I restore a job that has a shared container without dis...

Replace your sequential file with a peek stage as a test. Does it work?

ag_ram - I am sorry that you feel that way, but I don't think I missed anything at all. If the original poster has additional questions that is one thing, but if you need further information you can think about starting a new thread.

Are you reading for writing? You might have to do what we did - lots of cast and substring operations in the SQL in order to break the large object into distinct 4Kb chunks that fit into supported data types.

Can you recompile the job and post the actual error address, "de.0" is not a valid hex offset. What non-trivial things do you do in your transform stage?