DSXchange

Remember that doing a EBCDIC to ASCII conversion on a packed field will "ruin" it. You can always use the BASIC EBCDIC function to re-convert the field so that it can be unpacked.

Hello - I don't think anyone is going to be able to help you with this, at least until it happens again. It is like saying "my car engine wouldn't start last week, but now it's running find. What was the problem?" Jobs run the same way when started in the Designer, the Director and the command line,...

Change you declaration line to read

Why don't you go to the manager and do a test run run directly in KeyMgtGetNextValue using your test value of "s1". Does that work or show any errors?

What about LEN(TRIM({string})) to see if the "missing" character is part of the text or the buffered data. I suspect it isn't the text, but your padding.

Packed decimal format equates to the COBOL COMP-3 datatype, and the SDK routines let you convert this value using the DataTypePicComp3 routine.

I'm not at a DS client right now so I cannot look at the code, but some of the calls allow you to specify a job using "JobName.InstanceName"; perhaps that will work in this case as well.

DSguru2B wrote:I think this was necessary. Its been happening a lot in the recent past.

I agree :D. C'mon I double-dare you to quote my message with your quote

Although Windows has come a long way in the business environment it is still perceived by many (including myself) to be a consideration only for small and medium sized businesses. PX is such an expensive product that I tend to think that the real performance gains are only visible on a large system ...

Would it make sense to add a popup-window when people do a reply-quote to a message stating something like There is no need to quote entire messages, use of this function should be limited to editing the quoted text and removing excess words. A quote should only be used to highlight parts of a messa...

What kind of a stage is OBP_NS..TRANS_DATE?

Hello Abhilasha and welcome to DSXChange! This is a common problem and has been discussed very often before in the past. Although it is stated in the FAQs and elsewhere, let me add one more recommendation - please use the search functionality in DSXChange before posting questions. This will have a c...

There should be an entry in the log now that states "from previous run..." which might contain additional information. Can you post those contents, please.

...[SQL Server] Cannot insert duplicate key row in object 'PS_F_xxx' with unique index 'PS_F_xxx.' This is a database error and has nothing (directly) to do with DataStage. You are doing an INSERT on a key that already exists in the table. Look at your unique indices for that table and either chang...

What does the RESET show for the actual error that caused the abort?