DSXchange

Usage Analysis button (looks like a beaker) from the Manager for the shared container in question.

Use the Oconv/IConv functions. Would need specific examples to provide specific help or you could search the forums for "OConv" for examples already discussed.

You should be fine.

CHAR(34) is a " and is needed separately because of the string delimiter. And make sure your second value is quote-space-quote, not quote-quote - the former will replace each character with a space while the latter will delete each character from the string.

Perhaps just...

There's a button you need to press for that.

Not much to enlarge. You make the lookup an 'inner join' by only taking the rows where the lookup succeeded and using the 'Link Variables / Input' NOTFOUND value for that reference link to check.

Just check to see if the lookup succeeded and constrain the job to only pass rows where that is true. Use the Link Variable NOTFOUND, and Not() it to check for 'found'.

Umm... ok, true. So where are we at with this? Do you still have a question you are trying to get answered?

sreddy - Truncate is the best option? Deleting individual records before inserting them again ("Replace existing rows completely") is not equivalent to truncating the table before inserting. haisen - If that's really what you need to do, I would think you should be still be able to use the original ...

Check out the DSSendMailTester routine in the sdk branch of the repository. Open it up and you'll see what it does to call the routine, you'll need to do the same after job - wrapped up in a custom routine of your own. Either that or call your mail program directly from the command line. Sorry, but ...

The syntax of the 'D' conversion code is fully documented in the online help. From the help Index, type a "D" and that should take you right to D code [BASIC] where the syntax is explained along with a number of examples.

You can also get there from the OConv or IConv topics.

Next time, let's start off the conversation in the correct forum, gorramit.

Did you not see Mr Winkie? I had originally written 'not surprisingly' but in a moment of insanity decided to remove the not and have some fun.

Hmmm... while it may work, the 4 in "D4" isn't needed and (as noted in the documentation) the 'modifiers' of '[2,2,4]' and the delimiter are for output only and are ignored on input. So, suprisingly, all that was needed was exactly what Ray posted.