DSXchange

any one else ?
I don't think that it is not possible

ArndW wrote:Is this an OS390 or a UNIX Parallel Extender job? If a PX job, use a reject link from the DB2 stage. ...

it's an OS390 job...
our operation system on the sever is unix

eny one?

do you know where can i find the location that DataStage stores the UserStatus ?

Hi We developed a process that includes one sequence job that executes several server jobs, we use the set user status macro to move variables from one job to another. We defined that all jobs can be multiple instanced and we want to be able to run them simultaneously The problem: Some how the user ...

MOHAMMAD.ISSAQ wrote:You can do by selecting the option "Clear the table and then Insert rows" in DB2 stage

this option does not exist in the mvs edition
the only option near to it is replace exsisting rows completly , but this option delete the table for each row again and again

Hi, I'm looking for a way to delete all the rows of a certain DB2 table,
And then insert new rows from a flat file. all this only in DS and not in the JCL by loading a dummy file before
Any ideas?

ArndW wrote:Is there a POWER/PWR function that you can use? ...

no, not that i know of

Hello
I want to compute the square root of and argument (or to compute it's root)
I work in the mf edition, any ideas how can I do it?
Exclude writing an external routine

Hi,
I'm using the MF edition.
I want to perform SQL query by using the relational stage, in the where clause I want to use and outside parameter
Any ideas how can I do in?

I use the relational stage In the MF edition of data stage The job selects data from a DB2 table and then inserts the data into a FF file The problem: although the run step ended with return code 16 , the operation system get's from the program that it ended OK In that case I can't be sure that the ...

Mike wrote:Mainframe Job Developer's Guide has a chapter devoted to the Business Rule stage.

I know and I have read it, I'm looking for something more comprehensive

Where can I find more information about the business rule stage, we never used it and I'm sure it's a very useful stage

In the transformer I don't do anything - just transferring the field to the file.
The date exists in DB2, the date field defined not null.

I use a relational stage which does select date fields from DB2.
After the transformer to a flat file the date appears as 0000-00-00
What am I doing wrong?