DSXchange

Hi All, I am concatenating three files into a single file by using the windows COPY command. I am concatenating these in a basic routine. COPY command was executing sucessfully but one extra record with data as '->'is inserting at the end of the file. Can any one have idea why this extra record has ...

Thanks Ray,

It is perfectly working.

Hi All,

Can any one help me to conver the system date into DDMMCCYY format?

I coluld not find any equivalent VM-CONVERSION character in OCONV function.

Hi All, I need to FTP a file to remote server by using the FTP stage in Server jobs. While FTPing, I need to append the current timestamp to the name of the file. If I look at FTP stage properties, only way to give names at runtime is through JOB-LEVEL-parameter. Now, How can I assign a value to a J...

Thanks ArndW. I will test this. Meanwhile i have given one try on function COUNT in basic. It is also working it seems. I put this function in a routine and tested. Code is as below Ans = COUNT (Arg1,Arg2) Arg1 is my COL1 Arg2 is my string to search. It is returning the valid count. Thanks again,

Hi All,

The word BANANA may come also as BANANALYKJKJS or BANANALY etc in COL1.
The below given code will return TRUE even for this kind of strings also?

Hi, I have a column with data COL1='APPLE BANANA CHERRY ETC'. I want to check weather the word BANANA is there in the COL1 or not? word BANANA may come at any position in COL1. Currently it is 2nd word but in real data it may come as 5th word also, even in that case also i need to return a flag. Can...

I tried to compile my routine using the CXX compiler. While compiling it is giving the error as "Compiler "cl" not found." I have MS Visual Studio 2005 is installed on my machine. Even i give cxx and give enter on command line, it is showing the same ERROR. Can any one help me ho...

Hi, I have written a CPP program for implementing the Parallel routines on WINDOWS machine. I tested my CPP program with VC++ and it is working fine. Now i need to create a .o file for linking it to the Parallel routine. I am trying to compile my code with cxx compiler on Windows command prompt. My ...

Hi, Im not able to view the logs for any of the jobs in my project. When I try to view the job logs Im getting below error message: "Error selecting from log file RT_LOG998 Command was: SSELECT RT_LOG998 WITH @ID LIKE '1N0N'COUNT.SUP Error was: Unable to open DICT "RT_LOG998" Im able ...

Thanks Chulett, For Designing the Polling process job we dont need RTI or webservices pack in Datastage? Files will be arrive one day in a month (We dont know which day it should be). When the files are ready on source system then Datastage has to get the file ASAP else file will be deleted (automat...

Thanks for the responses. It is a file from source system. The XML will be FTPed to staging server as a file. My requirement is : If the file is ready on source system, then it will generate a XML saying file is ready to FTP and that XML will be sent to Datastage as FILE. Datastage has to receive th...

Hi, I have a requirement to wait my job in infinite loop until it gets a XML from some other system. Once it gets the XML, it has to process that XML and start other jobs. I came to know that we can do with Webservices in Datastage but my concern is " IS WEBSERVICES JOB WILL WAIT IN INFINITE LO...

Have you checked whether any schema updations/changes has gone on your database side?

This is already discussed in this forum.

Refer the below link. This may helpfull to you

viewtopic.php?t=102387&highlight=julian+date