Run map -- passing database variable

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
jlpa
Participant
Posts: 2
Joined: Wed Aug 24, 2005 1:45 pm

Run map -- passing database variable

Post by jlpa »

I have a map that has a source where I pass a variable -ID -VAR pwknbr=dbfield.

I am trying to do a run map on this map. I can do =RUN ("mymap.mmc", "-OE1" ) and I get the output of the map, but I need to override the input parm. Listed below is what I have tried without success. I've gotten a RC of 12 for it -- which I haven't found.

=RUN ("mymap.mmc", " -ID1 '-ID -VAR pwknbr=dbfield' " + "-OE1" )

Any help is appreciated.

J
janhess
Participant
Posts: 201
Joined: Thu Sep 18, 2003 2:18 am
Location: UK

Post by janhess »

=RUN ("mymap.mmc", " -ID1 '-VAR pwknbr=dbfield' " + "-OE1" )
jlpa
Participant
Posts: 2
Joined: Wed Aug 24, 2005 1:45 pm

did get it to work

Post by jlpa »

I did finally get this to work. Had to do with getting the tick marks correct. One really good tip I got on that is to include the appropriate ticks in the query when setting it up in Db Interface Designer. Then, I don't have to worry about the ticks when passing variables.
Post Reply