DSXchange

Unless you're getting NLS warnings, NLS is not the culprit. Does using a sparse lookup give the right results? If so you need to compile in trace mode, or insert a Peek stage, to see what's actually being loaded into the virtual Data Set when not in trace mode. No NLS related warnings. Sparse looku...

Can you change the lookup to a sparse lookup, that way you will get SQL generated by DataStage. If that fails, then copy the SQL into your DB2 query tool and plug in some actual data values to see if the lookup fails there as well. Arnd, I believe there is no option as "Sparse" in the DB2...

Thanks for the reply, Arnd. I'll try your suggestion and get back to you.

Whale.

Hi All, My job is as follows: DB2 UDB stage | | | | CFF -------> Xfmr1 --------->Lkp Stage -------> Xfmr2 -------> DataSet The DB2 lookup table has two keys. I'm generating the keys on the primary link (output link of Xfmr1 or input link to the lookup stage) through which the lookup is done to the D...

I cannot share it because I'm not the owner of the document. Please contact 'Ron' at elder700@yahoo.com to request a copy. And please do not post duplicate messages and do not create a urgent situation as this site operates on a voluntary basis. That will only delay postings by 'premium posters'. Th...

I think it is on a per request basis. I'm still working on the windows version (7.5x2). Will post once I'm finished.

Hi,

You cannot hijack a thread belonging to totally different topic. Please post your question by posting a new topic.

Thanks,
Whale.

Hi all, I'm trying to build a custom parallel routine/function for re-usability. Is there any procedure or documentation that helps in understanding the steps to successfully build and use a parallel routine? I tried searching but couldn't find any post that basically outlines/describes the steps re...

Thank you, Ray. The theory is correct. There are 4 files for a 4 node config. file.

Hi All, If we are using 4 -way config file, and the job has a target Oracle Enterprise Stage which has the write method set to 'load' and write mode set to 'Append'. Will the SQL loader be initiated/called 4 times? Similarly, if we have a 8 -way config file, will the SQL loader be initiated/called 8...

Thank you for the reply, Ray. If I change the query in the lookup table stage (DB2 stage) to the following (Replace the incoming Seq. file fields with a question mark as below): SELECT cd2.cusrut_comp_customer_number, cd2.cap_seq_nr, cd2.cap_comp_nr, cad2.cap_seq_nr, cad2.cust_addr_fmt_cd, cu2.pers_...

Hi All, I'm trying to understand how placeholders work with a lookup stage looking up a DB2 table. The job is as follows: DB2 UDB Stage | | | | Sequential File Stage -------------------------LookUp Stage---------------Sequential File Stage I want to run the following user defined query in the 'DB2 U...

Many thanks, Ray! I will try that and get back.

Regards,

Whale.

Hi all, I have a simple job design as follows: Sequential file Stage ----> Xfmr -----> DB2 table One of the mapping is: Sequential.FirstDate ---> DB2table.FirstDate Sequential.FirstDate is of Varchar(8) datatype and is of the format yyyymmdd (20050914). DB2table.FirstDate is of the Date datatype. Ho...

Contact support. They have a patch for it. I don't recall the case number.