DSXchange

There are no reject links in either of the jobs. The set up is exactly like I described in OP. I am getting 20 rows in the target in both jobs.

I have 2 jobs. Job1: dataset1 -> copy -> sample - > dataset2 Job2: dataset1 -> sample - > dataset2 Both jobs run fine. However, in Job1, the number of rows moving from dataset1 to copy shows 100 whereas, in Job2, number of rows moving from dataset1 to sample stage shows 20. The source file for both ...

Is there a place where I can see the descriptions of all Datastage provided routines? For version 7.5.1A?

Yes, I meant the Modify stage. Can anyone tell me what
Keep = True
sub property under Key for? It is not documented anywhere.

I found the solution. I used a modify operator to exclusively drop the column. Interesting. Just not linking the column in the lookup stage does not work.

Also, what is the
Keep = True
sub property uner key for? There is no explanation of it anywhere.

Thanks.

I already am. Eventhough Col2 is coming in to the lookup stage, it doesn't get moved among the output columns of that go into the sequential file stage. Col2 from the Lookup fileset stage get moved to output.

My job has a dataset stage, DS1, as source, a lookup stage in the middle and a sequential file stage as target. The lookup stage is receiving an input link from a lookup file set stage. I also have an output reject link to a dataset stage. What I want to do is, if there is a match on Col1 of the inc...

I have the following setup: DS --> Lookup --> SeqFile ^ \ | \lnk2 | \ LookUp DS (Rejected records) FileSet When I compile, I get the error: Error: Reject link Lookup.lnk2 is not allowed unless an input reference link failure property is set to 'Reject'. One solution mentioned in this forum is: "...

I was wondering if anybody could direct me (or may be send me) to some sample jobs for External Source/Target stage and MQ Series stage.

Thanks.

I meant can I do any damage with these commands?

Yes, from what I know. I am doing this on our dev box. Also, I would like to know, can I do any damage of these commands?

I am a developer and not a DS Admin. If needed, I can have my admin execute these commands for me.

Thanks.

kim, I tried the following: I executed 1)export DSHOME=`cat /.dshome` from my home direcroy. I get a message: cat: /.dshome: No such file or directory I executed: 2)cd $DSHOME I get the prompt back but when I do a pwd, I get the same path as I was in before. Also, can you explain what these 5 lines ...

Can you tell me what the PDF file is called?

ray, thanks. Yes, I have a 2 node configuration and that is why it was sending 10.