DSXchange

Hi there, It is not strange... When you make NOM_SUPP the key (repetition path), the following thing happens: 1. When it goes from the first record to the second record it finds the CD_SUPP changed and not the NOM_SUPP. 2. Therefore, due to the rule it considers the xpath element common to both NOM_...

If it is an absolute necessity, why dont you write the hash file to a sequential file and then try to read it using unix (vi editor) ?

No it is simply because I was testing with 10 records

No it doesnt work.

I will try reading it as numeric....

If I remove the to_char() in the query and read it as decimal in the source stage, the job aborts with the error: Fatal Error: APT_Decimal::assignFromString: the source string (265801360696340669727895557154445859481 265801360696340669727895557154445859481 265801360696340669727895557154445859481 265...

It is a 38 digit number. So the job is not able to read and process it as Integer and Decimal. I tried out reading it as Decimal but the job is failing. I tried to use the Peek stage and see what was happennng when I used ASInteger...the 38 digit no. becomes 000000000000000000000000000000000000000 ....

Not able to convert a 38 digit string to number using the Type conversion functions. Need to do an aggregation calculation (max) on this column after it is converted to a number. Initially I was having problems in extracting a 38 digit number from a column in an oracle table. That is why I decided t...

Thanks for the responses!! I was thinking along the same line. Probably I will have to run them on a more efficient server. I was just wondering whether it had anything to do with improper job design (like too many nested calls, for example Seq calls a sequencer, which then calls another Batch, whic...

Controller problem: Error calling DSRunJob(Batch::Test), code=-14
[Timed out while waiting for an event]
Can you suggest how can this error be avoided?

There is a small problem :D . The requirement is that I need to run different jobs with different warn limit and that too not manually!! The only thing is that I was preferring to use sequencers. But looks like I will have to do that with a batch.
Anyways, thanks for your inputs all through.

hmmmm....
I understand those being the other ways. Likewise once can also use the DSSetJobLimit from the JobControl of a Batch. But, I was wondering whether something like this was possible in sequencers or whether it was possible to customise the coding written in the JobCotrol of the sequencer!

How can I set the warning limit of a job called from a sequencer?