DSXchange

Double posting, mmm... Try this bit of code. If IsNull(Arg1) or Trim(Arg1,' ','A') = '' Then Ans = Oconv(Date(),'D4/MDY') End Else Ans = Oconv((Iconv(Trim(Arg1),"DMDY")), "D4/MDY[2,2,4]") End You should recognise it from the other post. It's a very slightly modified version of Ra...

if my input is an empty strin or spaces when trim it it is a null value.

This is not true. What you get is an empty string which you would test for as explained. A test using ISNULL on it's own will not work.

Have you tried the modified code from earlier?

Regu.

If you use Ray's simplified code don't forget to also add a check for empty string, otherwise your problem will still persist.

You missed out the '' (empty string). So your code should be if (Not(IsNull(Trim(Arg1)))) and Arg1 # '' Then Ans = Oconv((Iconv(Trim(Arg1),"D/MDY[Z,Z,4]")), "D4/MDY[2,2,4]") End Else Ans = Oconv(Date(),'D4/MDY') End You need to remember that nulls are not always the same as empty...

Try "if (Not(IsNull(Trim(Arg1)))) and Arg1 # '' Then ....".

Regu

Not sure what information you need but you may be able to get it by using the command line utility "dsjob". If it's specifically the category you need then this won't help, but there's plenty more useful info available...


Regu.

You could add another transform after the first and do the second lookup there. I guess you would constrain on the value of the columns derived from lookups in the previous transform. I.e. if they exist then the first lookup in the previous transform was successful so do something. Does this make se...

ICE, DSSendMail is a Before/After routine. This means (if you have it) you can call it in the "Before-job subroutine" dropdown box on the General tab on Job Control. You can also call it as an "After-stage subroutine" from the Properties of some stages. Obviously you'll need to s...

Just in case anyone cares... I did some testing and Job B will abort but it depends on at what point Job A aborted. Not sure but I think that if Job A aborts before the pipe is opened then Job B will continue running indefinitely. For this reason it's worth setting the timeout parameters as suggeste...

Match is a pattern matching operator for which you can get good information on DS Help and Basic Manual.

What your constraint is checking is the format is 3 numeric, 1 char of any type, 3 numeric, 1 char of any type, 4 numeric. i.e. 123-123-1234

Gents, I was wondering how DS works with pipes. I've done a search and read-up pipe's on the forum but was wondering how aborts are handled when writing to a pipe. My scenario is Job A writes to a Sequential file which is used as a driver/source for Job B. These 2 jobs are currently run sequentially...

You need to check the "Enable job administration in Director" box in Administrator. This is in the General tab in Project properties.

I'm not sure how much of a performance decrease you would get. My understanding is that the routine is compiled into the object code of the Job at run-time anyway. It doesn't do a call to an external routine.

If you have time give it a try and let us know if you get any difference.

There is a Case statement and it works as you would expect, check the help or DS Basic pdf. It sounds like you're using the IF statement in the derivation of a Transform stage where proper formatting of code is not really an option, it might be easier to move it to a routine where it can be formatte...

DSParams is a project level file, so be sure to update all projects that this job will reside in. But as Ray has said, you don't need this updated to compile and run the job provided that the @AM is your only issue. It might be easier to just use @FM or even CHAR(254).