DSXchange

I ran a 5 record test file with a null in it and it did not count the Null row in the average, it divided by 4 not 5. I used a sequential stage for input. I expect you may get different results depending on how you are reading the null. I did get a warning, stating it couldn't convert my null to the...

Thanks Ray for all your help. I don't know how you do it, but I hope I can pass on what I learn as you do.

Myles Sigal
Technical Analyst
The MEDSTAT Group
777 E. Eisenhower - 435B
Ann Arbor, MI 48108

myles.sigal@medstat.com
734-913-3466

If you hit the escape key, this invisible window will close and allow you to work in designer. You can change your options in Designer (default > general) to not have the window appear when you start designer. Myles Sigal Technical Analyst The MEDSTAT Group 777 E. Eisenhower - 435B Ann Arbor, MI 481...

Craig - I've debugged with a file that had nulls and nulls mixed with characters and found that the debugger showed spaces where the nulls were. Additionally, I used Seq(input[byte,1]) in a separate stage variable and when I debugged the stage variable returned 32, space, 0 for null. You kindly assi...

My experience with Null data is that the transformer converts it to spaces (making sankar18's suggestion work well). But when written out to a sequential file the null will be written, not a space. If spaces are ok to pass and nulls aren't you'll need to check for the null with a custom routine. Whe...

Ray, here's a very long reply along with the answers to your questions. Thanks again for you assistance. - Myles We are running DS 5.2 on AIX 5. XfrmCustDrug is a Transformer stage. The routines called are all custom, genCharVal, genFin2Val, RptDistribution, and RptControls. There is one hashed file...

Can someone help me with this error? The job aborts with the following warning: Abnormal termination of stage ds00548FacProfDrgBOR..XfrmCustDrug detected Then after resetting I have another information log that states: From previous run DataStage Job 1615 Phantom 4549 UniVerse/SQL: 0 records deleted...

Will I run into any contention issues if I have multiple jobs running where F.Hash is declared common in each? As you can see the creation of the hashed file is unique to the job so the hashed file name is unique. What kind of performance improvement do you think I could expect? Some of these routin...

We use a few routines that read and write to hash files and I'm concerned that we aren't doing what Ray is suggesting, declaring them COMMON. Here's a chunk of code from one of the routines. Would it be wise to declare the hash file up front in the job control code or in the routine, which could be ...

Today I was succesfully able to "trap" the null with the following logic in a routine. I still need to review exactly which characters we will and will not allow to pass and set the values in the if statement accordingly. (Hopefully my little trick with the underscores will keep the format...

I also did try modifying the data type from varchar to char in the source and target column definitions within the transformer stage. This didn't seem to help.

When I test for the null when the job is processing the file, DataStage tells me the character is a space, I used the Seq() function to do this and get a value of 32, space. I've trimmed the string and used the Len() function to get the count the number of bytes and I get the expected trimmed length...

I'm having a little problem with a string containing nulls. The text file has a sting such as "medical device x <null><null><null><null>". I put the data through a custom routine and then I try to trim it. What comes out in the resulting text file is the same thing. The problem is when I a...

What exactly do you want to subtract, Date - x months = new date? There are plenty of date manipulation options, Iconv Oconv functions and ConvertMonth function to name a couple. The only thing I think you would need to watch for is the last few days of the month. What to do if March 30 - 1 month? I...

Ray, could you please elaborate on: From a telnet session to the project, within the DataStage Engine environment, you can run the DS.TOOLS menu, in which option 5 is "Administer processes and locks". Our current method is your "if worst comes to worst" method. Thanks, Myles Sigal