DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
boxtoby



Group memberships:
Premium Members

Joined: 13 Mar 2006
Posts: 132
Location: UK
Points: 1375

Post Posted: Wed Nov 29, 2017 9:01 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I wonder if anyone can help me with some apparently inconsistent behaviour when importing a data rule definition using the api?

Here's the api command I'm using:

CreateCmd=`$IAAdminPath/IAAdmin.sh -v -user $user -password $password -url $url -create -projectContent $InputFolder/$ruleName -projectName "$Project"`

It successfully creates the rule definition but, sometimes the description is not imported.

Here's an xml file where the description is imported:

Code:
<?xml version="1.0" encoding="UTF-8"?>
<iaapi:Project xmlns:iaapi="http://www.ibm.com/investigate/api/iaapi" name="RETAIL CRMB">
  <DataRuleDefinitions>
    <DataRuleDefinition folder="All" name="CRMB_DRD_HHP99">
      <description>Main Subsidiary Group and generic status</description>
      <LongDescription>Main Subsidiary Group and generic status</LongDescription>
      <Variables>
        <Variable dataType="any" name="src_fld_01"/>
        <Variable dataType="any" name="src_fld_01_ltrl"/>
        <Variable dataType="any" name="src_fld_02"/>
        <Variable dataType="any" name="src_fld_02_ltrl"/>
      </Variables>
      <expression>src_fld_01 = src_fld_01_ltrl OR 
src_fld_02 = src_fld_02_ltrl</expression>
    </DataRuleDefinition>
  </DataRuleDefinitions>
</iaapi:Project>

and here's an xml file where the description is not imported:

(Main Subsidiary Group and COMMERCIAL GRP not imported)

Code:
<?xml version="1.0" encoding="UTF-8"?>
<iaapi:Project xmlns:iaapi="http://www.ibm.com/investigate/api/iaapi" name="RETAIL CRMB">
  <DataRuleDefinitions>
    <DataRuleDefinition folder="All" name="CRMB_DRD_HHP02">
      <description>Main Subsidiary Group and COMMERCIAL GRP</description>
      <LongDescription>Main Subsidiary Group and COMMERCIAL GRP</LongDescription>
      <Variables>
        <Variable dataType="any" name="src_fld_01"/>
        <Variable dataType="any" name="src_fld_01_ltrl"/>
        <Variable dataType="any" name="src_fld_02"/>
        <Variable dataType="any" name="src_fld_02_ltrl"/>
      </Variables>
      <expression>src_fld_01 = src_fld_01_ltrl and 
src_fld_02 = src_fld_02_ltrl</expression>
    </DataRuleDefinition>
  </DataRuleDefinitions>
</iaapi:Project>


Is there a difference between the files that I can't see?

Look forward to hearing from you.

Many thanks,
Bob.

_________________
Bob Oxtoby
boxtoby



Group memberships:
Premium Members

Joined: 13 Mar 2006
Posts: 132
Location: UK
Points: 1375

Post Posted: Wed Nov 29, 2017 9:03 am Reply with quote    Back to top    

Sorry, the second xml piece should have been titled:

and here's an xml file where the description is NOT imported:

(Main Subsidiary Group and COMMERCIAL GRP not imported)

etc
etc

_________________
Bob Oxtoby
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42662
Location: Denver, CO
Points: 219709

Post Posted: Wed Nov 29, 2017 10:07 am Reply with quote    Back to top    

Bob, I went back and made the noted change for you while I was in there adding the code tags... and just as an FYI you can always edit your own posted messages.

_________________
-craig

And I'm hovering like a fly, waiting for the windshield on the freeway...
Rate this response:  
Not yet rated
boxtoby



Group memberships:
Premium Members

Joined: 13 Mar 2006
Posts: 132
Location: UK
Points: 1375

Post Posted: Thu Nov 30, 2017 5:03 am Reply with quote    Back to top    

Many thanks. Very Happy

_________________
Bob Oxtoby
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours