DSXchange

Me neither... hence the 'may' part.

If "evdate" is a job parameter in the Sequence job then you may need to encase it in hash marks '#' so it knows that.
See if that helps at all.

You can't do "assignments" in trigger expressions. An trigger expression evaluates to TRUE or FALSE so use two triggers to two different Job Activity stages, one for each job with the proper range check in them: Job1: evdate[4,2] >='02' and evdate[4,2] <= '05 Job2: evdate[4,2] < '02' or ev...

You generate rows like this:

1
1 2
1 2 3
1 2 3 4

All you want to do is send one to the Folder, hence the aggregator set to 'last'.

No clue on the second thing at the moment.

Any chance that only one generic job is used to get both parameters (since the queries 'hit the same table') and it is passed out via USERSTATUS? You may have a timing problem.

One of them is probably a typo and yet... allow me. Splitted.

How about some details of your job design?

I'm looking for the logic to implement in datastage. Then as noted you'll need to detail your requirement, right now it's a little too vague. "Backup" means what in this context? Do you actually mean purge? And "one year at the end of every seventh year" needs to be clarified as...

As noted in the linked post and the docs, yes it takes a single record so if you have multiples you need to get them all concatenated together with a record delimiter between each. Do that in a stage variable and then send it to an aggregator set to 'last' before the Folder stage. Sorry but I don't ...

You could start from somewhere like here which is the official 8.5 documentation. Close enough, especially considering that most of the older 8.1 documentation needs to be purchased for several hundred dollars each. :shock: Problem is the Developer's Guide is a Parallel Guide but you may find it use...

BTW, there is a "Developer's Guide" available from what I recall that should be a good starting point for you for fundamentals... I can't look for it from work right now but later tonight I'll try to find a link to it for you. Should be some free IBM Redbooks that would help as well. I'll ...

Did you try doing an exact search for "APT_BadAlloc: Heap allocation failed"? I got 64 matches including yours and many were marked as resolved... hopefully something in there will be helpful.

However, the length noted in the field is *not* the actual length as it is then "padded to a multiple of 4" if needed... that seems like an issue to me.

I know you only have Server edition. I was making an assumption based on your early posts where you stated things like "I have successfully installed DataStage Server Edition version 8.1 on my Windows 2003 machine But I am not able create Parallel jobs, only Server and Sequence jobs are availab...

You seem to have some level of experience in Parallel jobs... it's not any different in a Server job. Or a Sequence job. Do you have a specific problem / question / requirement that you need help with?

Server is very forgiving and technically everything is a string under the covers. If you want the year from a date I would just substring out those 4 characters. Or use the Field() function. I think OCONV requires the argument in the internal format as generated by ICONV Yes, it does require an inte...