DSXchange

Are you trying to triplicate the number of rows you have in the end? Starting out with 3 rows and you want to have 9 in the end? With not having a lot of information here's what you do. Create a sequence with a loop of 3 loops. Then have it run your job three times.

Could you just create an XLST file so that when you view the XML file in a web browser you can get all the prettiness of an HTML file but the data is still XML. I'd be curious to know what you use case is for this because it sounds like you're starting to mix DATA (xml) with the UI (html).

Did you ever find a resolution to this?

I've had my environment up for a while then all of the sudden I started seeing these errors in my logs and I don't know what's happened to cause this. I have a PMR open with IBM but they're being slow providing a resolution.

Ray's answer is as I feared. I used to only be a on a server edition so I wrote a linux command to sFTP the csv and then used a server sequential file job to load the data. I now have a enterprise license available so i was hoping to take advantage of the parallel FTP stage to do native sFTP but it'...

I'm trying to figure out how to load a CSV that has multiline values within the data columns. Example, here's 3 rows of sample data: "Col1","Col2","Col3" "first row","really long text","more data"[CF/LF] "second row","example...

How are people managing their code promotion? Our setup right now is developers work in their dev environment and when they're done with their job, they bundle everything up in a package and send it to the change control software for a scheduled deployment. The software just issues a command line is...

I randomly stumbled on the solution, long after giving up hope and I had moved onto to other work. The FTP stage doesn't have the ability to skip the first row if the CSV has headers (really annoying that you can do it in a sequential stage but not in FTP stage). So the function was complaining abou...

Hi Does anyone know if there's a format mask that can handle mix digit lengths for the format mask of StringToDate() function? Example data: 1/1/2015 02/02/2015 11/15/2015 My the string dates are consistent and this format mask in a transformer isn't working for me: StringToDate(DSLink1.DOB,"%m...

Maybe there's a reason your scenario prevents this, but don't forget the usefulness of the "Wait For File" stage if you're able to use it.

I've noticed that the parallel FTP stage will write the file temporarily to /tmp on my server. I want to change this be a different directory: /scratch Is this possible, where do I specify to tell datastage where to write these files? In the project environment variables, I found the TMPDIR variable...

I've read the other threads already on datastage so I know this is a popular error, but I'd thought I'd just post again in case there were any fresh ideas how to get rid of the warning: Conversion error calling conversion routine decimal_from_string data may have been lost Input source is a varchar(...

Registry Location:

HKEY_CURRENT_USER\Software\IBM\InformationServer\xx-xx-xx\DSDesign\Settings\Debug\
X, Y, H, & W values.

At the office my laptop docks to two monitors. I had the debug window opened on the second monitor. Now I'm home and just working on the laptop monitor and I can't see the debug window. I'm assuming it still thinks I have two monitors and it's opening where I can't see it. Does anyone know of a cach...

I'm using the FTP_Enterprise stage for SFTP for the first time. When my numeric columns are being sent through, the recipient is seeing leading zeros on the numbers. So the column was define Numeric 38 and my data is showing up as 00000000000000000000000000000000054321 How would I remove these leadi...

I think i solved it. Thanks to this post: http://www.dsxchange.com/viewtopic.php?t=155121 and this PDF. Once I incldued the environment variable as part of the job parameters. I then changed the default value for that variable in my job to point to a new file (3-Node.apt). In that file I had specifi...