DSXchange

try using the function 'Convert'. svar1= If IsNull(Input.Col) Then '' Else Convert('0123456789',' ',Input.Col); -- Convert all numbers to spaces svar2=Trim(svar1," ","A") -- Trim all spaces If svar2 = '' Then Non-Numeric Else Numeric I am using similar logic to clean junk charact...

Thank you all for sharing your ideas & info. I will request our admin to raise a ticket to IBM to get the patch.

I tried the option of purging logs until yesterday for this job, but i am getting the samething. I see the weared scenario that i mentioned earlier and i have captured the screenshots of the director showing that all 5 instances running initially, then the parent job showing that one of the instance...

As i am calling the same job with different invocations, there is no change to thee job. We have set the Auto Purge Job log to 6 runs at the Project level in Administrator, i tried changing this option to 21 and still having the same issue. The other strange thing that i have noticed is that, when t...

Job invocation itself is failing and i cannot see the log in the director.

We have a multi instance AUDIT job that runs for each and every job and collect the job stats and load them to AUDIT tables. Sometimes the job is failing when couple instances of the job is running with multiple invocations. We got the following error. Error calling DSRunJob(SEQX_ROUTINE_SAVE_JOB_IN...

Source Metadata is Decimal 13,2 and i am trying to capture the decimal part of it.

FABS(00000067767332.29 * 100) returning me 6776733228 when the target is BigInt, where as it is returning 6776733229 when target is decimal. It is giving correct values for most of values but for the following values it is giving wrong values. 00000067767332.29 00000067117893.84 00000065365551.43 00...

what is happening if the field3 has only spaces, we had a similar issue while loading to Oracle using Load option ( bulk load). Whenever we have all spaces, it simply trims all spaces and loaded a NULL into Target. Can you confirm what is hapening with DB2 when you have all spaces in a field. Thank ...

Please Trim all the spaces before checking the NULLABILITY, there might be some spaces. Otherwise use NullToEmpty(Colxxx.Val) <> '' Then ... Else ... soon

Before using the Trim make sure that you are not trimming NULL, records will be dropped during Trim incase they have NULLs in them

We cannot write a NULL to a sequential file, we have to set a default value for NULL. Case 1:Set Null Field Value to a single space ( which will result in a warning, we can ignore it) Case 2: Set default value to each and every field, this is tricky. a.Varachr --need to put the same number of spaces...

change the metadata of the field you are extracting from Jion to be NULLABLE YES, then you get NULL whenever match not found. If the metadata nullability NO then it will return a default value based on the type of the field. In your case it might be returning zero as it is a decimal field

In Sort Stage,hash partition the data based on EmployeeID and sort the data by Date descending, please generate the key change indicator which can be used in the transformer/filter to pick the right salary and date. The other option is to extract the recent by writing the proper query.

Are you using any invocationID when you are calling from the sequencer, might be job with that particular invocationID having the status 99

Can you check whether the metadata of the input/output col from lookup is NULLABLE OR NOT NULLABLE. When it is NOT NULLABLE, then it returns a default value( in case of Varchar it is '' empty, decimal it returns zero, date it returns a default date). If it is NULLABLE then only it returns NULL.