DSXchange

You can use cut-and-paste. Put $PROJDEF into the Description field (clear), cut it from there (Ctrl-X) and paste it (Ctrl-V) into the Password or Default Value field. I presume you're aware that to enter a default value for an encrypted parameter you have to double-click in the Default Value cell to...

Only if the source timestamp is a string. What if it's really a timestamp? The OP was unclear on this point, which is why my solution was couched in general terms.

The major flaw is that you have not considered all possible characters. A more general, and more efficient routine, might be FUNCTION AlphaSpace(TheString) * Returns alphabetic and space characters only Ans = "" If IsNull(TheString) Then Ans = @NULL End Else CharCount = Len...

Yes, it can. When you're importing the table definition, or on the Format tab of a Sequential File stage, you can represent any non-printing character as its three-digit decimal ASCII code (for example 001 for Ctrl-A) or as its four-digit hexadecimal Unicode code (for example 0001 for Ctrl-A).

You're on the right track. You just need an If..Then..Else to handle the first hour of the day separately from the other case. And in the first hour of the day you'll need to convert the date as well as the time. Some stage variables will help you to keep track of everything, even though it could be...

On Windows you will also need uvwalk to create the source file for the uvbackup command.

That ("all the files") is in fact easier. Cmd = "mv " : SourceDir : "/* " : TargetDir However beware that some UNIX operating systems do not permit mv between file systems. In that case you will need to use cp followed by rm. Cmd = "cp " : SourceDir : "/* " : ...

Delta is the Greek letter that mathematicians use to indicate "change".

Delta logic, one must surmise, includes any mechanism for working with changes, typically detecting and/or capturing the changes in data.

Search (here, Google, TDWI) for "slowly changing dimension" or "SCD".

Welcome aboard. :D

Looks like you're trying to read a 14-digit number into Decimal(12,1). Hey, it just won't fit!

Perhaps you have specified incorrect metadata (column width or delimiter), or maybe you need a larger Decimal data type.

Yes. Stop being impatient. Don't shout. DSXchange is an all volunteer site, no-one gets paid (apart from the webmaster). Folks post as and when they can. If you want urgent answers, sign up for premium service from your support provider and learn how much "urgent" really costs. I thought narasihma's...

Check whether the dsprcd process (DataStage RPC daemon) is running on the server. Where it is not, it's usually a result of shutting down DataStage then attempting to restart while processes still have port #31538 bound (which can be determined with the netstat command). You can start dsrpcd in debu...

welcome aboard. :D

If you Search you will find that the answer to this has already been posted. More than once.

Extract the date, convert to Julian, add 1, convert back to date and re-assemble the timestamp.

Which piece of this was unclear? To do insert only, you need to check first whether the key already exists in the table. Depending upon the size of the table, use a sparse lookup or pre-load a list of keys into something that can serve a reference input link to a Lookup stage. Use a Filter stage to ...

Would it not be better to use a find command with -exec to execute the mv command? Move = "cd " : SourceDir : " && find . -exec mv {} " : TargetDir : "\;" Add filters to limit the search to one level and only to objects of type file (and anything else ...