DSXchange

Jim It is faster to nest if statements or case statements than to check for 50 things. if x=1 or x=2 or x=3 then if y=1 or y=2 then end end is faster than if (x=1 or x=2 or x=3) and (y=1 or y=2) then end Kim. I will not contest because I have no idea. All I know is htat I am just starting to get my...

kduke wrote:Jim

I do not think there is one. If there is then it is an underscore.

Kim.

AGGGGGGG underscore was the first one that i tried

Jim

Yup u are right. I see what my fat finger had done and now it works....This is great now I can move on to the harder logic in the code.
Thanx
Jim

btw how do i get this code to wrap to the next line. I realy need to be able to look at all of this at once and not scrol.
Jim

Here's your logic corrected: Begin Case * (PACIFIC TRADE GENERAL): Case ( Arg1 = '588' Or Arg1 ='570' Or Arg1 ='580' Or Arg1 ='582' Or Arg1 ='583' Or Arg1 ='560' Or Arg1 ='559' Or Arg1 ='549' Or Arg1 ='565' Or Arg1 ='557' Or Arg1 ='552' Or Arg1 ='538' Or Arg1 ='555' Or Arg1 ='579' Or Arg1 ='566' Or...

Arg1 = 583 TRUE Arg2 is not MARSHAL ISL OR Arg2 is not KWAJALEIN Your code as written appears to be true to me in both cases you've presented. MARSHALISL is not KWAJALEIN AND 583 is one of the Arg1 choices. Likewise for Test. Test is not MARSHALISL and Test is not KWAJALEIN so they are both true AN...

First things first, do you like the INLIST function better? And do you see how you can write FUNCTIONS to make life easier (what I call the Bag of Tricks). Okay, how about you paste two test cases, one that should prove TRUE and the other FALSE. We can workout your logic from there. I formed your l...

Jim, BASIC has no inherent INLIST function, so I wrote one for you. Create a new FUNCTION in DS Manager just as I describe in the top portion of my most recent post. Then, compile it and test it. Enhance it all you like, putting in TRIMs, UPCASES, whatever. I have done what you said and I am gettin...

What is this bit of code? Calling "DSU.INLIST" Is that a built in fucntion of ds 7x? I get the error Program "DSU.casetest": Line 27, Unable to open the operating system file "DSU_BP.O/DSU.INLIST". [ENOENT] No such file or directory Program "DSU.casetest": Lin...

Begin Case * (PACIFIC TRADE GENERAL): Case ( Arg1 = '588' Or Arg1 ='570' Or Arg1 ='580' Or Arg1 ='582' Or Arg1 ='583' Or Arg1 ='560' Or Arg1 ='559' Or Arg1 ='549' Or Arg1 ='565' Or Arg1 ='557' Or Arg1 ='552' Or Arg1 ='538' Or Arg1 ='555' Or Arg1 ='579' Or Arg1 ='566' Or Arg1 ='546' Or Arg1 ='574' O...

I have the following code Begin Case * (PACIFIC TRADE GENERAL): Case Arg1 = '588' Or Arg1 ='570' Or Arg1 ='580' Or Arg1 ='582' Or Arg1 ='583' Or Arg1 ='560' Or Arg1 ='559' Or Arg1 ='549' Or Arg1 ='565' Or Arg1 ='557' Or Arg1 ='552' Or Arg1 ='538' Or Arg1 ='555' Or Arg1 ='579' Or Arg1 ='566' Or Arg1 ...

I need to know the character string or process that will alow me to wrap my basic code to the next line when I write the code in manager.
Thanx
Jim

I need to know the character string or process that will alow me to wrap my basic code to the next line when I write the code in manager.
Thanx
Jim

In a transform with a reference table how do you denote an outer join? Jim Hmm this is an interesting question...I realy didnt stop to think to hard about it till after the post was up. Outer joins arent good for an etl tool im thinking now, it will let through the execptions. Maybe a reject file??...

In a transform with a reference table how do you denote an outer join?
Jim

In a transform with a reference table how do you denote an outer join?
Jim