DSXchange

That must be it. I got ' 000' but when I use it to do a lookup, it's using ' 00' which couldn't find anything of course. I am able to do a type conversion in the DB2 table before the lookup so I don't need to use the Modify stage. But it's good to know that the string_from_decimal function will allo...

Thanks for getting back to me. You understood perfectly - that was what I was trying to do. In the key expression, the concat function is available for me to choose. I was able to compile the job but got errors during the run. I talked to the Ascential support and he told me that it was not intended...

Hi All, I am using newvalue:string = string_from_decimal (oldvalue) in the Modify stage to convert the type from decimal to string before I do a lookup against a DB2 table where the key is defined as char. My questions are: 1. The oldvalue is 000. After the job is executed, it converted the oldvalue...

I apologize that I posted it on the server Forum. I should rephrase my scenario. The lookup table has only 1 key. To do a lookup against that table, I need to string together 2 fields in the source file for the lookup. I am trying to avoid using the Transformer stage and see if I can concatenate the...

I meant to put this in the PX forum but I didn't do it right. I will move this to the PX forum.

Thanks.

I apologize that I posted it on the server Forum. I should rephrase my scenario. The lookup table has only 1 key. To do a lookup against that table, I need to string together 2 fields in the source file for the lookup. I am trying to avoid using the Transformer stage and see if I can concatenate the...

Hello, I also need to do a lookup with a 2-part key in a PX job agaist a DB2 table. I concatenated the 2 fields in the Lookup stage in the format that's mentioned (Keyvalue1 : ":" : Keyvalue2). The compile was ok but the run generated the following error. main_program: Syntax error: Error ...

Could you please tell me which PX stage I can use to filter out records based on a date that is > Date1 and <= Date2 where Date1 and Date2 are on a seperate file?

I have tried to use JOIN, MERGE and LOOKUP. They all seem to be looking at the keys being equal.

Thank you very much!
Fan

Thanks for the info. For the external routines, I decided to clone the COBOL program on MVS under different names for each conversion function since I can't seem to have them all point to the same program. I then set up individual routines in DS Manager to point to the cloned COBOL programs for each...

Hi All, Could you please help me with a couple questions on the External Routine Stage? I have a COBOL date conversion program that handles 5 different types of conversions (e.g. It can convert a Julian date to a calender date or a gregorian date, etc). The mainframe copybook used by this program ha...