DSXchange

ICE wrote:Dear Chulett,

I got an idea.
Thank you so much your advise.

Please share your idea with us so that if somebody else is looking for the same problem, it will be helpful for them too!

Thanks Ray for your response! I have a couple of questions: PICKNULL only relates to Iconv() or Oconv() functions. That is what I initially thought when I looked at the documentation. Is this used for those masked decimal conversions? However, these can sometimes be implicit - for example when using...

Gurus, I was just going through the 'uvconfig' file, just for information sake and I have noticed that there is a parameter named PICKNULL in that file. The documentation says that if it is set as '0' then DataStage 'converts' the empty value into '0.00' for number/decimal data. If it is set to '1' ...

karthi_gana wrote: you mean ticket?

Ticket or Case...I believe IBM calls it a Case. The point is, take up the issue with them and provide that documentation to your company's honchos.

yes...i thought they might relased some documents or papers saying that 'Datastage 7.5 version has some limitations on FTP stage....' As I told you, there is/will be no such document. can you test your inbox? Incase if you have the copy, please send it to me.... It was in my previous shop. I do not...

how did you raise the ticket? You need the license information for your company. Ask the administrator for those details and the phone number to contact should be with those details. Usually, when you call, don't expect a solution within that phone call. They will take your case information and cri...

can you send me the link which MICROSOFT explained elaborately about this? I just want to share it with my management. MICROSOFT? It was IBM. They gave me a call and let me know about this final problem. There was some kind of e-mail chain discussing the issue before the phone call, but unfortunate...

how will you use 'quote site' from FTP stage ? karthi_gana, You cannot use "quote site" command from FTP stage as it doesn't support FTP commands. I had exactly the same issue (version DS 7.5.1 Server) as I had to issue quote site lrecl... command as I wanted to increase my Logical record...

You can, I would wager, fix your batch file so it doesn't "hang up". Typically, that means it has stopped to ask for permission to do something and that question never gets answered. Craig is correct. I ran into a similar issue at one point of time during development. My shell script was ...

What about the NAP command. Did you look into it. I do not seem to recall ever having issues with the NAP command. NAP sounds like a viable option. > Does it have any limitations...like the max. amount of time (in milliseconds) that we can enter? > Also, in the DS Help, it says..."will slow do...

I had issues with the DataStage SLEEP function several years ago with V7, it would usually function but sometimes, for no immediately obvious reason, stop working. I recall having opened up a call with support at the time, but as a sporadic problem it was almost impossible to track down. This is ex...

Gurus, First of all, thank you for your help in resolving my earlier query about Trans() function. I am using the SLEEP function to suspend the DataStage jobs from executing if, for a particular row (the latest row) in a Control Table, a couple of fields are not populated. These fields are to be upd...

whenever I was facing this problem i used to compile the job and rerun it. It was working fine. Usually, the jobs run as part of, say, a daily schedule and it is always a pain-in-the-neck task to see when it aborts, reset/compile it and re-run it. I think this is due to no. of process running at th...

Hi, hashed file --> Aggregator --> hashed file In the first hashed file, I'm having 11 columns, 10 of them are keys. In the second one is the same but with 8 keys. When I sumarize using aggregator, it gives me the same ammount on both hashed files. The hashed files characteristics are the same. Tha...

1) No lock. Are the writes employing write cache? If so they will not be visible to other processes until the job finishes and the cache is flushed to disk. 2) If it's the same hashed file, you should never need to open it more than once. Place the file variable in a COMMON area of memory, so that ...