DSXchange

I got the issue. Actually a file called vmdsr_sched.exe is missing in the path where the windows scheduler looks for.This may be due to some patch updates of any application in the system. So i had to replace the exe file in the path required, by copying the exe file from my development environment ...

Sir,

The production machine went down during that time.The OS was corrupted and backup was restored and also some hardware part has to be replaced .so does it mean should i start some services of datastage or what could it be?.Kindly help

Hi, I have DS 7.5 running on windows. I have some sequencer jobs scheduled to run everyday and they were failing to get triggered. Can you help me to figure out as why scheduling doesn't work....The same was working for the past 2 years and it stopped working for the couple of days.But when i start ...

Try using the Push method by making etl as the master .
If SAP does not respond with proper info package name or with the request ID it is problem to be fixed by the SAP and not ETL

HI ,

Can anyone help me to extract all the job names only from a project to an excel or to a file .
Do we have any specific DS command or function to extract all the names in the project (server edition).
Kindly help.
Thanks.

Kamesh

If "OCONV(ICONV(YourDate,YourDateFormat)+1,'DD')=1" then YourDate is the last day of the month. ... Sir, I tried this "OCONV(ICONV(YourDate,yyyymmdd)+1,'DD')=1" then the output is 1 and when i try with -1 then it is 30 ,,,and even when i change my month to Aug and with -1 it sti...

The internal date of the last day of the month of February 2008 is ICONV('2008-03-01","D4-YMD[4,2,2]")-1 . You didn't specify if you wanted a full date, a day-of-the-week, a day-number in month or another format as output so I can't suggest any OCONV() function to use, but all the op...

ArndW wrote:Hint: Get the first day of the following month in internal format, then subtract one from it to get the last day of the prior month. ...

Can you kindly explain this with an example

Hi , Can anyone help me to find out the DS function to find the last day of the given month.i have one function called month.last from the built in transforms. so this will give me the internal format for the last day of the month whch i have supplied in the format yyyy-mm. Example: MONTH.LAST("...

use your pivot stage

How many number of source connections will datastage support in a single job design

Iam trying to read an XML file from an IBM websphere MQ stage and pass it to XML reader and to Xer and a file. I get an error DataStage Job 14 Phantom 3360 Program "DSP.ActiveRun": Line 51, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT raised in st...