DSXchange

breakpoints was available in version 7.5 but the same can't see in version 11.3
wondering how to do the debugging of job for specific records at particular stage. I could manage with peek as of now.

Hi All, Earlier we use to see the breakpoints in the designer as a job debugging option. but in the recent release, I don't see.

I am looking to records at breakpoints in the job.
Can anyone tell if breakpoint option is removed completely?

Thanks ray, I did refered this and using this StringtoDate(Input_Link.Column,"%(m,s)/%(d,s)/%yyyy")) this should handle single and double digits of DAY and MONTH.. but still I'm having this warning in the log Invalid date value in getInputFieldAsDate() for field '0' of input dataset '0'. P...

I have a date field in string format from the input link.. values could be in format 'm/dd/yyyy' or 'mm/d/yyyy' i.e, ex: '1/28/1992'.or '01/8/1992' I am using below function to handle it StringtoDate(Input_Link.Column,"%m/%dd/%yyyy") but this works only for 'm/dd/yyyy' input dates Please s...

Because, it needs to pass next stage as "Success" if no rows coming in.

Hi all, I have a reject link after loading data into DB2 table using DB2 connect stage. the requirement is to check if there any rejects. i.e, if no records reject then hardcord as "Success" Else "Failed" using @INROWNUM in the transformer stage If @INROWNUM=0 then "Success&...

Closing this topic. Using ISD input stage I can accept the Array of data from web service and played around the provider setting at console to run virtually on demand.

Where do we find the Configuration options called DSODBON?
As a minimum, it must set 1 if want to capture monitoring data.

my job is using ISD input stage and exposed as services.. so wondering this option could be in IIS server.

Thanks chulett..
Having two issues,
1) job log shows below after job Finished.
Attempting to Cleanup after ABORT raised in job abcd.1 Job abcd.1 aborted.

2) In the designer, performance statics doesn't show

Thanks a lot eostic... helped me to resolve this issue to an extent
played around the provider setting at IIS and able to accept array and run job only on demand (yet using ISD input stage)

Updated to a similar topic at PX forum... Finally, able to accept array of data from web services thorough ISD input stage with the below provider setting at IIS console to run job only on demand Active Job instance = 1 (max) Service request and limit=1(max) thus, restricting job not run always But,...

Finally, able to accept array of data from web services thorough ISD input stage with the below provider setting at IIS console to run job only on demand
Active Job instance = 1 (max)
Service request and limit=1(max)

thus, restricting job not run always

array of data from ISD

Hi - I am very much confused on how to read the array of data as source
what should be my first ds stage? the column are defined in the job parameter

So, ISD input stage is a must required to have 'Input Array' option to appear while Grouping Arguments into Structure at InfoShere Information Server(IIS)?

wondering, why ETL job design can't impose IIS to have 'Input Array' at IIS