DSXchange

Both those messages are OK, the first one just means that nothing much was done to the file, the second means that the file is not a resizable hashed file (usually this refers to directories). This means that your DataStage files are internally consistent, which is an important first step. Next, ens...

I will guess that the extra code is in the original and you are seeing an artefact. If you were to do a force compile on the original and copy and compare the .dsx files they should be identical.

At Version 8.0 the design time information is stored both in hashed file and in the database repository. This does not change at 8.1; log information is stored in hashed files at 8.0 while at 8.1 you have a choice of where to put log information.

Do you mean that this line is in one file and not the other? You should also post a couple of lines above and below, at leas to find out in which .dsx file section they appear.

Since you are still at Version 7 the UNIX level backup would probably get you going again, unless the system was very busy with developers creating new jobs while the backup was running. Just stop DataStage (to ensure that no users can login), rename to "bad" directory, restore it from bac...

Remember that a "?" mark might be an undisplayable character, so you will need to produce the hex equivalent. Start with the source - what is the hex value of the first character. Then check the same character in the sequential file. If you maps are NONE then they will be identical. If bot...

You are going to have either delete the project then restore a backup or roll up your sleeves and be prepared to do a number of actions from the TCL command line level. By far the most preferable solution is to start from a restored backup and with a "clean" project. Do you have a backup o...

Hmmm.. I can only find one mention of that in this thread. Nonethess, I am sure that you are well on your way to solving your problem by yourself and that others on this thread are better able to assist you than I could.

How about answering some of the questions posed earlier in the thread: - does this happen to only your client or do others have the same problem? - did you or did you not install a patch for this problem? I'd also like to confirm that this is only the Manager or does it also happen with the Designer...

What does the "editability" of the settings by others have to do with the original question? Scheduling is not done by shell scripts, but by cron on UNIX, so if any other method is to be recommended, it would be by directly editing the crontabs.

Why not set it specifically for the column. right-mouse-click on the column name and "edit row" to get to where you can specify the column specific handling of default values.

I think you are trying too much at once. Reduce the problem to the read portion, just read the data and then write to a sequential file. Ensure you choose the right mapping for your source - once that works, you can add complexity.

I note that this is the first time you've mentioned the sequence and job behaviour in this thread.

There is no one-button solution, but if you want to schedule it to run hourly over a day then you need to put in 24 entries from the director.

Since RU8PC866 does not contain mappings for arabic characters but you stated that they are visible in the source, you are essentially corrupting your data by mapping it from KOI8-R during your initial read. This stage needs to be told that the incoming data is already in AR8MSWIN1256