DSXchange

Hi Kiran,

There is a function in PX called Num(input field). This returns 1 if the input varchar field is convertible to number. With this returned value you can find that it contains only numeric...

Best of luck!

I think that these special characters are internal representation of characters in every editing application.

Just to add a note to the reply. Inorder to use the command kill -9 <pid>, you have to be logged in as the owner of that process getting killed .

Thanks.

It is a problem with the way datastage handles the parallelism. try increasing the MAXTRANS database parameter for the table and the index on that table. But if you dont want parallesim, include the $APT_CONFIG file parameter in the job and modify it for single node file. It should run fine............

the stage variables are some temporary variables defined in the transformer to play internally within it. it is very helpful in terms of complex calculations involving many intemediate calcualtions. if there is a field "FIELD1" for which the calculation is x * y + z. Inturn x,y,z has got s...

But the nulls were displayed in Dataset stage and that too for all the records (not few records where the values are defaulted as you said). :? Instead of dataset, I used sequential file stage at the end. I got the values expected. Any idea why this is. Any problem with the dataset while uploading t...

I also had this problem. when the working with the Dataset and the sequential file in the same job. After running the job, when I saw the data, it was all NULLs :shock: :!: . Any one knows the reason. I remember reading from a sequential file and putting in a dataset. and the dataset contains nulls ...

Sinc your files not associated with any keys, you can add one. say an additional field called DUMMY in both the files :idea: . set the value of 1 for this field in both the files, so that all the records from file1 and file2 will be picked up. Then using the lookup bassed on this DUMMY key, you can ...