DSXchange

Hi Kumanr, You can call shell command wc -l to count number of rows in source if it is a sequential file (equivalent for other) using Before-Stage. This number you can use to determine %age of failure. Then inside a Transformer Stage take one stage variable in which you can write your logic and retu...

Hi Nagesh, Please check the Environment Variable settings. Default internal decimal variables are precision 38 scale 10, but this can be changed by specifying $APT_DECIMAL_INTERM_PRECISION $APT_DECIMAL_INTERM_SCALE Set APT_DECIMAL_INTERM_ROUND_MODE to specify : Ceil Floor Round_inf Trunc_zero I thin...

Hi Ray,
Trim(myDate) I used as from source this data is coming in char format. But in target I need only date data type. As you said I can't use DateToString() for date format then what is a solution to get required date format in Dataset file.
Thanks,
-Amit

Hi Ray,
Data type of MyDate is date with width 10. This whole conversion works file if I change MyDate datatype to varchar(10).
Please clarify.
Thanks,
-Amit

Hi Ray, Thanks for your reply. I am sorry, it was typo while posting this question, I have used correct format only. But still I am getting '****' in the target. I am getting correct result if target datatype is varchar(10), but when I make it to date this problem occurs. Is it because I am trying t...

Hi, I am using sequential file as source with char datatype and dataset as target file. I want to convert date format from dd/mm/yyyy to mm/dd/yyyy. I have tried using DateToString(StringToDate(Trim(myDate), "dd/mm/yyyy"), "mm/dd/yyyy") function but conversion is not proper. My u...

We are using DS-7.51 EE through Citrix client. We have sequential file as source and dataset file as target. Total columns are 238. First issue is when I used trim function for all columns it is giving me compilation error (##E TBLD 000000 23:43:11(000) <main_program> Error when checking composite o...

Hi Ray, You are saying that Server Job can not create separate threads to use partitioned table. Then my question is, what is the use of Link Partioner. And whether server jobs are multi-process or multi-threaded. I guess when we use link partioner, we have option to select algorithm for partioning ...