DSXchange

In a BASIC Transformer stage you could use


There probably are other ways, but I don't have access to Enterprise Edition at the moment to research them.

Select the property and inspect its value.

User B should not have logged any events if all User B did was to view logs. I would check User B's assertion on this, and/or check that User A only submitted job run requests as User A. Was any job parameter (such as database access ID) set up as User B?

Create another output link from the Transformer stage into an Aggregator that groups by the lookup key and counts rows. If the lookup key is unique in the stream input this will give exactly what you want. Otherwise also pass @INROWNUM as a second grouping column.

chulett wrote:It is listed on Ascential's Products website

So what does DSEE stand for now?!!

Mumble... marketing... mumble... mumble!

Is/will there be a DSEEE (extended enterprise edition)? Might that not be confused with DB2EEE?

DataStage posts the message because it is being prevented from doing whatever it needs to by a defunct SQL Server process.

Everything else follows from that.

Actually, there can be another area where you need to check permissions, and that's on your client. When you create a job sequence, things (XML) get written on your client as part of the process. By default DataStage client is installed at C:\Program Files\Ascential\DataStage; you need write permiss...

Prefer IsNull() to "= Char(128)". It is more efficient and more reliable.

The Rnd() function generates a random number. You need the Fix() or Oconv() function to do rounding.

Is this ODBC? By default the maximum row size you can transfer via ODBC is 8192 bytes. You can change this for a particular DSN or globally by placing MAXFETCHBUFF directives in uvodbc.config file. Similarly the default maximum number of columns is 400, and the configuration parameter is MAXFETCHCOLS.

Schedule a ps -ef | grep ds | grep -v grep > /tmp/what_is_the_job command to run at 01:10. Use this to identify the job from its command line.

I'm not aware of anything called "extended" edition. Nor is Vincent. If you can tell us what it is, we can advise how it might differ from Enterprise edition.

It's always a good practice to use a job parameter for hashed file directory.

Had you done so, you would not have a problem.

Do you want to move the hashed files to the new location? That is a different question.

For running jobs, none.
For accessing via telnet, port #23.
For accessing via DataStage clients (dsrpc), port #31538.

Given that you are not using other stage types, or products such as ProfileStage, QualityStage or MetaStage, that should be your complete list.

A Sequencer has a big blue arrow as its icon. The job type in which it occurs is called a Job Sequence (no final "r"). A Sequencer can accept more than one input - that's its entire reason for existing. You appear to be trying to create multiple inputs into some other kind of activity which does not...

Your umask needs to go in 2 places. It should be 002 in dsenv and uv.rc. In older version uv.rc is copied to /etc/rc2.d. In newer versions it is a link to DSEngine/samples/uv.rc. umask 002 Is the line you need to add if it is not there. you need to stop and start DataStage for the dsenv file to be r...