DSXchange

ray.wurlod

Show us exactly what you did, and that may be an easier question to answer.
Did you build this incrementally, verifying that your conversion to string is successful? If so, what does the string look like? That having been done, does that correspond to the date picture you are currently using?

ray.wurlod

Currently I need to drink a glass of water when George Bush scratches his ear.

Only when he scratches his right ear.

Any idea how to achieve this?

Try and sleep and try and sleep until you get it.

ray.wurlod

Yes, it's OK to set NLSMODE to 0 and test.

But remember the 4013th corollary to Murphy's Law - you won't have a problem if you have a backup.

ray.wurlod

Code: Select all

FUNCTION CountHashedFile(HashedFileName)

Command = "COUNT " : HashedFileName

Call DSExecute("UV", Command, Output, SystemReturnCode)

Ans = SystemReturnCode

RETURN(Ans)

Sheesh!

ray.wurlod

I have done this in India, where the area code can be from two to five digits. You have to document the rules. You need to know what are and are not valid area codes then, if the phone number begins with this, decompose it. For speed, I ended up using a bit-matching technique against position in an ...

ray.wurlod

If it's a Date data type, then the replacement value must be a date. And this must match your date picture (for example "%yyyy-%mm-%dd").

ray.wurlod

Someone at your site needs to ensure that the PATH environment variable is correctly set in the dsenv file so as to include the directory in which the orchoracle executable exists.

ray.wurlod

Can you do all the decompositions in stage variables and load the necessary columns from these?

ray.wurlod

What's your reason for making that statement? As far as I am aware no one in Ascential/IBM has officially declared the demise of server jobs.

An' there's still a truckload of bugs that need fixing in server jobs.

ray.wurlod

Assuming that the data type is a string of some kind, a buildop to remove the thousands delimiter(s), detect the sign and move it to the front of the string seems to be the way to go.

ray.wurlod

Since you're searching for one character, the Index() function will be the most efficient.

Code: Select all

Index("JKLMNOPQR", Right(InLink.ColName,1), 1) > 0

ray.wurlod

Warning!! A job consists of more than one process. For server jobs there is one process (executing DSD.RUN) controlling the job and zero or more other processes (executing DSD.StageRun) which are child processes of the controlling process. Find and kill any child processes before killing the contro...

ray.wurlod

DSR_SELECT errors mean that there's something wrong with the Repository for that project. Given that DS.REINDEX doesn't help I'd guess that it's because of the space in the project name. The internal error (81021 "error writing to pipe") comes from the DataStage RPC mechanism; my guess is that it ca...

ray.wurlod

Read through my post again, particularly the second example.

ray.wurlod

It won't corrupt any jobs. The same can't be guaranteed for the job designs, however. In these you have specified NLS mapping, and now the NLS maps won't be loaded, so no mapping can take place. You will receive lots of warnings to this effect. Further, the results without mapping will need to be ch...

Search found 53125 matches