DSXchange

Hi , I am trying to connect my DSServer to a remote Oracle DB Server in our LAN using the OracleConnector Stage in a parallel job . I am reading the a set of values from an Oracle Table and writing it to a DataSet file. I am able to read the values from the Oracle Table in the OracleConnector Stage,...

Hi, I am writing to XMLs from a flat file, and the source data is rather uncleansed, We see a 0x1a in the source, which is messing up the output XMl I tried using an indexof function to find it and remove it, and concatenate the left and the right portions of the string. Sadly that does not work for...

Hi, There is a Sequential File stage before the XML Input Stage, which reads a file that only contains the file path of the XML document. when it comes to the XML Input stage, I specify that column from the link of that Sequential File Stage as a URL/File path. That's how I can extract one XML recor...

Hi, I'm trying to read an xml document which has multiple lines of xml. Each line is an xml document. In the XMl Source tab of Input link properties of XML Input Stage, I specify the column as file path, and create such a file which has the XML document file path. Here is my problem. If the XML docu...

We have the Datastage server 8.1 installed on Linux machine. We need to have a DSN to connect to the Oracle database which is on some other windows machine. please let me know it is enough if we create a DSN at the client machine or do we have to change the config file in UNIX? It is very urgent for...

Hi,

My job gives me a lot of this warning message
SQFS_CustRecords,0: Input buffer overrun at field "LST_MAINT_DT", at offset: 982

Can anyone tell me how I can solve this. The Sequential file is reading from a file with no delimiter. It's a fixed length field file.

Thanks, Actually there's a problem I am facing. The reason why the installation failed is because one model was partially deployed. ERROR [org.apache.commons.launcher.ChildMain] impl.DefaultModelDeployer - com.ibm.xmeta.exception.ModelIsPartiallyDeployedException: This model is partially deployed: &...

Hi tcheslav, I just finished the FP2 installation using GUI mode. I had same situation as you had for the first time. It completed with warnings. ADMU0128I: Starting tool with the default profile ADMU3100I: Reading configuration for server: server1 ADMU3200I: Server launched. Waiting for initializat...

Hi,

I know this is an old thread. By any chance, could you tell me how you installed FP2.

Hi, I have IIS8.1 base version installed on the server. I'm trying to install FixPack2 on top of that. In the Updater Installer wizard, after I select the fix package location, it prompts me for both Information Server Administrator username/password and Websphere Application Server Administrator us...

SURA wrote:It will arrive one after another / at the same time ?

DS User

So this is what I have in mind,

I will keep a dummy file, and in the sequencer, check whether the Input file has arrived, using file watcher, if it has arrived, I will Just write an Input row using a Transformer to the Log

SURA wrote:It will arrive one after another / at the same time ?

DS User

It will arrive one after the other.So the case is let's say if a file arrives in morning, i insert a record in transmisison log,
If the file comes again, I insert another record in the same transmission log

My functional requirement is that if a source file arrives at any time, I create a record in a transmission logfile, with the information about the filename.The Input file has over 8 million records in it, so I dont want a stage which reads the whole file as it may slow processing time, and i have t...

It's 8.1

Hi, I am having a problem in terms of tiling different views. Currently, once I open the repository view, it's overlapping with my Canvas. It's pretty annoying to close the repository view all the time when I need to edit the jobs. Can someone help me to make different views tiled together, for exam...