DSXchange

What is the group associated with objects in DSEngine and the 'bad' project? In particular, what are the owner and group of the dssh executable in $DSHOME/bin ?

Search DSXchange for the term "recursive SQL".

What do you mean by "see"? Have you opened Column Analysis? Did you create any reports or publish results?

Moderator: please move to Information Analyzer forum

What are the permissions in DSEngine and in the project where you can not do this work?

What has this to do with the DSXchange site/forum?

Reset the job then report to us what is in the "from previous run..." message in the job log.

Encrypted maybe not, but one of my sites is now seriously looking at data masking, especially now that the Data Masking pack for DataStage is available.

Next time you run that job the fifo file will be replaced. You won't save any disk space by deleting them, so why bother?

Use (set APT_CONFIG_FILE to) the same configuration file as the one that was used to write the Data Set.

Alternatively from the Administrator use the SH command.

From command line ls \&PH\&

From Administrator client LIST &PH&

The client is set to use Spanish. Change the Windows settings to English and the DataStage clients should follow suit.

Other things happening on the machine at the same time is an often overlooked one.

Don't include the RUN_ID column in your design. Mention it only in the user-defined SQL. I presume you are using an Oracle sequence because there are likely to be other processes inserting rows into this table at the same time that you are. Otherwise consider using a surrogate key stage, which you c...