DSXchange

Dear All, I am trying to pull the data from AS400 to my DB2 datawarehouse. The process is very slow and when I check in the AS400, I saw the message as follows. I think the reason of taking too long processing time is due to this message. Do you have any idea to solve this issue please? Job 847810/Q...

Dear Chulett,

Thank you.

ICE

chulett wrote:Actually, what you need to search for is DEFFUN. ...

Dear Sainath, I tried this Deffun and call my subrountine but there is no return value. Actually I would like to get the return value from that function. Please find below for my code. NoDays=0 RYYMM=200906 Deffun GetNoOfDays(NoDays,RYYMM) Calling "DSU.GetNoOfDays" Call DSU.GetNoOfDays(NoD...

Dear All,

I would like to call my routine function from another routine function.
May I know how to call it? I used call function but it didn't work.
Is there any idea please?


Thank you,
ICE

Dear Chulett, I define the XPath as TAS/NEW_TA/FOOTER/@lTaNmbr to get the value of that column lTaNmbr but there is null value result. Actually those column has value. I also define the XPath in Derivation column but it doesn't work :( Is there any idea for this problem??? Thanks, The XML Reader sta...

Dear chulett, Ok. Let me find more help forXMLiinput stage. Thank you so much for your information. Thanks, The XML Reader stage is old and has been deprecated. Use the XML Input stage now instead. For documentation there is an XML PACK pdf file in your 'Docs' directory. And an XML Best Practices wr...

Dear arunkumarmm, May I know where can I find it and how to do it? I saw the XPath in help but I don't see in my job :( I don't see enough help info for XML input stage and XML Reader. Is there any other help file for XMLInput and XML Reader stages??? Thank you so much for your help. Thanks, ICE Try...

Dear WoMaWil, I setup that example. There are 5 sample jobs. Right? I already checked all that sample jobs and powerpoint explanation but I wasn't got the solution from there. I also couldn't run those sample jobs :( I got this my job design from that sample Ex4. But the required result wasn't that ...

Dear All, May I know whether I can extract the values excluding the tags(column) name which I already imported in the xml table metadata definition as column name? If can, may I know how to do it? My current job design is as follows: Folder -> XML reader -> sequential file. Folder stage can read all...

Hi Chulett,

I found the function named Nap. I think which is same as Sleep.Thank you so much for your help.

Thank u & Have a nice day,
ICE

chulett wrote:The loop will do whatever you code it to do. If it needs to wait, code in a routine using the 'sleep' function. ...

Hi Chulett, If I use the loop, the job will be repeatedly rerun until the job successful. Right? But I want the job to wait another 10 or 15 minutes and rerun after that period if it was failed. Is there any other way??? Thank so much for your adivse... ICE Loop? Failure trigger perpetuates the loop...

Hi All,

Is there any way to make a failed job to wait a few minutes and rerun itself in job sequencer when the database deadlock occurs?


Thank you,
ICE

Dear MerrillLynch, Thank you so much for your valuable information. I will try this later if I face this problem again. Now I could solve from DS job by using the direct value. Now I don't use the variable. I also doubted on Database. But I did not see this information before I get from you. Luckily...

Dear Ray, I have been solved this issue. I solved this problem by using the direct parameter such as server name. Previous we use the variable. Thank u so much for your reponse. Thanks, Do you have SELECT privilege on the system tables that DataStage needs to access? Search the forum, or your docume...

Dear Roy, YOu are very right. The problem source was because of the date format. I have been solved this issue. Thank you so much for your response. Thnaks, Hi, This usually apears when you run an update query that effects no rows with the givven criteria. So you actually might be getting it the oth...