DSXchange

That is a good hypothesis, but would only hold true if it failed with a -14 every time. Usually this error is produced when a machine is overloaded, i.e. when it is so busy that new tasks are not started within DS limits. -14 is resource overloading, either no of jobs are running concurrenlty or th...

mandyli wrote:I have resolved this problem.

If you can let everyone know on how this was resolved, and then mark this topic as RESOLVEd, that would be great.

Hi there, Can we look at the code of the different stages in the Parallel Jobs(Join, Sort, Merge, Transformer) , Like we can look at the OSH code and the Job Score of the Jobs. Is there some place where the code for these stages is stored?(Repository?) As looking at the code of the different stages...

dvpawankumar wrote:Send the Deatailed solution for Converting Source Date format "MMDDYY "to "YYMMDD".

Here's the Command:
Please change my Input Date format("MMDDYY","YYMMDD")

Hi On of our job used DB2 API stage. If I ran the same job more than 3 times I will get following error. "123 FATAL Mon May 28 08:03:29 2007 db2API_ENT_CO_CAV,0: Fatal Error: Fatal: [IBM][CLI Driver] SQL30082N Attempt \ to establish connection failed with security reason "24" ("...

dvpawankumar wrote:Send the Deatailed solution for Converting Source Date format "MMDDYY "to "YYMMDD".

you are ordering here for a solution rather than requesting

Hi all, I am having a problem with DB2 API stage. I searched the forum could not find solution for it. Here is the job. Seq file --> Copy Stage --> DB2 API (update) Job is reading from a flat file and updating the records in DB2 table. Here DB2 errors are getting captured as warnings instead of fat...

Give "Lookup Failure" condition as continue in both the look up stages. After the first look up, check for NULL in your look up result field and if that is true substitute it to '***' and do the look up in the second one. Alternatively you can design your job with reject link for the firs...

Remove duplicate stage requires sorted data, sort stage does not. Remove duplicate stage can retain first or last duplicate whereas sort stage only marks the first duplicate with 1 and the rest with 0. So its rather easy to retain last row using Remove Duplicate Stage. Both these stages do exactly ...

I forgot to mention something, after the aggregation is done on that input column, I want only one output showing me the Total sum of all rows after the aggregation, plus the other columns from the input data[no aggregation on these columns] I have create a Groupkey for the aggregation plus the col...

Doesn't really get any simpler. Don't you have the Convert function in PX? Or EReplace? While I agree it would be best to generate it the way you want it, but failing that it is easy enough to swap the delimiters: Convert(":",".",YourTimestamp) Perhaps another function would be ...

I doubt you're "going wrong" anywhere. Just seems like you need to translate the colons into periods after you've gotten the timestamp, if you really need it in that format. That's what I thought, but I'm looking for a simpler solution in getting a period instead of a colon in the time fo...

It would seem that this is a bug in DS, Ascential is working on a fix and/or workaround. I'll post whatever comes through from support here. ... Has this been fixed in DS 7.5.2 ? I don't get the microseconds with the options mentioned in the manual %yyyy-%mm-%dd %hh:%nn:%ss.x where x is a no betwee...

It would seem that this is a bug in DS, Ascential is working on a fix and/or workaround. I'll post whatever comes through from support here. ... Has this been fixed in DS 7.5.2 ? I don't get the microseconds with the options mentioned in the manual %yyyy-%mm-%dd %hh:%nn:%ss.x where x is a no betwee...

Hi us1aslam1us Thanks for the reply... I haven't used Routines on PX. The Parallel Routines when i tried to create one seems to be allwoing me to point to only external Rutines. Could you please tell me where exactly do i create this external routine and the thread says it need to be compiled do i ...