DSXchange

Great, thank you. I will read through these articles and post if there are any follow up questions.

All, I am new to IA and have a scenario that requires me to input hundreds of data rules into IA so that we can read it from DataStage jobs. The GL system, whose combo-edits and other validation rules we are trying to implement, can send those rules in the form of an XML file. Questions: 1. Can anyo...

Hi Mike, Thank you for your response. Is there a data model published for the RDM tables? We are planning on that option, but at this time, the tool is being installed and we do not have direct access to the tables. If there is a model, please do share it with me so that I can understand the relatio...

Hello, were you able to figure this out? Based on what I read, there is no direct link/integration between DataStage and RDM. It would be great if you or anyone in this forum can give me some guidance into how the RDM data was loaded and unloaded using DataStage.

Thanks.

Background: We have XML data stored in database under the data type of XML. I have looked it up in IBM's site and the serialized XML data type can hold 2,147,483,647 bytes. While reading this field, we are reading it as "LongVarBinary". Then we apply RawToString() function and store it in...

My understanding is that you need to add DSN entries into .../Projects/PROJ_NAME/uvodbc.config in order to access them in your project.

Thanks a bunch ArndW. That answers a lot of my confusion. However, the last point about RTLogging or ORLogging, I looked them up in the DSParams file and I did NOT find them there! All I see is ORLogFilter=0\1\10\1\10 I see that there is no value set to PXAdvRTOptions . I am not sure if they are rel...

Good morning! I am researching into the repository for IIS DataStage. I understand that there is UniVerse database which holds the run-time information (like DSJOBS etc.) and then there is XMETA. The following link has a good description of the difference: http://www.dsxchange.com/viewtopic.php?p=34...

Also, you can check and see if "Multiple readers per node" is beneficial for you or not.

Hello, I have a question related to reading an ACORD AL3 format file. We will be getting this file ( I am not sure entirely about this format, except that it is hierarchical and encrypted - apparently this format is an insurance industry standard ) from a vendor's database, FTP-ed to our IIS box. I ...

Thanks for your prompt response @PaulVL. I got the directory mounted on Unix, so now I am able to see the file. But, if that is the case, I do not need CFF stage. I can simply use a Sequential File stage or an ODBC stage (with DataDirect text drivers). However, my question is, what if the mounts are...

Hello, I have a need to read a ".csv" file, which is placed on a shared drive location (path not yet determined ... but for now, I have it on my work station) and load it into a table. This process is on demand. As I see it, I can do this two ways ... 1) FTP/SCP the file to IIS Unix box an...

Hello, We have some shared containers (parallel) that were created some time ago in version 8.0 which have environment variables. As we are planning to enhance, new environment variables have to be added to these shared containers. However, neither am I able to see the button to add environment vari...

Thanks for your reply Prakash. Did you check the config fie in 8.5 and 8.0.1? I think the number of nodes might be different. This will cause inconsistent results as you mentioned. I had a new project created in 8.5 and moved the 8.0.1 config file into it. Of course, I made the changes to it, so tha...

Hello all, As part of upgrading our IIS to 8.5, we are testing all of our jobs parallelling with production (which is on 8.0.1). Most of our transformation jobs have a certain logic to get keys from its parent table ... kind of, like this: parent table unld [Dataset] --- Funnel --- Delta load of par...