DSXchange

In my case, the primary input of the Lookup stage had two range key columns. One range call was RANGE(lkp.A, "<", lkp.B, ">", 0), and the other was RANGE(lkp.C, "<", lkp.B, ">", 0). I duplicated column lkp.B, creating column lkp.Btoo, then change the second ra...

And at 11.5, but the copy stage solution still works.

Back to the original question, please note that the convert() function deals with single byte comparison/conversion. The change() function deals with substrings.

I moved from 7.5.3 to 9.1, both on Windows. Now, I am running into issue using the new xml stage when creating large xml documents (e.g. feed to Amazon). Support tells me this stage runs on 32 bit java on Windows, but 64 bit java on Unix. This is just one example. There are enough differences betwee...

Page 4-5 of the XML PACK Designer Guide, set the Data Element value to XML.

This tool will create a dump of your file:

http://www.anotheritco.com/tools/downlo ... ile_v3.htm

I am trying to pass xml tags as data via an XML Output stage. However, less than symbols are being converted to < and greater than symbols are being converted to >.

Is there any way of escaping them?

I have tried <<, >>, \<, and \>.

FYI: if it is a 64-bit hashed file, you may have to use fixtool. fixtool The fixtool executable performs the file diagnostic and repair functions of the File Tool option to UniVerse Admin locally. (It is fixtool.exe on NT.) It has the following options: fixtool -file filename [-level n] [-fix] [-fil...

Hi, I just posted version 7px.b of my List all files and tables used by jobs in a dsx file . This version does a much better job (1) connecting the link and stage properties, (2) extracting table information from database stages, (3) parsing SQL statements (the older versions did not do it at all), ...

My mistake. It returns a job handle.

Doesn't DSPrepareJob() return a status value? The code example is resetting the job handle which means the subsequent use of it will be invalid.

If the number of potential output rows is variable, then you may have to take an I/O intensive approach. Convert the double quotes to nothing, and convert the semicolons to @VM ( Convert(';"', @VM, your_input_column_name) ), then write this output column to a hashed file as a data column. The p...

Using a transformer stage as input to an xml input stage, create an input column whose derivation is the URL of the RSS feed. In the xml input stage on the input tab, select the URL/File Path radio button.

I have tools that allow you to store and retrieve values from a parameter table, and access them from within a sequence. They may help. Look at the DataStage Tools page on www.anotheritco.com .

Has anyone used SOA Edition (RTI) to capture a RSS feed?