DSXchange

Question: Can you not use to different field names to make the lookup. i.e. SYS_APLC_NM = Table.CD The SYS_APLC_NM will match the Table Code Hi, If it is a 7.5.1, then you can use the column name differently, because where we have to drage the link to match the column names. But, what I am thinking...

Hi Chris,
Just check the environmental variable called APT_JOB_MONITOR in the project level. If it is switch off position, you will not able to see the statictics.

Hi Kumar, Check the Datatype of Divisor, ( I think b in case of your derivation rule). If your output is a decimal and your perfroming division opertaion on a Decimal field, then your divisor datatype should be in decimal. For Ex : If you are performing 100.00/10 and storing in a decimal filed,it wi...

Hi,

Are you sure about, dummy column is present in all four input sequential files and check the nullability of Dummy Col in all four input files. Nullability should be same in all 4 input columns.

Hi,

You can use column generator to create extra columns in a file with the data.

FILE with (50columns) ----- Column Generator--------- FILE with (60 Columns).

Just try out this........

RStone wrote:DB2 table has a valid date, but the join is returning 1901/01/01.

More Information is required to analyse this problem.

More inputs will results great output.

Thanks a lot for this great Suggession.I will take care of this in Future. As I Understood if i will set APT_STRING_PADCHAR as 0x20 and then trim the column RECORD as Trim(RECORD) then we will get [Ready ] as [Ready].Right!!! Yes u r understanding is proper, But, always remember while using APT_STR...

Hi Kunal, Thats nice, you got the result. Regarding Varchar , see if your input data is coming from a extract from database then in the database itself make it output field datatype as Varchar and do the same thing for reference data also. then I am sure u will get the result. But, I observed one mo...

Hi Nagesh, May I know in what case you use RPC for Shared Container function. Do you change metadata dynamically? Hi Kumar, For parallel shared containers, you can take advantage of runtime column propagation to avoid the need to map the meta data. If you enable runtime column propagation, then, wh...

Hi, UNIVERSE.VOCLIB is a hashed system file. It is used to store long commands delivered as standard UniVerse commands that would otherwise appear in the VOC file, to keep the size of the VOC file down and the size of VOC entries relatively uniform. Entries in the VOC file point to paragraphs or pro...

Hi All, The great extend of RCP use will come in picture , when you are using shared containers. I think shared containers will help alot to reduce the coding efforts. I used RCP extensively, while developing Shared Containers. Its so help ful incase of that shred containers. In other cases, I used ...

Hi Kunal, Just remember, whenever your doing lookup the filed datatype should be same in both Main stream and reference stream. here Length is a problem , when ever your performing lookup on CHAR to CHAR field. Length is not at all a problem when you are performing lookup on Varchar to Varchar field...

Hi,

If your requirement is to keep the data in a sequential file then change the Preserve Partitioning option from defualt(Propogate) to Clear in the Advanced tab of stage before sequential file.

Hi All,

I got the solution for this. I just tried to view (Display) the version control by using Date. then I got the todays jobs, whcih I have versioned.

Hi All, I am facing one strange problem. I have intilaised nearly 40 parallel jobs from Devlopemnet to version Control by Giving batchname as ThisDayrelease19102006 . My jobs are intilaised to Version contro, but when I tried to select the jobs in Version control by using Batchname ThisDayrelease191...