DSXchange

assuming you have design, like below db2----| seq----|join stage----seq file 1. now you have left outer join, with seq file on left and db2 on the right. 2. assuming db2 has two columns, 1st is a key column and 2nd is the date column. 3. now in db2 stage or join stage or o/p seq file stage you didn...

DB2 table has a valid date, but the join is returning 1901/01/01.

ok - thanks for the reply.

I am doing a group by/sum select in a DB2/UDB stage. The amounts being summed are defined on the table as DECIMAL(15,2). The problem is that when I try and pass these values to the rest of the jobstream I get the following warning: Implicit conversion from source type "decimal[31,2]" to re...

Thanks for reading


If DB/2 connectivity is set up. What stage would we use in DataStage? Could we use the udb/db2 stage, but set up for remote conection to the mainframe the same way would set up for remote connections between servers that have DataStage installed?

So any luck on connecting to mainframe tables form server jobs. Can DataStage even do this? This question is really for anyone.

Looks like it is returning zeroes. Thanks for the help.

The data type is integer.

I have a situation where I need to do two separate lookups which will return new values from a table if the key is found. If both lookups fail, I already have what I need and no further processing is necessary. If one or both of the lookups were successful then I need to do some additional processin...

I have a situation where I am reading in a sequential file and for each record read I need to insert multiple rows in UDB database based on a match from the key in the sequential file. i.e.... Read Seq file Select from DB where DB.col1 = Seq File.col1 For each row returned insert new row in same tab...

Hi thanks for reading. We have switched to datsets instead of sequential file stage. Everything seems to work now.


Thanks

Hi, I have created an output file in a datastage job that has 3 fields. One of the 3 fields is a varchar 50. We are having trouble reading this same file into a seperate DataStage job. We can't understand why DataStage can create a file in one job, but cannot read that same file into another job. We...

Hello All, using this format echo [ctrl-shift-v then crtl-d] > pipename I then type echo^D>ordb221340180a0324b9_.009 but nothing happens. My command promt never comes back either. am I using the command correctly? the file name above is in my scratch datastage directory. prw-rw-rw- 1 xmm13 staff 0 O...

Hi,

it looks like we are talking about the same thing. Let me try this and see what happens. I will let everyone know.

Thanks

Hello All thanks for your response so far.

right now I'm trying ctrl-shift-v and then a ctrl-d then pipe.


What is sendint?