DSXchange

Hi Ernie,

Got it! I mapped the "anon choice" to the link name and then all the columns attached to it were mappable.

Cheers,
Bob.

All done, thanks!
Bob

I have discovered a little more. When I use the "Click to Select > More" method of mapping, attempting to map decile_1 produces the following error message: CDIUI2820E The mapping is not applicable due to an invalid type conversion or difference in the source and target list dimensions. Th...

Hello, I wonder if anyone can shed any light on this JSON parsing problem. The following file structure is handled fine by the Hierarchical stage: [ { "reach": "national", "profile_id": "5y2", "First_name": "Bob", "last_name": &qu...

I am hoping that someone has successfully deployed the above option in IGC Data Lineage Management. Using this option should achieve two things, as I understand it: 1. Display the correct icon for an oracle table in the Data Lineage display 2. Allow Data Lineage from the table perspective Neither of...

Hi Neeraj,

You exceute virtually all the IA commands from a script (called by DS, if you wish) using the API. This link explins the API:

https://www.ibm.com/support/knowledgece ... intro.html

Hope that helps,
Bob.

Hi Craig, No, stored procedures are not required. My script looks like this: # DB2 command line statements to copy table /opt/IBM/db2/V10.5/bin/db2 connect to database User usrname Using password /opt/IBM/db2/V10.5/bin/db2 "Declare cursor_tmp Cursor For Select * From $Source_Schema.$Table_Name&...

Hi there, This might be a slightly hieretical post but if all you are doing is copying data from one DB2 table to another on the same DB2 server with a where clause, have you considered using cursors? You can call a script from a DataSatge job, which starts a DB2 command line session which uses SQL ...

I know of one site which has a single node parallel licence. So perhaps IBM, with saying anything publically, are trying to sell only parallel licences to new clients even if it's a single node. I agree though, I don't believe that the server edition is going away especially as sequences are server ...

You can use the api to extract almost anything from IA including the data rules and data rule definitions to xml and in some cases csv as well. Here's the link: https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ia.restapi.doc/topics/r_restapi_getlist_commands.html Hope ...

If I understand correctly you want to run a job once per employee/date combination and pass the results on to the next process. I don't know if that will be quicker as you hope, but here's how I have done this sort of thing in the past: Output the list of employess to a flat file. Turn the flat file...

Many thanks. :D

Hi
I have had scenario 1 when working from home and the connection not as good as in the office. I found that turning off "show performance statistics" in designer helped a lot.

Hope that helps,
Bob

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

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 -projectNam...