DSXchange

DateFromDaysSince(-1, stringtodate(right(0:MonthFromDate(CurrentDate()),2):'-':'01':'-': YearFromDate(CurrentDate()),"%mm-%dd-%yyyy"))

The version is 7.5x2.
Its seems OS is a problem, for which reason telnet is not working. I installed the software on Windows XP it worked, but its not working on Windows Vista.

ArndW wrote:Is the version 7.5.2r2 or just 7.5.2? One supports running PX jobs while the other does not. ...

Is its 7.5.2...We have installed the software in past on other system as well, and it was working.

I installed 7.5.2 on one desktop for training purpose. The server and client reside on the same system. I created a simple job, which reads data from one file and writes to another file. "A simple copy" Seq file1 ---> Seq file 2 While running the job I am getting below error. node_node1: F...

Empty and Null have different meaning. Most of the cases you need to handle NULL values properly, otherwise it will create so many problems even at run time. You can use NullToValue() function to handle nulls. If your source data type is Numeric you cannot assign non numeric values for those fileds...

There are some warning with the usage of DecimalToString function. I dont see this as an issue as it would be there even for second design. The only message that could be an indicator is ##E TBLD 000000 15:56:29(000) <main_program> Error when checking composite operator: Subprocess command failed wi...

I have a PX job that need to perform transformation on 278 fields in a file. The transformation is simple to check empty and replace with "NULL". Seq -->Trasformer --> DB1 (10 fields) | DB2 (278 fields ) The above job gets compiled and runs perfectly in one server (Dev1); but it does not g...

Hi I have record like this:- Col1 Col2 1 a 1 b 1 c 2 d 2 e 2 f I want to trap duplicate record in PX. My output1 should be like this:- Col1 Col2 1 b 1 c 2 e 2 f and Output2 should be like this:- Col1 Col2 1 a 2 d kindly help me to implement this in parallel Thanks in advance Which of the two is the...

I got answer to both the questions. Actually jobs which were missed out through above command were not compiled; I would rather say they were never compiled. Once these jobs were compiled I was able to see the results. This again doesn't solve my primary objective :( ; at least I have an answer to m...

Hello, I want to list all Jobs within a given "Category" using CLI commands. I tried using dssearch command; but its not working as expected: dssearch.exe -domain acc-gz3ve9aah8t:9080 -user Admin -password Pass1234? -server ACC-GZ3VE9AAH8T -ljobs -matches -sub -c \Jobs\Inder DSProject Resu...

any utlity on client machine...?

How to find all projects created in datastage without using any of the Datastage Client tools?
The way we have DS_JOBS to find all the jobs within a project; is there any Universe DataBase where we can find all the projects within the server?

there are several look into manual or help if you are refering to Index function then that wont help. I will explain my requirement. assume i have 3X3 matrix as Bill Jon Pam Male Male Female 25 29 62 I have requirement where i need to search "Pam" in the matrix and then read all other ele...

I would like to find index of a string in a MATRIX/Multi-dimensional array.
Does anyone know a function to get the same?

WoMaWil wrote:But you can use the Reporting Tool, which will transfer all actual available metadata to a Database which you can analyze the way you like it.

Metadata/table definition is

NOT

maintained properly. So reporting tool won't help.